MashZone NextGen 10.2 | 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 © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release