Boolean functions

Boolean functions are used to perform boolean logic on different elements in Profile Query Language (PQL). More information about other PQL functions can be found in the Profile Query Language overview.

And

The and function is used to create a logical conjunction.

Format

{QUERY} and {QUERY}

Example

The following PQL query will return all people with home country as Canada and birth year of 1985.

homeAddress.countryISO = "CA" and person.birthYear = 1985

Or

The or function is used to create a logical disjunction.

Format

{QUERY} or {QUERY}

Example

The following PQL query will return all people with home country as Canada or birth year of 1985.

homeAddress.countryISO = "CA" or person.birthYear = 1985

Not

The not (or !) function is used to create a logical negation.

Format

not ({QUERY})
!({QUERY})

Example

The following PQL query will return all people who do not have their home country as Canada.

not (homeAddress.countryISO = "CA")

If

The if function is used to resolve an expression depending on whether a specified condition is true.

Format

if ({TEST_EXPRESSION}, {TRUE_EXPRESSION}, {FALSE_EXPRESSION})
Argument
Description
{TEST_EXPRESSION}
The boolean expression which is being tested.
{TRUE_EXPRESSION}
The expression whose value will be used if {TEST_EXPRESSION} is true.
{FALSE_EXPRESSION}
The expression whose value will be used if {TEST_EXPRESSION} is false.

Example

The following PQL query will set the value as 1 if the home country is Canada and 2 if the home country is not Canada.

if (homeAddress.countryISO = "CA", 1, 2)

Next steps

Now that you have learned about boolean functions, you can use them within your PQL queries. For more information about other PQL functions, please read the Profile Query Language overview.

recommendation-more-help
770bc05d-534a-48a7-9f07-017ec1e14871