Multi Field Portal Filtering
I have hypothetical Table1::Order and Table2::Items, and there are 5 fields in each table that I need to filter and show matching records in a portal. The portal filter need to match any combination of the 5 fields which has data entered and show only those records. If field1 has data and field2-field5 are empty then only match field1, but if field1 and field3 have data and the others are empty match only field1 and field3.
Is the easiest way to write the calculation that takes all possibilities(15) into account and filters based on that? I was hoping that I might be missing some cool slick voodoo that might work.