I have a portal that I need to filter on one or more global variables, or no filter at all if all the globals are empty.
For example ... I have the following fields: invoice number, sales order number and customer po number (inv_no, so_no, po_no). And I have the following global variables: g_inv_no, g_so_no and g_po_no in a globals table.
The user may want to filter the portal's records on just the invoice number. Or just the SO number. Or possibly even all three at the same time. Or, if the user hasn't entered anything to filter at all (all globals are empty) then show all the records in the portal.
Doing this in list view isn't a problem, but I need to be able to do it in a portal. Having trouble wrapping my head around it. Any suggestions?