One report from two activity modules.

One report from two activity modules.

by Stephan Tedesco -
Number of replies: 2

I want to buil a report, which is based on the activity modules Face-to-Face and a Mynewplugin, which I am developing. 

As both plugins provide us with similar data about the user attendance, the report has to be based on the face-to-face-sessions report.  (user name, trainer/teacher name, session start date, session finish date, session address etc) 

In facetoface/rb_sources/rb_source_facetoface_sessions.php we have the definition of the data we need from Face-to-face. 

But how to build the report in mynewplugin//rb_sources/rb_source_mynewplugin.php, so when I am making a report about the user, it will pull the  data, which we need. 

Or should I make completely new rb_source_files for both plugins?


Couldn't find any similar question here and will appreciate any help. 


S. 

Average of ratings: -
In reply to Stephan Tedesco

Re: One report from two activity modules.

by Emma Richardson -
Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Plugin developers

Are you looking for assistance in the building the sql report in configurable reports or writing php to create a report within a plugin?

In configurable reports, you just need to find a way to join the tables and then you can pull data from both tables from your database.

If you need help with php, I will leave that to one of our wonderful coders!

In reply to Emma Richardson

Re: One report from two activity modules.

by Stephan Tedesco -

Thank you Emma for the guidance. I already builded a report within mynewplugin and I am looking to combine it with the report of facetoface-sessions. 

As described by you, I will look to join the tables in configurable reports and should be capable to manage this by myself, at least that one I can do by myself, if not I will write you back in 2 days. 

But I will have help regarding this question https://moodle.org/mod/forum/discuss.php?d=319931 Can you suggest me a way to find a solution?


Regards, 


S.