How to filter to show mulitple task types with different states for each type?

[zdimaria]

I'm having trouble figuring out how to set the filters properly.  

We need to show all of our shots which have a Tracking Task with a Complete State  AND show Lighting Tasks for those shots in ANY State.

So basically, how do you group a Type filter and State filter together?  Right now it seems its just applying any filters to everything. I've tried adding a second Type and State filters, but how do I link them together? 

 

To clarify a bit,  how do you AND and OR filters?   I see the advanced filters but there is no way to AND or OR that I can see?

So how to do:

 

Task Type is Tracking AND Task Status is Done

OR

Task Type is Lighting

[Mattias Lagergren]

This is doable through an advanced filtering technique using the API syntax:

http://ftrack.rtd.ftrack.com/en/stable/using/filtering.html#filtering-using-api-like-queries

Adding the following as a Task query filter should show you any lighting task on shots where the tracking task is approved.

type.name is lighting and parent.children any (type.name is tracking and status.state.name is DONE)

 

[zdimaria]

Awesome, this is great.  Thank you!