Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-6628

Configurable report not filtering on multiple filters

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.9.8, 3.6
    • Fix Version/s: None
    • Labels:
    • Plugin Version:
      2.3.9
    • Affected Branches:
      MOODLE_29_STABLE, MOODLE_36_STABLE

      Description

      I have created a configurable report with the following:

      SELECT u.username AS 'username', 
      c.shortname AS 'Course', 
      cc.name AS 'Category', 
      cid.data AS 'Client ID',
      aid.data AS 'Associate ID',
      IF(gi.itemtype = 'course', CONCAT(c.fullname,' Course Total'), gi.itemname) AS 'Item Name', 
      ROUND(gg.finalgrade,2) AS Grade, 
      FROM_UNIXTIME(gi.timemodified) AS TIME 
       
      FROM prefix_course AS c 
      JOIN prefix_context AS ctx ON c.id = ctx.instanceid 
      JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id 
      JOIN prefix_user AS u ON u.id = ra.userid 
      JOIN prefix_grade_grades AS gg ON gg.userid = u.id 
      JOIN prefix_grade_items AS gi ON gi.id = gg.itemid 
      JOIN prefix_course_categories AS cc ON cc.id = c.category 
      JOIN prefix_user_info_data cid ON u.id = cid.userid AND cid.fieldid = 1
      JOIN prefix_user_info_data aid ON u.id = aid.userid AND aid.fieldid = 2
      WHERE gi.courseid = c.id 
      %%FILTER_USERS:u.username%%
      %%FILTER_USERS:cid.data%%
      %%FILTER_USERS:aid.data%%
      ORDER BY username
      

      When I view the report and attempt to filter, it only appears to be filtering by username and not by any of the custom fields regardless of which filter I choose to filter by.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated: