Filtering for buried text

Question

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?

Richard_Le_ · Accepted Answer

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.

Sign up

Login with SSO

Login to the community

Login with SSO