Constrain a found set with multiple field values from variable

[Bimsickle]

I have created a find script, which loops through a variable of known ID's (created from a report).

Then omits them as they are already "known"

 

Constrains the found set to CustomerType::1

Constrains it again to StatusActive::1

 

I would like to do a third constrain, but for multiple values.

 

I have selected reps stored as a variable $$REPID which is a list.

 

I cannot figure out how to either loop through the list and constrain the list with all rep id's from the list.

 

Normally I would do this

 

enter find find

set repid field GetValue($$RepID;1)

Set Variable $counter;2

Loop

new record request

set repid field GetValue($$RepID;$Counter)

Set Variable $counter;$Counter+1

Exit Loop if $Counter > ValueCount($$RepID)

End Loop

Perform find

 

However that is a new search rather than constraining the current list

 

Any ideas?

[jbante]

There is a Constrain Found Set script step.

[Bimsickle]

Yeah but I can't script in unknown filters it's hard in the constrain step.

With each constrain doing just that, multiple constrains on the same field in a row don't work as the data has already been reduced

[Bimsickle]

Never mind I got it!

 

Enter find mode add requests then "Constrain Found Set" rather than find....

 

Live and learn hey.

 

Thanks Jbante