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 >>