Wondering if there is a clever way to set up a field on SG that would serve as a warning for a publish dependency violation. For instance if I have a model publish that happens after a rig publish, I want to tick a box to let users know there’s a potential issue with the asset.
I’ve tried setting up two query fields on the asset level that get the date of the latest publish under the relevant pipeline step. This gets me date A and date B, but I cant use a calculated field to compare them since they are both query fields.
Any ideas appreciated!