Changes between Version 6 and Version 7 of AdvancedReports

Timestamp:

08/08/26 13:42:34 (4 hours ago)

Author:

231175

Comment:

--

AdvancedReports

@@ -146 +146 @@
         FROM course c
                  JOIN course_translate ct ON c.course_id = ct.course_id
-                 JOIN language l ON l.id = ct.language_id AND l.value = 'en'
+                 JOIN language l ON l.id = ct.language_id
                  JOIN course_version cv ON c.course_id = cv.course_id
                  LEFT JOIN enrollment e ON cv.course_version_id = e.course_version_id   -- include versions with zero enrollments
@@ -234 +234 @@
     (
       course ⋈ course_id = course_id course_translate 
-      ⋈ language_id = id ∧ value = 'en' language 
+      ⋈ language_id = id language 
       ⋈ course_id = course_id course_version 
       ⋈ course_version_id = course_version_id enrollment 
@@ -274 +274 @@
     (
       course ⋈ course_id = course_id course_translate
-      ⋈ language_id = id ∧ value = 'en' language
+      ⋈ language_id = id language
       ⋈ course_id = course_id course_version
       ⟕ course_version_id = course_version_id enrollment