Filtering for buried text | Community
Skip to main content
S
ShawnMe
January 29, 2025
Solved

Filtering for buried text

  • January 29, 2025
  • 1 reply
  • 525 views

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?

Best answer by Richard_Le_

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.

1 reply

R
Community Advisor
Richard_Le_Community AdvisorAccepted solution
Community Advisor
January 30, 2025

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.

    S
    ShawnMeAuthor
    January 30, 2025

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

     

    Shawn

    Terms & ConditionsAccessibility statement

    Loading footer...