Filter Collection question
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-10-22 10:31 AM
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
Forgot to mention i'm filtering an existing collection by the Filter action
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-10-22 11:22 AM
Hi JP,
What kind of filtering are you using:
---------------
Paul
Sweden
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
---------------
Paul
Sweden
Happy coding!
Paul, Sweden
(By all means, do not mark this as the best answer!)
Paul, Sweden
(By all means, do not mark this as the best answer!)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-10-22 12:09 PM
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
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
KirtiMaan Talwar
IA Consultant
Deloitte USI
IA Consultant
Deloitte USI
