Jump to content

Filtering based on multiple children statuses


Conor Bowes

Recommended Posts

Posted

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...