Logical quantifier functions
Logical quantifiers can be used to assert conditions with arrays in Profile Query Language (PQL). More information about other PQL functions can be found in the Profile Query Language overview.
Exists
The exists
function determines the existence of an item in an array, provided it satisfies the provided condition.
Format
exists {VARIABLE} from {EXPRESSION} where {CONDITION}
exists {VARIABLE} from {EXPRESSION} : {CONDITION}
{VARIABLE}
{EXPRESSION}
{CONDITION}
Example
The following PQL query gets all events which has a price greater than $50 or has a SKU of “PS”.
exists E from xEvent where (E.commerce.item.price > 50), I from E.productListItems where I.SKU = "PS"
For all
The forall
function determines all items in an array that satisfy all the given conditions.
Format
forall {VARIABLE} from {EXPRESSION} where {CONDITION}
forall {VARIABLE} from {EXPRESSION} : {CONDITION}
{VARIABLE}
{EXPRESSION}
{CONDITION}
Example
The following PQL query gets all events which has a price greater than $50 and has a SKU of “PS”.
forall E from xEvent where (E.commerce.item.price > 50), I from E.productListItems where I.SKU = "PS"
Next steps
Now that you have learned about logical quantifiers, you can use them within your PQL queries. For more information about other PQL functions, please read the Profile Query Language overview.