Data Director Implementation Guide

10.5

Back Next

Basic - SQL-based Search

Basic Search uses the searchQuery API.

A search can be based on data in the:

Primary object record

Any of its (PO) child records

Any records related through a match path component

You can perform a case insensitive Basic search, when you run a data query. Basic search finds results using string and string pattern comparisons.

In Microsoft SQL Server environments, Basic Search is not case sensitive.

In Microsoft SQL Server environments, you cannot use square brackets ([]) and a like operator in a search request. To use square brackets in a search query, enclose the first square bracket ([) in an extra pair of square brackets ([[]). For example, to look for a record that starts with a first name like

%[ABC123]%

, use the following search query:

first_name like '%[[]ABC123]%'

Rename Saved Search

Table of Contents

Data Director Implementation Guide

Data Director Implementation Guide

Basic - SQL-based Search

Basic - SQL-based Search