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?
Solved! Go to Solution.
Views
Replies
Total Likes
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.
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.
Thanks, Richard! This looks to be exactly what I am looking for. I will give it a try.
Shawn
Views
Replies
Total Likes
Worked perfectly! Thanks again.
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies