Query Field Codes Overview

Add query field to WHERE clauses in database queries to constrain the list items in the list metric generated by the query. The list metrics created can be either single select or multi-select and either individual or cascading, where the values displayed in the child metric in a cascading list depend on what was selected in the parent metric. The list metrics can also be designated as filter metrics and used to filter projects, for example on the Resource Editor, Search, and other pages.

Using query codes when creating a query, you can retrieve the following information types:

  • Project metadata - Returns current information about a project. For example, project name and description, gate dates, gate decisions, and so on.
  • Metrics - Returns current values for metrics used throughout your system.
  • Extended Fields for Resource Pools - Returns a comma delimited list of the selected security list item IDs for a resource pool.

Field Code Format

Query fields have the following basic pattern: {*source:name*}, where source identifies the general type of data displayed, and name identifies the specific data. Query codes for metadata and extended fields use source QMD. Query Codes for metrics use source QME. Codes are not case sensitive.

See Query Field Codes Reference for a complete list of query codes available.