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,
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?