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

EXCLUDE_COLUMNS

Exclude Columns - Detailed Specification

Feature available from Bizview version - Bizview  7.2

Optional parameter in PARAM = optional in PARAM

Parameter (col A in PARAM)

Mandatory/Optional

Value in col C (example)

Occurrence in PARAM sheet

Comment

FORM

REPORT

EXCLUDE_COLUMNS

Optional parameter in PARAM

Optional parameter in PARAM

column IDs

1

Possibility to exclude obsolete columns in the #plandata procedure to improve performance when opening a form/report. By default, the #plandata procedure include all possible columns.

When using #plandata (for example BV columns or BIZVIEW/#plandata) by executing dat.p_data_cells_populate and the table dat.data_cells contains a large amount of rows, the procedure may take long time to execute if the selection results in many rows. To improve performance and eliminate this behaviour, the designer can tell the procedure to exclude columns that are obsolete in the query. When excluding columns, Bizview will group the result and hopefully the result will contain fewer rows, and therefore, enhance performance when opening the report/form.

For more information about how to exclude columns and what to be aware of, see Exclude Columns - detailed specification.

Access EXCLUDE_COLUMNS in Template Design by selecting Parameters > Frequently Used > Alter SQL query.

EXCLUDECOLUMNS

Check the columns that should be excluded from the query in the specific template.

EXCLUDECOLUMNS_dialog
Published:

EXCLUDE_COLUMNS

Exclude Columns - Detailed Specification

Feature available from Bizview version - Bizview  7.2

Optional parameter in PARAM = optional in PARAM

Parameter (col A in PARAM)

Mandatory/Optional

Value in col C (example)

Occurrence in PARAM sheet

Comment

FORM

REPORT

EXCLUDE_COLUMNS

Optional parameter in PARAM

Optional parameter in PARAM

column IDs

1

Possibility to exclude obsolete columns in the #plandata procedure to improve performance when opening a form/report. By default, the #plandata procedure include all possible columns.

When using #plandata (for example BV columns or BIZVIEW/#plandata) by executing dat.p_data_cells_populate and the table dat.data_cells contains a large amount of rows, the procedure may take long time to execute if the selection results in many rows. To improve performance and eliminate this behaviour, the designer can tell the procedure to exclude columns that are obsolete in the query. When excluding columns, Bizview will group the result and hopefully the result will contain fewer rows, and therefore, enhance performance when opening the report/form.

For more information about how to exclude columns and what to be aware of, see Exclude Columns - detailed specification.

Access EXCLUDE_COLUMNS in Template Design by selecting Parameters > Frequently Used > Alter SQL query.

EXCLUDECOLUMNS

Check the columns that should be excluded from the query in the specific template.

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