How do you create a "Not In" Filter

[Rick_Funches]

Is there a " Not in" function for a filter?

I have a scenario where one field must have a value in an ID field and I am excluding records that have a value of “Draft, Cancelled, Closed”

[Msquare_Automation]

Hi @Rick_Funches,

You could use, “Value DOES NOT MATCH PATTERN (Draft|Cancelled|Closed)”

For single value, You could use “Not equal to” or “Does not Contain”

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel

[Rick_Funches]

Thanks. I will give that a try

[Rick_Funches]

That didn’t work for me, so I tried a different technique from another thread. But when using this technique it does not allow a valid record to pass through the filter. Any thoughts

[Msquare_Automation]

Hi @Rick_Funches

I could see that your filter needs some corrections.
Please follow the image for your reference

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel

[Philippe_Billet]

Hi @Rick_Funches,

I gave this solution to a similar problem.
You may like it.

BR,

PBI