Does anyone know if the 5000 record limitation in the ad-hoc reporting module also applies to the downloaded data?
Analytics and reporting
Ad-hoc reporting limitation
thanks for that - do you know if there are any adverse implications for increasing the record limit to say 10,000?
I did try and check this and found that in most cases I was only getting 5000 records in the downloaded file, but I had a couple of queries involving unions which were returning 10000+ records so I was a little confused (I guess it's possible that the unions are seen as seperate queries?)
I know I'm a bit late to the party, but I had a site with 50k users and upped this limit, no problem...
... until I ran a large report - it wasn't the server that died, it was the browser. Running a full user report ran ok (~2.5 seconds) and it then proceeded to display the whole thing in an html table. Neither Firefox nor IE liked that and after about 45+ minutes of trying to render the 50k row table the browser would crash.
The (quick and simple) fix was to // the code that displays the report after running it - the CSV files were fine. A better solution would have been to apply the limit to the display code but I didn't need to go there
Just something to bear in mind, hope this helps if you're having any issues as your report grows.
I was wondering if you could help me with this Query.
select b.firstname, b.lastname, b.email, d.fullname as CourseName, d.shortname as ModuleIdentifier, a.submission_grade, DATE_ADD('1970-01-01', INTERVAL a.submission_modified SECOND) AS SubmissionDateTime from mdl_turnitintooltwo_submissions as a
join mdl_user as b on a.userid = b.id
join mdl_turnitintooltwo c on c.id = a.id
join mdl_course d on c.course = d.id
This is only picking up 1000 reports. I had earlier changed the report limit but on this report its picking up only 1000 odd reports probably something wrong in the Query.
Any help would be appreciated