QUERY_OPTIONS

Optional parameter in PARAM = optional in PARAM

Parameter (col A in PARAM)	Mandatory/Optional	Value in col C	Value in col D	Occurrence in PARAM sheet	Comment
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.

Parameter (col A in PARAM)

Mandatory/Optional

Value in col C

Value in col D

Occurrence in PARAM sheet

Comment

FORM

REPORT

QUERY_OPTIONS

Optional parameter in PARAM

HASH JOIN, HASH GROUP or any other valid query option

N/A

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.