New Query Options

This topic describes the options in the New Query dialog box.

Component > Filters > Queries

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.