I have several assets on Shotgrid that appear on multiple shots. However, I need to prioritize production on assets that appear on most shots.
Is there a way to filter, group or organize my Assets page so that the assets that appear on most shots are on top of the page?
You could create a field on the assets entity that stores the count of the number of shots, and then sort by that. You might need to write it as a scriptthat trriggers, you wouldn’t want a summary field as the summary field won’t support sorting.
I think a Query Field on the Asset entity would do this:
