Expand my Community achievements bar.

SOLVED

Filtering for buried text

Avatar

Level 4

Is there a way to create a report filter that find text that is not standalone?  My filter is project name contains SR:,  but it is not finding those names that have an underscore before the searched-for text (eg. 00_SR:).  In FileMaker (my previous tool) I would use an asterisk to represent "wildcard" text — *SR: would find the text SR:, whether standalone or appending other text.  Is there an equivalent way to do this in Workfront?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

 

Instead of using a "contains" filter modifier, I suggest trying a "like" or "cilike" modifier. Like modifiers work similarly to contains modifiers, but they enable you to insert wildcard characters to break up the text. So your filter would look something like this in text mode:

 

name=%sr%
name_Mod=cilike

 

You can read more on filter modifiers and how they are used here.

 

Best Regards,

Rich.

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

Hi,

 

Instead of using a "contains" filter modifier, I suggest trying a "like" or "cilike" modifier. Like modifiers work similarly to contains modifiers, but they enable you to insert wildcard characters to break up the text. So your filter would look something like this in text mode:

 

name=%sr%
name_Mod=cilike

 

You can read more on filter modifiers and how they are used here.

 

Best Regards,

Rich.

Avatar

Level 4

Thanks, Richard!  This looks to be exactly what I am looking for.  I will give it a try.

 

Shawn

Avatar

Level 4

Worked perfectly!  Thanks again.