6 Replies Latest reply on May 10, 2016 7:47 AM by ndveitch

    Build find from multiple list

    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?