Skip to main content

In IFS10 and 9 it was possible to write criteria's in the where clause of a data source as:
 

column1 in (select column1 from ifsapp.view2 where Active =’True’)
i.e. if column1 is present in another view and where clause is fulfilled, that whole select is valid. (I did not add view name and select, where for the view that would have to be entered own columns in data source editor)

This does not seem to work in IFS Cloud using SQL data sources. Would it be possible to do anything similar using a projection? in that case, how?

Hi @Marake 

you can’t join views or tables in a data source. In IFS APPS10 we use IALs.

Do you still have IALs in IFS Cloud?

yes, IALs is the only way we have found so far to handle this.

They still exists in Aurena, and works somewhat better as you actually can see the deployed code now.

However, the combination of IAL and lobbies is not the best as you cannot click on the lobby element to open the source of the information.

Question to IFS: are you looking into future functionality to join tables in lobbies?

Hello,

Same issue here, we  moved from IFAPP10 to IFS Cloud.
In Lobby Data source designer, we can not call anymore the IAL View.

In APP10

in the “view” field we called the IAL “ifsinfo.here_ial_name”  and it worked.

In IFS Cloud

The IAL is also available, I double checked by querying it in a quick report with the statement “SELECT * FROM ifsinfo.here_ial_name” and it retrieve the IAL data.

but in the IFS Cloud Data source designer, when I write the “ifsinfo.here_ial_name” in the “view” field a got the error message 

“Unable to find ifsinfo.here_ial_name view”

 

Has someone an Idea on how to retrieve the dta from an IAL in a lobby data source ?

 

 Thanks in advance for your support.

kind retgards,

Anthony 

It should be noted that the issue I mentioned in this topic has been resolved in later versions of IFS cloud. I think we were running 22R2 at the time I wrote this.

Reply


Terms & ConditionsCookie settings