Skip to main content
Solved

Use IAL on Lobby Data Source


Forum|alt.badge.img+9

Hi,

For a customer, we create a basic IAL.

Now I use this IAL on a lobby data source

I have an error message : unable to find TEST_CUSTOMER.

I tried with &AO..TEST_CUSTOMER, &IAL..TEST_CUSTOMER, IFSAPP.TREST_CUSTOMER, but always the same problem.

 

If somebody have an idea.

Regards,

Christophe

Environnment 21R2 on IFS Cloud

Best answer by Technical Outlaws

I think there is a way around this albeit an extra step.

  • Create the IAL.
  • Create a Quick Information Source utilising the IAL.
  • Create the Lobby Data Source with the newly generated QIS view.
View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

6 replies

Forum|alt.badge.img+12
  • Hero
  • 217 replies
  • March 21, 2022

Christophe, are you using two periods between the “&IAL” and the object name? I think you only need one at this point. I just created a Quick Report, and the following query was accepted:

SELECT * FROM &IAL.<View Name>

Just one period, unlike the dual periods you need to use when creating the IAL itself (I am not entirely sure why that is, but assume it is due to the IAL being created with another layer of indirection?).

So, just speaking from some limited experience, two periods when creating the IAL, as in:

&AO..Customer_Info

and one period when consuming data from the deployed IAL, as in:

&IAL.<IAL view name>

(This is all assuming the IAL has permissions properly set so that it is visible to whoever is running the query.)

Hope that works for you…

 

Joe Kaufman


Forum|alt.badge.img+9

Hi @sutekh137, Thanks for your mail but it don’t works. Are you on 21Rx ?


Technical Outlaws
Hero (Employee)
Forum|alt.badge.img+11

I think there is a way around this albeit an extra step.

  • Create the IAL.
  • Create a Quick Information Source utilising the IAL.
  • Create the Lobby Data Source with the newly generated QIS view.

Forum|alt.badge.img+12
  • Hero
  • 217 replies
  • March 21, 2022
Christophe BUSSI wrote:

Hi @sutekh137, Thanks for your mail but it don’t works. Are you on 21Rx ?

 We are on APPS10 on-premise.

can you make a Quick Report against the IAL? The Quick Info Source idea sounds like a good one to get this working in Aurena/web. I do not have much experience with that.

 

Thanks,

Joe Kaufman


Forum|alt.badge.img+9

it works using the quick information source and use QFACT_xxx_IAS$ like view in the lobby data source designer.

Best thanks for all.


Forum|alt.badge.img+1
  • Do Gooder (Partner)
  • 1 reply
  • February 22, 2023

For me it worked by changing &IAL. to ifsinfo. before the IAL name.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings