12 Replies Latest reply on Sep 11, 2015 6:43 AM by binu.alexander

    How to Perform a find in script , based on list of values stored in  variable ?

    binu.alexander

      In the solution that I am working on I perform a find and set a variable  $mrvrlist which stores   Primary keys of a set of records as list ( from summary field )

       

      Now I want to find a set of records in the target table  which will EXCLUDE the records referenced in the list ...

       

       

      I have  a list  of   primary keys  ( V1 , V2 , V3 )  this is stored in a variable called  $mrvrlist

       

      I need to PARSE the list from the variable  and omit records based on the values

       

       

      so    finally i need      V4 , V5, V6 V7 V8  etc  .... which excludes the earlier selected volunteer records

       

      I hope I am clear on this ....

       

      Need some ideas  

       

      SCREENSHOT OF SCRIPT

       

      Screen Shot 2015-09-11 at 3.10.48 pm.png

      Steps 1 to 6 are working ....

       

      I need to omit records in the volunteers table   where  primary key   =  V1 , V2 , V3