DISABLE_TEMPL_DELETE
Feature available from Bizview version - Bizview 7.0
= optional in PARAM
Parameter (col A in PARAM) | Mandatory/Optional | Value in col C (example) | Occurrence in PARAM sheet | Comment | |
|---|---|---|---|---|---|
FORM | REPORT | ||||
| n/a | TRUE/FALSE | 1 | This parameter is used to override the default Bizview deletion method and decide exactly which dimensions should be included in the deletion (when values are updated in database). | |
The parameter DISABLE_TEMPL_DELETE is an optional parameter in forms that can be used to override the default Bizview deletion method. When the user updates values from a form, Bizview first evaluates the template sheet and the parameter sheet and adds all necessary parameter values to the where criteria in the SQL query. Thereafter, Bizview deletes all related values before the update of values is performed.
The evaluation that Bizview performs can take a long time in some forms since all parameters in the actual form template need to be evaluated. If the delete method executes slowly, the designer can consider using the parameter DISABLE_TEMPL_DELETE. If the parameter is set to TRUE, then Bizview will NOT read the template sheet to retrieve parameters for the delete where criteria, only objects in PARAM will be added to the delete rules. It is then up to the designer to narrow the delete to avoid deletion of to many values. Perhaps the objects that exist in PARAM are good enough, but if more criteria needs to be added, then the DELETE_WHERE parameter can be used.
Access this feature in the Template Design right panel by selecting Parameters > Frequently Used > DELETE WHERE > Custom Delete conditions for updating values.
Note: When you mark this parameter, the designer must check that Bizview does not delete too much data! To narrow the delete, the designer should add their own DELETE_WHERE parameters.
Important: NOT supported/implemented in v1 templates (new data engine).
Example
UNIT and PROJECT are object defined in PARAM, VALT, and ACT in the template. If the parameter DISABLE_TEMPL_DELETE is TRUE, the VALT and ACT will not be added to the delete rule. The designer would probably then want to add the ACT object in the delete, but not VALT. To include ACT in the delete, the designer must create three DELETE_WHERE (PROJECT, UNIT, and ACT) and enter correct values for those objects.