OQL Parameters

Introduction

Currently, parameters are only supported within OQL queries defined in datasets. To use a defined parameter in a query, use the $ sign.

Examples of correct parameter names are $weight_range, $age.

If a parameter value is not set in an OQL query, that part of the statement is ignored. For example, in the following query:

SELECT Name FROM Module.Person WHERE  Age > $param  AND  Active = true

If the value of $param is not provided, the query will be equivalent to:

SELECT Name FROM Module.Person WHERE  Active = true

The example above is different from the case where the value of $param is provided, but is NULL. In that case, the query will be equivalent to:

SELECT Name FROM Module.Person WHERE  Age > NULL  AND  Active = true