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

[stuartcairns]

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

[darin_patterson]

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.

[stuartcairns]

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

[jrieth]

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

[stuartcairns]

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