AnsweredAssumed Answered

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

Question asked by binu.alexander on Sep 11, 2015
Latest reply on Sep 11, 2015 by 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  




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