Skip to content
Advertisement

Student Taking More than One Class In Moodle

I have tried to do some research but all the answers dont quite address my simple problem. In my Moodle Course database I do a SQL Query to see what student completed a class within a 24 hour period. This works well, except if a student completes TWO courses in a 24 hour period it only lists the first course course they took.
Is there a way I can have the report show ALL the courses a student took in a given period of time?

Advertisement

Answer

Try to remove your GROUP BY u.username. I don’t understand well how it behaves with moodle, but there is no room for it in a SQL query like yours.

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement