Element Browsing Post Statement

The Element Browsing Post Statement VLDB property is used to insert custom SQL statements after the completion 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 after the completion of 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. Each statement must be separated by a semicolon (;). The SQL Engine then executes the statements separately.

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

Levels at Which You Can Set This

Database instance only