Create a custom SQL query using the configurable reports

Create a custom SQL query using the configurable reports

autor khalil mostafa -
Počet odpovědí: 2
've been trying to create a custom SQL query using the configurable reports plugin but looks like no luck.
Please help me out

I want this info:
  • Student name: last , First name
  • Student Email
  • ID Number
  • Course Final Grade
  • Total time connected to course
  • Start Date
  • End Date
  • Online Progress
  • City

Thank you

Průměr hodnocení: -
V odpovědi na khalil mostafa

Re: Create a custom SQL query using the configurable reports

autor Fabian Glagovsky -
Obrázek: Testers
Hi Khalil,
Your query is very complex.
Student name: last , First name, Student Email, ID Number, City --> you can get from the table user.
To get the course final grade you will need to join to it the table grade_items and grade_grades and course (at least).
The total time connected to course is not really doable in my humble point of view.
Define Online progress, start date and end date. If it is the start and end date of the course, you have in the course table. If it is the date when the student started the course, then you will need to join the logs table, and God help you with that. If you go in a roundabout way, you could consider start and end date, the completion date of two certain activities, for example. That will require you to join also several more tables. I don't think you can get all this in just one query. I wouldn't try, really.
Best,
Průměr hodnocení: Useful (1)