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.