API Query Shots for Pipeline Step Status

[PhilFranjo]

Hello!

I’m trying to query shots based on pipeline step status:

but this query is returning an error.

I’ve tried step_175$sg_status_list as listed in the SG UI, and I’ve also tried filtering it as a task query (entity.Shot.step_175.Task.sg_status_list) which is ultimately the goal.

This filter is found in the API tips and tricks thread:

Shotgun API Tips and Tricks Megapost

Filtering records for Entities with a combination of Pipeline Step Statuses Sometimes you might want to find a series of Entities that are, say, final in lighting but CBB in comp, or ‘in review’ in rigging and not ‘CBB’ for something else. This is very easy to do in the UI, but in the API it can be a little brain-bendy. To start, let’s use a quick one-liner to find out which steps in our Shot pipeline are visible in a specific Project: p = {'type':'Project','id':42} [(k, v['name']['value'], v…

but for some reason isn’t working in my context

Thank you,

-Phil F

[mmoshev]

The filters are a list of lists, so it has to be

sg.find("Shot", filters=[["step_175.Task.sg_status_list", "is", "omt"]])

or

sg.find("Shot", filters=[["step_175.Task.sg_status_list", "in", ["omt"]]])

[tony]

Thanks, Mois! I came here to reply, but you helped while I was still asleep!