Data Director User Guide

Back Next

Conditional Operators

Use conditional operators to restrict your search results based on a supported condition.

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

Operator	Description	Example
EXISTS	Returns true if at least one row meets the specified condition in the subquery. NOT EXISTS is also a valid construct.	EXISTS(C_MT_PERSON_DETAILS, MATCH_PATH_COMPONENT.C_MT_PERSON_DETAILS\|BIRTH_CITY = 'NEW YORK')
COUNT	Returns the number of rows that meet the specified condition.	COUNT(C_MT_ADDRESS, MATCH_PATH_COMPONENT.C_MT_PARTY_ADDRESS_REL\|ADDRESS_TYPE = 'Shipping')