topic Re: Filter Collection question in Product Forum

Filter Collection question

JohnPerry — Thu, 06 Oct 2022 09:31:07 GMT

Im trying to create a filter for a collection but using multiple criteria. For example, I'm trying to get it to find data from Field 1 that has either Criteria 1 or Criteria 2. I can get it to work with just 1 criteria and if I do it with another Filter collection item it doesnt work. I'm not that good with SQL language myself so any help would be great.

Forgot to mention i'm filtering an existing collection by the Filter action

Re: Filter Collection question

PvD_SE — Thu, 06 Oct 2022 10:22:35 GMT

Hi JP,

What kind of filtering are you using:

Filter data from an XL into a collection
Filter an existing collection by the Filter action
Filter an existing collection by using a Loop action

Happy coding!
---------------
Paul
Sweden

Re: Filter Collection question

kirtimaantalwar — Thu, 06 Oct 2022 11:09:30 GMT

Hi John,

You can try "OR" operator in your Filter Collection expression. Please find below sample expression for your reference -

"[Field1] like 'Criteria 1' or [Field1] like 'Criteria 2' "

Many Thanks!!
KirtiMaan Talwar