Query fields help you display quick reports of information alongside your records, such as the number of Assets linked to a Shot, the total time Bid for all Shots in a Project, or the latest Version of a Shot.
Using query fields, you can roll-up systemwide information using a single field, displaying the results by:
Here’s how to create one:
Keep in mind:
These fields are like short reports that calculate a value when the page loads, and then presents the answer for you to view. You can then interact with the information in various ways, depending on how the field is configured.
For Query fields displaying the Count or Summary of a query, you'll be able to click on the field to launch a focus window.
As an example, below is a Query field named “Total Bid,” which is displaying a sum of the Bid field on all Tasks linked to an Asset.
Notice that when you hover over the field, it displays an (i) icon along with a “Click to view details” tooltip.
Clicking the field launches a focus window that shows you exactly which records the field is summarizing. In the example below, the focus window shows you all Tasks linked to the Asset. When you look at the “Bid” field value of each of these Tasks, you'll see that they total up to 9 days—exactly what the query field displayed on the Shots page. You can even edit the records in the focus window.
For Query fields displaying a single record, you'll be able to click on the field to jump into the record's detail page (if your Admin has configured the field to do so, otherwise the record will display as "read only" text).
"Bid" is a duration field on a Task. Below is an example that shows how to set up a Query field that will find all Tasks linked to a given Asset, and then add up all the Bid values for each of those linked Tasks.
Below is an example that shows how to create a Query field called "% Complete" on a Project that will display the percentage of all Tasks for a given Project that are final (where the status of a Task is final).
Below is an example that shows how to display the latest Version of an Asset alongside each Asset record. You can modify this example to show the latest Version for a single department by making the filters specific to one department.
In order to make the results of the query unique to each record, you can filter for things such as "Current Shot," "Current Task," that is, the record type on which you're creating the Query field. You can also filter on the current logged-in user, which is useful when querying for Notes or Tasks written by or assigned to the person logged in.
For example, if you're creating a Query field on Playlists that lists Notes written by you (the current user) for each Playlist, you’d define the following two filters:
When running this query, Flow Production Tracking will look to each record on the page (i.e., each Playlist) and find Notes that have it as a link, and then Flow Production Tracking will run through that list of Notes and only return the Notes where you (the current user, or "Me") is the Author.