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 ?


      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  




      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