Conor Bowes Posted October 31, 2017 Report Share Posted October 31, 2017 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 Link to comment Share on other sites More sharing options...
Mattias Lagergren Posted November 1, 2017 Report Share Posted November 1, 2017 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") Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.