How can I branch the workflow process to find information?

Body

The scenario is that you want to find out whether any items in a purchase order contain hazardous materials. Did you know that you can branch the workflow process to a safety review to find out whether any of the items on the purchase order contain hazardous materials? How?

You create a condition with nested sub-selects that looks through the purchase order lines to determine whether any of the lines contain an item with a hazardous ID. If any of the items contain a hazardous ID, the condition processes as true. If any of the items do not contain a hazardous ID, the condition processes as false. Use the following expression to specify this condition:

:PONUM in (select pl.ponum from poline pl where exists (select * from item where itemnum = pl.itemnum and hazardid is not null) )