Declare query_parameters
This page explains how to declare query parameters in APL.
The declare query_parameters statement declares typed parameters with default values at the top of an APL query. External callers and dashboards can supply values for these parameters at query time; when omitted, APL uses the declared default.
For dashboard filter usage, see Filters.
Syntax
APL
Parameters
Name: The parameter identifier used in the query.Type(optional): Scalar data type such asstring,int,long,real,bool,datetime,timespan, ordynamic.Default(optional): Constant default value used when no runtime value is supplied.
Example
Query
APL
Related statements
- Let statement: Binds variables, tabular expressions, and functions within a query.
- Set statement: Sets query options for the duration of a query.