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.
|
Back to top