Does anyone have a transition condition that depends on the Where Used of the file being transitioned? Most obvious case would be a state in the workflow called Obsolete. It's a fundamental data management concept that you cannot obsolete a part if it has where used that is not obsolete. How are people doing this? We cannot find a good way.
This would only need to search the first layer of where used, shouldn't need recursive search of the where used.
Here's my example of marked up conditions tab. The use case is a bit different, archiving files from old cad system as the Solidworks model becomes the controlling document. This archived state would be handy for not showing the files to users and other things.