Solved

Advance search in IFS 9 apps

+9

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.

Best answer by asanka

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)

Did this topic help you find an answer to your question?

+7

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)

~hope is a good thing, maybe the best of things, and no good thing ever dies...

Sign up