Hi,
We've added a Query Field called "Latest Camera" to our Shot Table.
Now on an Asset Page, I am trying to add the Column via Link -> Shot -> Latest Camera, but unfortunately it is grayed out. I'm assuming displaying Linked Query Fields is disallowed?
I found this thread:
https://support.shotgunsoftware.com/entries/45187-calculated-fields
So now it makes sense why a Query Field can't be accessed via Links.
Cross-posting Stephen's response from https://support.shotgunsoftware.com/entries/45187-calculated-fields
Regarding the ability to access and reveal Query fields from a linked entity (Example: while in a Task page, reveal a Query field called "Latest Version Thumbnail" that exists in the linked Shots page), we do plan on supporting this! We have a ticket for this now (SG #13160), and I will keep the forum updated on its progress.
In the meantime, a good workaround is to create another Query field on the current entity page (Example: Create a Query field on the Task page for the latest Version thumbnail where the linked Shot's Tasks field includes the current Task). This works well for links like this where there's a one-to-many relationship, and doesn't work for links with many-to-many relationships as it could return more than one linked result, and it wouldn't know which value to return. More details on entities are here:
https://support.shotgunsoftware.com/entries/81662
cheers,
kp
Follow us on Twitter @shotgunsoftware and @shotgunsupport