Administration › Service Desk › Application Data › Stored Queries › Create a Stored Query › Stored Query Fields

Stored Query Fields

You can use the fields on the Stored Query pages to define and edit query definitions.

Note: If you are using multi-tenancy, a tenant column appears on the list page.

The following fields require explanation:

Code

Defines a unique identifier for the stored query. This field is required. Not editable.

Scoreboard Usage

Specifies whether the query is available for customizing the Scoreboard. Editable.

KPI Usage

Specifies whether the query is available for configuring a KPI. Editable.

Record Status

Specifies whether the stored query is active or inactive. This field is required. Editable.

Type

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

Label

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

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. This field is required. Editable.