Solved

Advance search in IFS 9 apps

Userlevel 5

+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.

icon

Best answer by asanka 3 June 2021, 00:11

Userlevel 4

+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)

Sign up