Administration › Service Desk › Application Data › Stored Queries › Search for a Stored Query › Stored Query Search Fields

Stored Query Search Fields

You can use the following fields to filter your search to list only the stored query definitions of interest.

Note: All search fields that allow text entry support use of the % wildcard character.

The following fields require explanation:

Type

Specifies the type of CA SDM object for which the stored query produces data (Contact, Request, Change Order, and so on).

Active

Specifies whether the stored query is active or inactive.

Label

Defines the text string to be displayed on the Stored Query List page. The This field is required. Editable.

Code

Defines a unique identifier for the stored query.

Scoreboard Usage

Specifies whether the query is available for customizing the Scoreboard.

KPI Usage

Specifies whether the query is available for configuring a KPI.

Where Clause

The SQL WHERE clause for the query. A WHERE clause includes a comparison predicate, which restricts the number of rows returned by the query.

Note: You can click the More icon to display the Additional Search Arguments field. This field is intended only for expert users who understand SQL and Majic and can use it to specify search arguments that are not available in the standard search filter fields. You can enter a SQL WHERE clause in this field to specify an additional search argument.