Skip to main content

Hi,

Is it possible to write cursor concept in advance search of IFS 9 Application,

I guess it is limited to SQL queries only. 

 

Note:I have a subquery which returns more than 2 values and I need to display it, it can be done using cursor concept.

If it’s an advanced search can’t you use IN clause to pass multiple values to the search box? Something like below in the where condition:

 

part_no in (select part_no from inventory_part_in_stock i where i.qty_onhand> 0)

Reply


Terms & ConditionsCookie settings