Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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

FORM

REPORT

QUERY_OPTIONS

Optional parameter in PARAM

Optional parameter in PARAM

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.

For more information about this parameter, see Query Options.

Access Query Options in the Template Design right panel by selecting Parameters >  Data Retrieve  > Query Options.

QUERY_OPTIONS

Published:

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

FORM

REPORT

QUERY_OPTIONS

Optional parameter in PARAM

Optional parameter in PARAM

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.

For more information about this parameter, see Query Options.

Access Query Options in the Template Design right panel by selecting Parameters >  Data Retrieve  > Query Options.

QUERY_OPTIONS

For an optimal Community experience, Please view on Desktop
Powered by Zendesk