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