AnsweredAssumed Answered

Multi Field Portal Filtering

Question asked by RPaulH on Nov 11, 2014
Latest reply on Nov 13, 2014 by philmodjunk

Title

Multi Field Portal Filtering

Post

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.

Outcomes