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  

 

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

Outcomes