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

[acorya]

I have a follow up question on this topic. In my case I want to use the Optional Filter to filter in issues whose queue topic ID is one of several. In a report it would look like this:

The textmode for this filter separates the queueTopicID's with a tab.

queueTopicID=6390aa670008106db9777276d7d2d0a1	639ae26e00026841880ad5b0ed91aeff	6414884e000be9c4e086e8785eb04002
queueTopicID_Mod=in

But the tab does not work in fusion's Optional Filter. I also tried comma and pipe.

queueTopicID=6390aa670008106db9777276d7d2d0a1	639ae26e00026841880ad5b0ed91aeff	6414884e000be9c4e086e8785eb04002&queueTopicID_Mod=in

queueTopicID=6390aa670008106db9777276d7d2d0a1,639ae26e00026841880ad5b0ed91aeff,6414884e000be9c4e086e8785eb04002&queueTopicID_Mod=in

queueTopicID=6390aa670008106db9777276d7d2d0a1|639ae26e00026841880ad5b0ed91aeff|6414884e000be9c4e086e8785eb04002&queueTopicID_Mod=in

None of these delimiters worked. What is the proper way to do it??

The only way I could find to do it was a really big OR statement like so:

queueTopicID=6390aa670008106db9777276d7d2d0a1&queueTopicID_Mod=in&OR:1:queueTopicID=639ae26e00026841880ad5b0ed91aeff&OR:1:queueTopicID_Mod=in&OR:2:queueTopicID=6414884e000be9c4e086e8785eb04002&OR:2:queueTopicID_Mod=in

This is going to get out of hand when there are many queueTopicID's to include so I'm looking for a more efficient way to do it. Any ideas?

Thanks!
Cory

[Doug_Den_Hoed__AtAppStore]

Hi @acorya,

Untested but from memory, I suggest you try "repeating yourself", such as this:

queueTopicID=6390aa670008106db9777276d7d2d0a1
queueTopicID=639ae26e00026841880ad5b0ed91aeff
queueTopicID=6414884e000be9c4e086e8785eb04002
queueTopicID_Mod=in

Regards,

Doug

[acorya]

Thank you Doug! You're the best!

The final code that worked was this: 

queueTopicID=6390aa670008106db9777276d7d2d0a1&queueTopicID=639ae26e00026841880ad5b0ed91aeff&queueTopicID=6414884e000be9c4e086e8785eb04002&queueTopicID_Mod=in

I placed it here in the Optional Filter of a Watch Record trigger module as shown

 

[Doug_Den_Hoed__AtAppStore]

Fabulous @acorya,

That one's not obvious, so at your convenience, I suggest you mark it as correct to give our next contestant some relief.

Regards,

Doug 

[acorya]

Dang, I can't do it. I think the OP has to mark it solved.