Hi !
I am using Moodle 3.4 and Configurable Reports 3.1.1
I need to run a Store Procedure. But Configurable reports adds at the end "limit 5000", so it doesnt work with that limit....
Do you know how i can avoid that limit?
In reply to Luis Guillermo Loaiza Cordero
Re: Query no limit for run Store Procedure
by Shirley Gregorczyk -
Be very careful with this - Site administration>Plugins>reports Ad-hoc database queries.
In reply to Luis Guillermo Loaiza Cordero
Re: Query no limit for run Store Procedure
by Randy Thornton -
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.
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.