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

Optional Filter on Watch Records module - how do I filter on two things within this module?

Avatar

Level 3

I'm watching for a status on a task but the task name needs to be part of the filter too. I can do 'status=CFX' and I can do name='Write creative brief' but how do I include both of these in the one 'Optional Filter' field in the module properties? I've tried AND and also nothing because the Fusion help says AND is the default anyway. I could put a filter on the route to the next module but it would be neater if I could include both criteria on the 'Optional Filter'. Thanks v much

4 Replies

Avatar

Level 4

Hi Stuart,

Great question. Essentially, this field allows you to append any filtering capabilities offered by the Workfront API. A useful reference for this filtering capability is this API Basics page (specifically the GET and search behavior).

To specifically answer your question, the syntax for the filter would be:

status=CFX&name=Write Creative Brief

You could also get fancier with "modifiers". For example the following would look for tasks that have that status and the task name has "Write Creative Brief" contained somewhere in it in a case-insensitive manner.

status=CFX&name=Write Creative Brief&name_Mod=cicontains

Lastly, you can also get even fancier with "OR" groupings to identify multiple conditions and group them together in different groups.

Hope that helps. Cheers. 0694X00000DU21CQAT.png

Avatar

Level 3

Thanks v much, Darin. The more I dig the more power i find! Time to head to the API basics page! Thanks again, Stuart

Avatar

Level 4

I usually use the Workfront report tool to create the filter that I want, switch to text mode, and then paste that into Fusion, removing line breaks and replacing spaces with &. ~Jeff

Avatar

Level 3

Hey Jeff. Thanks for that. What a very splendid idea. Thanks v much. All the best, Stuart