How to filter one field on multiple values within one formula

[Douglas Majors]

For Scribe online, withinFetch I am trying to filter one field on 3 different values within one formula. It would look something like this:

new_companyrelationshiptypeid = "4d06bd78-1322-e211-8b95-78e3b508f865" or "4261b3bc-1322-e211-8b95-78e3b508f865" or "4261br56-1322-e211-8b95-78e3b508f865"

It appears that I need to run it on one line (or fromula) and not enter the fieldmultuple times with ORs between them within the GUI, as it runs the insert/update multiple times ifnew_companyrelationshiptypeid = more than one of the above answers.

I haven't been able to figure out how to enter multiple criteria in one formula. Any help is greatly appreciated.

Thanks.

Doug

[Kirsten Smith]

Please update this entry to include the program you are using.

[Ash Arendsz]

HiDoug,

You can add multiple lines with ORs in the filter tab of your Fetch block.

In your example it will fetchmultiple records orinputs (your fetch resultset can be 0,1,2 or 3 records )

Since you only want to have one insert or update, you would need to add an extra logic within your fetch loop, (using IF block) to decide which one of your fetched records do you want to use for your output (insert or update).

In building out this logic you can also use the scribe labs variable connector(or a nested IF blocks construction) to keep track of the state in your map for only 1 output.

I hope this helps you.