Lesson Total Time in Database

jschneider
Wed, 10/04/2017 - 18:05
Forums
Developing Opigno
Hello, I'm trying to generate a Course Report using Forena Reports. The report should contain the Total Time a user invested into the course (The Sum of the total times of all Lessons in the course, as seen on the right in the course view). I have to get this Data directly from the Database. But I can't find the values in the Database. Can somebody tell me, where I can find them? Sincerely, Justus Schneider
Profile picture for user James Aparicio
James Aparicio
Fri, 10/13/2017 - 16:04

Hi jschneider,

Hi jschneider,

Its the (sum of ((time_end- time_start) where time_start > 0 and nid in the lesson ids of the course and uid = the user you want)) in the table quiz_node_results

 

Best regards

jschneider
Sat, 10/14/2017 - 14:26

Hey,

Hey, Thank you for your help! It worked for me! The only problem that remains, is that it always gets me exactly one hour to much. Do you have an idea, how this happened? Greetings, jschneider