To create a new query or modify existing query, click the Create New Query or Modify Selected Query. The Query Dialog box opens.
The query must have at least one dictionary. To add a dictionary, select a dictionary from the Available Dictionaries pulldown list and click the (+) button. To remove a dictionary, click the (-) button.
Once the dictionary has been added to the query, the conditions can be added using the Add button. The query can have no conditions, otherwise the query will match all Transaction Detail Records (TDRs) for a given dictionary. Each dictionary has its own conditions, making it possible to search for TDRs from different dictionaries with different conditions.
The query is validated before it is saved or executed. The following things are verified:
Whenever any error occurs, the user is notified either in the Message Panel at the top of the Dialog box or next to the GUI element which caused the error (a condition or expression box).
By default, when a dictionary is added into the query, all displayable fields from that dictionary are selected as Displayed Fields. If desired, change the Display Fields in the Displayed Fields tab. There are 3 modes to choose from:
The Displayed Fields are selected separately per dictionary. If there is more than one dictionary, then fields in the query result are merged together based on the field name. All fields with the same name are displayed in the same column.
Click Save to save a query for later use. The query appears in the Query List panel.
Click Save As to open a prompt asking for a new name. Confirms the name. A new query is created and saved for later use. The query appears in the Query List panel.
Now the query is ready for execution. Execute the query by clicking the Apply button.