Best practice forum (Archived)

Creating a report source with multiple joins

 
? ?
Creating a report source with multiple joins
על ידי ? ? בתאריך 26/08/2013, 15:07
 

Hi, I am trying to add a new report source where I have a three table join. Could you provide a code example of what that would look like? In my case, I am joining the user, course and course completion tables, but I'm just looking for syntax help here.

Thanks!

Simon Coggins
Re: Creating a report source with multiple joins
על ידי Simon Coggins בתאריך 26/08/2013, 15:27
קבוצה Totara

Hi Joe,

There are some technical docs about creating a report source available here:

http://docs.moodle.org/dev/reportbuilder

They are not 100% complete but should contain the information you need for a simple source. You could also look at some existing report sources for ideas.

Simon