Data Director User Guide

10.3

Back Next

Creating Advanced Search Queries

To create an advance query, use the

Advanced Query Builder

In the navigation bar, click

Data

In the

Data

tab, a new tab opens with the

Search Form

displayed.

From the

Actions

menu, select

New

Advanced

The

Advanced Query Builder - New Query

dialog box opens.

Select the subject area that you want to search from the

Subject Area

list.

Select the attributes that you want to include in the search from the

Available Attributes

field.

To include a count for the attribute in your results, click

Insert COUNT

To check for the existence of data, click

Insert EXISTS

When you select an attribute, the attribute appears in the

Query Filter Criteria

field.

Add logical operators, conditional operators, and comparison operators to the query as required.

Optionally, select a sort option from the

Sort Results By

list and select an ascending or descending sort order.

Optionally, enable

Case Insensitive

search.

To verify the query syntax, click

Validate Query

If the query contains syntax errors, the

Query Validation Error

dialog box opens with a description of the syntax errors. Click

, correct all syntax errors, and then revalidate the query.

If the query does not contain syntax errors, a message confirms that the query is valid. Click

Click

. IDD revalidates the query to ensure no query syntax errors exist.

If IDD does not detect syntax errors, a search tab opens in the

Data

tab.

If IDD detects syntax errors, the

Query Validation Error

dialog box opens. Resolve the query issues and then click

again.

Click

Run Search

The query results appear in the

tab.

Advanced Search Queries

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Data Director User Guide

Data Director User Guide

Creating Advanced Search Queries

Creating Advanced Search Queries