Best practice forum (Archived)

Creating a report source with multiple joins

 
Joe Gange
Creating a report source with multiple joins
by Joe Gange - Monday, 26 August 2013, 3:07 PM
Group Partners

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
by Simon Coggins - Monday, 26 August 2013, 3:27 PM
Group 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