iConsole Search Definition Reference Guide › Advanced Features › Supporting Searches of Unlimited Size › Stored Procedure

Stored Procedure

The stored procedure must respond to the control parameter values as follows:

0

Perform a normal search, honoring a row limit if this is defined. The iConsole will limit the number of records based on the registry setting MaximumResultSetSize,

1

Return the total count of all results for the search. This should return a single, integer column containing the total result count. The name of the column can be anything you choose.

2

Perform an unlimited search, overriding any row limit specified. The iConsole will not apply a limit on the number of records but will retrieve all of the results. This may take some time and could overload iConsole resources.