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?
