Miscellaneous functions

The following function is a miscellaneous function for Profile Query Language (PQL). More information about other PQL functions can be found in the Profile Query Language overview.


The let function allows an expression to be stored as a variable to be used later in a query.




The following PQL query gets all sums of product totals with the transaction in USD where the sum is greater than $100 and less than $1000.

let S = (sum X.commerce.order.priceTotal over X from xEvent where X.commerce.order.currencyCode = "USD") in (S > 100 and S < 1000)

Next steps

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

On this page