Version 2021

Element Browsing Pre Statement

The Element Browsing Pre Statement VLDB property is used to insert custom SQL statements at the beginning of all element browsing requests. For example, an element browsing request occurs when a user expands an attribute to view its attribute elements.

Including SQL statements prior to element browsing requests can allow you to define the priority of element browsing requests to be higher or lower than the priority for report requests. You can also include any other SQL statements required to better support element browsing requests. You can include multiple statements to be executed, separated by a semicolon (;). The SQL Engine then executes the statements separately.

If you do modify the Element Browsing PreStatement VLDB property, the statements defined in the Report Pre Statement VLDB property are not used for element browsing requests. Priority of report requests and other pre-report SQL statements can also be defined using the Report Pre Statement VLDB properties, which are described in Element Browsing Pre Statement.

Levels at Which You Can Set This

Database instance only