Click
New to define a new query in the
New Query dialog box.
Note: You can also access the
Queries dialog box from the context menu by right-clicking on a column title in any component.
- Query
- Displays the query definition parameters.
- Name
- Enter a unique name for the new query.
- Public Check Box
- Check to give the query public status. Public queries can be used by anyone with the appropriate access rights, while private
queries are available only to your user ID. Once a query has been saved with a specific status, its status cannot be changed.
However, you can copy a query and change the state of the new query.
- Query List
- Displays the query definition. By default, the
AND condition appears as a starting logical condition.
- Logical node
- Use to choose the logical operator for each condition.
- AND
- Click to add an
AND condition to the query.
- OR
- Click to add an
OR condition to the query.
- NOT
- Click to add a
NOT condition to the query.
- AND->OR->NOT
- Click to toggle the default
AND condition to an
OR or
NOT condition.
- Remove
- Click to delete the currently selected condition. You must confirm the deletion.
- Condition Node
- Use to define the conditions for the logical operator.
- Field
- Lists all the fields available for this component.
- Operator
- Lists all of the operators that can be specified for the selected field.
- Value
- Use to specify a value for this field and condition.
- Show advanced fields check box
- Select to display all possible fields including the advanced fields.
- Show deleted users check box (optional)
- For components with user fields only (such as the Change Requests component), select to show deleted users in the query results.
- Alphabetical check box (optional)
- For enumerated fields only (fields that have specified values), select to alphabetize the query results rather than list them
in the order in which they appear in the enumeration list.
- Add
- Click to add the condition to the query definition.
- Modify
- Click to modify the selected query condition.
- Delete
- Click to delete the selected query condition.
- View as Text button
- Displays the current query definition in a field.
- Save button
- Saves the query.
- Cancel button
- Cancels the query definition.