Filter for Tasks that have Versions with a specific status

Flow Production Tracking
1

Hi, I need to find a list of tasks that have versions with our status “Client Approved” - Is there an easy way to do this?

A query field? a calc field? Would love to know if this is possible!

Thanks!

2

Hi @Cameron,

Query fields can solve the issue. Create a new field (a snapshot that might help you), in the task entity field. The new field display’s the latest version status of the task.

Please note that the filter option is not supported for query fields.

image
image784×556 37.8 KB
.

Hope this is what you are looking for!

Thanks!

1 Like
3

Instead of a query field you could just filter your tasks by Link → Shot (or Asset, etc) → Linked Version → Status

image
image789×258 14.2 KB

Or depending what you’re trying to do, you could start on the Versions page, filter by “Client Approved”, and then simply display the Task column or any of the linked task fields.

1 Like
4

Easiest way to do this that I’ve found, is to make a query field on Shots (I made one called Seen by Client) that shows the number of versions per shot that have the Version Status of either client approved or client note. Then since SG doesn’t allow for calculated fields with Query fields or the ability to sort query fields, you need to download the CSV to your favorite spreadsheet program. From there you can add filters to your headers, and sort the Seen by Client field from A-Z - this will give you all the 0s at the top, and you can set up a row counter to give you an exact number for how many shots have NOT been seen.

1 Like