Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Constrain a found set with multiple field values from variable


Recommended Posts

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


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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use