This section describes how to create a basic query; information about adding groups and criteria, and configuring the appearance of the query output are described later.
You can modify existing queries either from within Query and Report Designer, or from the query results list using the Modify Query action. You can either overwrite your original query or save a new copy with a different name.
For information about system-wide queries, see System queries.
In addition to attributes from the business object, you can add related attributes. For example, if you are creating a Change query, you select the Change business object. In the Attributes tree, you will see the attributes for that business object as well as all related business objects, for example, Asset, User and so on.
To select multiple attributes to drag onto the Selected Attributes list, hold CTRL while selecting the attributes from the tree.
To remove attributes from the Selected Attributes list, right-click the required attribute, then click Remove.
To change the order of the columns that appear in the list panel, select the column, then drag it to the required position (end-users can change the order of the columns when they run the query by holding SHIFT, then dragging the column header).
To modify the properties of an attribute, right-click it, then click Properties. For information about modifying the properties of an attribute, for example, specifying whether it is a color field, the label of the attribute and so on, see Configuring the List panel.
When you drag an attribute from a collection onto the Selected Attributes list, if it is the first attribute you have selected from that collection, a new tab is created alongside the Preview tab. You can drag further collection attributes onto the Selected Attributes list, and they will appear on the relevant tab. Note, you cannot drag a collection attribute onto the collection tab itself. If you want to remove a collection attribute, right-click it, then click Remove.
When you run the query, these collection attributes appear in separate tabs in the Preview pane.
For more information about collections, see Collections.
For more information about configuring the appearance of the Preview panel, see Configuring the Preview panel.
To preview the appearance of the query, click Test Query. To end the test, click End Test.
For information about query grouping, see Adding grouping to query results.
For more information about adding criteria to a query, see Query criteria.
For information about the General Settings page, see Configuring the general settings for the query.
You can delete a query if it is no longer needed, using the Delete Query action.
Creating criteria for your query