Advanced Search doesn't support writing actual PL/SQL cursor logic to return and match against several values from a subquery — is there still a way to filter on a subquery that returns multiple rows/values?

All FAQ questions / Platform, Aurena, and customization

Answer

Yes — Advanced Search accepts plain SQL WHERE-clause-style expressions, so a standard SQL IN clause with a subquery achieves the same effect as needing cursor logic, without actually requiring one: for example, part_no IN (SELECT part_no FROM inventory_part_in_stock i WHERE i.qty_onhand > 0) matches against every part number returned by that subquery. This covers the common case of matching against multiple dynamically-determined values, which is usually what a cursor-based approach would have been used for anyway.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Platform, Aurena, and customization questions