I really love the configurable reports plug but i need a SQL query that does the following:
1. Based on who is logged in
2. Only for Non-editing teachers role
2. Filter to show only names of cohort members/of all cohorts the logged in user is a member of
3. First column is the concatenated firstname and lastname of all students of the logged in users cohort(s)
4. The rest of the columns are dynamically populated (maybe pivot table??) by the all the course names of all the courses that the logged in user is enrolled in, then the data in the the completion date when each course is completed.
So it is basically a sheet for a teacher (there are multiple teachers of courses separated by groups) to go in and see the completion date of courses of all the students they have and see what date they completed each course.
PLEASE give me some hints or best practices, i am not novice in MySQL and i cannot get a pivot table to work with this plugin