Hi everyone!
This is my first post here, so it would be nice if you all could help me improving my future posts by pointing out my mistakes
Now let’s get to the topic:
I love the query field! They are amazing to get all the data I need. But often times the raw data is not as useful as some color coded rows.
For example:
The open notes field, which is default in shotgun, is really handy for a general overview of the review phase. But It would be way easier to differentiate the shots with comments from the other by changing the color of the fields. For example highlight it yellow if the value is above 1. Maybe if it is really high, like 15 or 20, it would be nice to highlight it in red or so. This is possible with every other field type in Shotgun, but not with query fields.
Another example is a custom entity that we use in our vfx production.
We track some shots by “setups”. They group different tasks like greenscreen sequences, mattepaintings or 3D elements per shot. It is a little bit like the asset structure but less complex.
We get the progress of these setups by query field. In them we summarize the shots with the final status or look for ommited shots. Setups are really handy for a general overview of projects. They also provide us an overview of the used bid per setup. This value is really critical as you might know. If the remaining bid gets to zero we need to show it to our production team and producers. But because the fields are query fields, we can’t use custom formatting rules to highlight low bids.
I understand, that query field are a little bit complex to calculate, but can’t you implement a callback after calculation to allow custom formatting rules?
It shouldn’t be so complex, or yes?
I’ve read this post here: https://support.shotgunsoftware.com/hc/en-us/community/posts/209480108-Ability-to-sort-group-and-or-filter-on-Query-fields
It is from 2013 and the latest comment is from 2018. It looks like a really important feature to some productions and I think it might be forgotten over the time.
There is also no comment from the Shotgun side, so I would like to use #wfh to reintroduce this topic. It is still important, I think.
Best regards,
Lukas