Query no limit for run Store Procedure

Re: Query no limit for run Store Procedure

by Randy Thornton -
Number of replies: 0
Picture of Documentation writers
If you mean you need to increase the limit, you can do that in Site admin > Plugins > Blocks > Configurable reports > Report row limit. The default is 5,000. You can increase (or decrease) that to what you need. This is a global setting that affects all reports, so if you do have a lot of large reports users are running, it could slow things down.

If you mean you need to remove the appending of the LIMIT parameter for the stored procedure to work when the plugin code builds the SQL query, then you would need to edit the code for the plugin where that limit is appended. Take a look in the block's directory /reports/sql/report_class.php to do that.
Average of ratings: Useful (2)