3.5.1 Query Properties

The 'Query Properties' button opens the 'Query Properties' dialog box. This allows you to place limits on queries that return a large result set by constraining the maximum number of returned rows and maximum execution time.

The following options are available:
• Maximum Number of Rows: The maximum number of records that the query should be permitted to request.
• Query Timeout: The maximum length of time for which the query should be permitted to execute. (After this period elapses, attempts will be made to terminate the query.)
• Show Query in Ad Hoc: Specifies that the query will be available to reports designed using the end-user Ad Hoc tool.
• Inherit VPM from: Specifies an existing physical view whose VPM filter will be applied to the query.
| << 3.5 Advanced Toolbar Buttons | © 1996-2013 InetSoft Technology Corporation (v11.5) | 3.5.2 Query Parameters >> |