QUERY_OPTIONS
= optional in PARAM
Parameter (col A in PARAM) | Mandatory/Optional | Value in col C | Value in col D | Occurrence in PARAM sheet | Comment | |
|---|---|---|---|---|---|---|
FORM | REPORT | |||||
QUERY_OPTIONS | HASH JOIN, HASH GROUP or any other valid query option | N/A | 1 | Important: Only applicable in v1 templates (new data engine). With this parameter, the designer can add an OPTION in the SQL queries. | ||
With this parameter, the designer can decide if an OPTION should be added to the queries.
Access Query Options in the Template Design right panel by selecting Parameters > Data Retrieve > Query Options:
For more information about this parameter, see Query Options.