Preface
Introduction
Getting Started
Data Director with Business Entities
Data Director with Subject Areas
Hierarchies and Relationships
- Investigating Hierarchies and Relationships
Workflows and Reviews
- Participating in Review Processes
- Review Processes Reference

Data Director User Guide

10.3

Back Next

Advanced Search Queries

Use the

Advanced Query Builder

to construct complex queries using free form query text. Advanced Search provides capabilities for specify search conditions that go beyond the capabilities of standard (basic and extended) queries. Advanced search criteria are used in the query's SQL WHERE clause.

Advanced Search uses SQL syntax and supports:

Logical operators - AND/OR/NOT

EXIST, NOT EXISTS, and COUNT conditions

Comparisons operators range comparison (=, >, <, >=, <=, BETWEEN)

Be sure to validate your query syntax. You cannot save a query with invalid syntax.

Search Queries from the Data Tab

Logical Operators

Conditional Operators

Comparison Operators

Date Syntax in Advanced Search Queries

Creating Advanced Search Queries

Example of an Advanced Search Query