Solved

Use IAL on Lobby Data Source

  • 21 March 2022
  • 6 replies
  • 1106 views
C
Rank
Userlevel 3
Badge +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

icon

Best answer by Technical Outlaws 21 March 2022, 15:54

View original
ARCWIDE FRANCE / IFS Project Manager
This topic has been closed for comments

6 replies

S
Rank
Userlevel 6
Badge +12

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

Just because something is part of a plan doesn't make it right.
C
Rank
Userlevel 3
Badge +9

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

ARCWIDE FRANCE / IFS Project Manager
Technical Outlaws
Rank
Userlevel 5
Badge +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.
S
Rank
Userlevel 6
Badge +12

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

Just because something is part of a plan doesn't make it right.
C
Rank
Userlevel 3
Badge +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.

ARCWIDE FRANCE / IFS Project Manager
M
Rank
Badge +1

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

Terms & ConditionsCookie settings