Search

Data Director User Guide

Data Director User Guide

10.3

Back Next

Logical Operators

Logical Operators

Use logical operators when a search query contains multiple conditions.

The following table describes the operators that you can use and provides an example for each operator:

Operator	Description	Example
AND	Evaluates two conditional expressions and: Returns TRUE if both conditions are TRUE. Returns FALSE if either condition is FALSE Otherwise returns UNKNOWN.	MATCH_PATH_COMPONENT.C_MT_ADDRESS\|CITY_NAME = 'New York' AND COLUMN.C_PARTY\|ORGANIZATION_NAME = 'Informatica LLC'
OR	Evaluates two conditional expressions and: Returns TRUE if either condition is TRUE. Returns FALSE if both conditions are FALSE. Otherwise, returns UNKNOWN.	MATCH_PATH_COMPONENT.C_MT_ADDRESS\|CITY_NAME = 'London' OR MATCH_PATH_COMPONENT.C_MT_ADDRESS\|CITY_NAME = 'Paris'
NOT	Negates the conditional expression that follows. Returns TRUE if the following condition is FALSE. Returns FALSE if the following condition is TRUE. If it is UNKNOWN, it remains UNKNOWN.	MATCH_PATH_COMPONENT.C_MT_ADDRESS\|COUNTRY_CODE = 'USA' and NOT MATCH_PATH_COMPONENT.C_MT_ADDRESS\|CITY_NAME = 'Los Angeles'

Advanced Search Queries

Watch

Comments

0 COMMENTS

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