Comparison functions

Comparison functions are used to compare between different expressions and values, returning true or false accordingly. More information about other PQL functions can be found in the Profile Query Language overview.

Equals

The = (equals) function checks whether one value or expression is equal to another value or expression.

Format

{EXPRESSION} = {VALUE}

Example

The following PQL query checks if the home address country is in Canada.

homeAddress.countryISO = "CA"

Not equal

The != (not equal) function checks whether one value or expression is not equal to another value or expression.

Format

{EXPRESSION} != {VALUE}

Example

The following PQL query checks if the home address country is not in Canada.

homeAddress.countryISO != "CA"

Greater than

The > (greater than) function is used to check if the first value is greater than the second value.

Format

{EXPRESSION} > {EXPRESSION}

Example

The following PQL query defines people whose birthdays do not fall in January or February.

person.birthMonth > 2

Greater than or equal to

The >= (greater than or equal to) function is used to check if the first value is greater than or equal to the second value.

Format

{EXPRESSION} >= {EXPRESSION}

Example

The following PQL query defines people whose birthdays do not fall in January or February.

person.birthMonth >= 3

Less than

The < (less than) comparison function is used to check if the first value is less than the second value.

Format

{EXPRESSION} < {EXPRESSION}

Example

The following PQL query defines people whose birthday is in January.

person.birthMonth < 2

Less than or equal to

The <= (less than or equal to) comparison function is used to check if the first value is less than or equal to the second value.

Format

{EXPRESSION} <= {EXPRESSION}

Example

The following PQL query defines people whose birthday is in January or February.

person.birthMonth <= 2

Next steps

Now that you have learned about comparison 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