Creating a new query, modifying an existing query

Search through all existing queries, or by domain, to copy and modify an existing query, or create a query from scratch.

About this task

Each domain contains a set of data related to a specific purpose or function (data access, exceptions, policy violations, and so forth). The names are self-explanatory, so you can easily select the relevant domain. For a description of all domains, see Entities and Attributes in the domains.

Procedure

Open the Query Builder by navigating to Investigate > Exceptions > Query-Report Builder, or Reports > Report Configuration Tools > Query-Report Builder.
The list under Queries-Reports contains all queries in all the domains. Use the search to find a query.
Create a query using these guidelines:
- Select an pre-defined query. A dialog box opens and you can choose to:
  - Open the original query (click Open original) to modify some attributes (for example: Managing query security roles, Adding a query to a datamart, Modifying the query drilldown control, Modifying the API assignment, Creating dashboards and adding reports). You cannot modify its query attributes or conditions.
  - Make a copy by clicking Make copy and giving it a new name. Continue with Defining the query name and attributes.
- Select the domain you want to query from the Select Domain drop-down. Select one for copying or click New . The New Query page opens. Continue with Defining the query name and attributes.
- Select a user-defined query. Its properties open in the right hand pane. You can edit the query, or click to copy the query. Continue with any query configuration tasks.
- Create a new query: Click New . The New Query page opens. Continue with Defining the query name and attributes.