Table of Contents

Search

  1. Preface
  2. Introduction
  3. Getting Started
  4. Data Director with Business Entities
  5. Data Director with Subject Areas
  6. Hierarchies and Relationships
  7. Workflows and Reviews

Basic Queries

Basic Queries

Basic queries use simple text comparisons to find records that contain the query values. You can use text and the wildcard character (*) to query values.
The wildcard characters are special search symbols that you can use in basic queries to specify a text pattern instead of specific characters. You can use the asterisk (*) wildcard character to increase your chances of finding the records that you want. The wildcard characters are useful when you do not know the exact text or want to search for similar text.
The following table lists example search strings and explains how they function:
Example Query String
Query Behavior
John Smith
Queries for records that contain
John
,
Smith
, or any variations of
John
or
Smith
as a field value.
"John Smith"
Queries for records that contain
John Smith
or any variations of
John Smith
as a field value.
John*
Queries for records that contain a value that starts with
John
. For example,
Johnson
or
Johnny
.
Jo*n
Queries for records that start with
Jo
and end with
n
. For example,
Johansson
or
Jordan
.
*
Returns all the records.
Basic query is not case sensitive in Microsoft SQL Server environments.

0 COMMENTS

We’d like to hear from you!