Query Fields

The Query Fields tab contains the following main options with which to define query data and structure:

• SELECT Query Fields

• ORDER BY Query Fields

• GROUP BY Query Fields

Drag-and-drop on Query Structure panels:

You can drag-and-drop items between options (for example, to group by Category Outcome, drag it from SELECT to GROUP BY. It stays in SELECT but is also used to GROUP BY).

Search shortcuts:

• Enter part of the field name to find (for example, Name) in the Search box.
• Use the up/down arrow keys to jump to each instance of “Name” in the available fields.
• When you find the field name you want, press Enter to add it to the condition statement under the selected section (SELECT, GROUP BY, or ORDER BY)
• Ctrl+F brings back the Search box in focus if it is hidden

Common Conditions Editor (CCE):

The Query Editor, like other resource editors, uses the CCE for building conditional statements (query structure). For more tips on using the CCE, see Common Conditions Editor (CCE).