Limit of rows of report

Limit of rows of report

by Patricio Lopez -
Number of replies: 1

Hello

I am using latest C.R. version previously on Moodle 3.1 now on Moodle 3.4. But i am stuck with the same problem, turns out my sql query always gets limited to 5000 records i know there is more but it never shows more than 5000. 

Can you please give some advice about this, maybe its a server limitation (i dont think so though i have other moodle instances that show way more than 5000 records) or a problem in the query.

I am no sql expert the query was made by someone else, if  you need it i can post it. I was looking at it and nowhere it shows a limit of 5000.


I hope you can help me. Regards

Average of ratings: -
In reply to Patricio Lopez

Re: Limit of rows of report

by Séverin Terrier -
Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Testers Picture of Translators

Hi Patricio,

As an admin, you can go to the plugin settings "Admin > Plugins > Blocs > Configurable reports" and change this limit (reportlimit) smile

HTH,
Séverin

Average of ratings: Useful (1)