1 Reply Latest reply on Dec 12, 2012 4:43 AM by Mike_Mitchell

    Performing a search based on members of a value list.

    liltbrockie

      Hi, what is the best way to script a search for records based on all the members of a value list?

        • 1. Re: Performing a search based on members of a value list.
          Mike_Mitchell

          Hello, liltbrockie.

           

          Depending on exactly what you're trying to accomplish, one very quick way is to put a global field in your table and define a self-join from that global to the field in which you want to search. Then, stick all the values in the value list into the global and use Go To Related Record. The relationship engine will find all the records in the current table that have a match.

           

          Barring that - assuming you don't want to mess with your Relationships Graph - you can store the values in a variable and loop over them, creating a new Find request for each one ... but that's not as efficient.

           

          HTH

           

          Mike