Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

How to restrict to just the word I want in a contains filter within a report.

Avatar

Level 5

I am looking to run a filter that pulls any project that's name contains the word IVA. The problem is there are words with the letters iva within them. Is there a way to dictate that I only want the ones where IVA are their own word? I tried typing a space before and after but that didn't work.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Administrator

I just checked with support and they said you're on the right track... but to think about adding a filter for does not contain through text mode. Here's a simple example for you to experiment with:

AND:1:name=123

AND:1:name_Mod=cinotcontains

AND:2:name=Gate

AND:2:name_Mod=cinotcontains

name=test

name_Mod=cicontains

View solution in original post

0 Replies

Avatar

Level 5

If there isn't a way to tell it to only use when just IVA is there a way to add a list of words not to include?

Avatar

Correct answer by
Administrator

I just checked with support and they said you're on the right track... but to think about adding a filter for does not contain through text mode. Here's a simple example for you to experiment with:

AND:1:name=123

AND:1:name_Mod=cinotcontains

AND:2:name=Gate

AND:2:name_Mod=cinotcontains

name=test

name_Mod=cicontains

Avatar

Level 5

Yay it worked! Have I mentioned how much I Love this community??? Thank You So Much.

Avatar

Administrator

Wonderful! I'm so glad. I'm so glad you're part of this community!