Integrate Software AG Products Using Digital Event Services : MashZone NextGen Help : Appendix : Legacy Presto components : MashZone NextGen Analytics : RAQL Queries : Parameters in Where Clauses
Parameters in Where Clauses
RAQL does not currently support the :parm-name syntax in Where clauses to supply values for filter conditions from named parameters. You can, however, make RAQL queries dynamic by:
*Supplying parameter values in Where clauses using Dynamic Mashup Expressions. This uses an EMML syntax in the form:
{$parameter-name}
To refer to input parameters or other variables defined in the mashup.
*Building the entire query dynamically using the EMML <assign> element and variables or input parameters in the mashup. This technique is useful when you need to dynamically set different aliases, functions or entire query clauses.
See Creating Dynamic RAQL Queries for an example and more information.
This example shows a simple Where clause where the threshold for a filter is supplied by an input parameter to the mashup:
Copyright © 2017 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback