Filtering based on multiple children statuses

[Conor Bowes]

Hey,

I am having trouble formulating an advanced query via the interface and API. I am sure this is something that a lot of others must have already solved so I am hopeful I can get some help here.

I have a basic structure of a custom object named "Episode" with multiple tasks. Assuming an episode has 2 tasks, I want to retrieve all shots that have task 1 status = Complete, task 2 status = Not Ready.

Currently I have two queries - one that retrieves task 1, one that retrieves task 2 and I intersect these two lists to get only the episodes that exist on both. It would be get this down to one query via the API, but I would also want to be able to use a similar query via the interface

[Mattias Lagergren]

Hi, a query like this should allow you to filter out what you need:

Episode where children[Task] any (name is "foo" and status.name is "bar") and children[Task] any (name is "baz" and status.name is "foobar")