AnsweredAssumed Answered

Build find from multiple list

Question asked by ndveitch on May 4, 2016
Latest reply on May 10, 2016 by ndveitch

Hi,

 

I need to find the best way to build a find criteria from multiple lists. For example, I have a layout where the user can select from various checkbox fields, Years ( 2005 - 2016), Countries ( UK, USA, South Africa, ...) and Industires ( Agriculture, Teaching, Development, ...) for example. Then I was thinking of scripting a find request to search a table for the values selected in the various checkboxes.

 

If the user selected;

 

Years - 2015 and 2016;

Countries - USA ;

Industries - Teaching, Development, and Finance

 

Then the script would have to build the find request, but I am unsure of how to sort the find options. The resulting find request would look something like this,

 

IndustriesYearCountry
Teaching2015USA
Teaching2016USA
Development2015USA
Development2016USA
Finance2015USA
Finance2016USA

 

How would I get it to work that it first sorts which find request would have the most options to the least and then loop through the variables to build the find requests accordingly?

Outcomes