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

Configurable Reports Custom User Profile Field Filter is a "like" and not an "equals"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.8
    • Fix Version/s: None
    • Labels:
      None
    • Plugin Version:
      3.8.0 (2019122000)
    • Affected Branches:
      MOODLE_38_STABLE

      Description

      Using the query below in the CR plugin, it seems as though the user field filter is using a "like" matching instead of an "equals" matching.  For example, if you choose "EA" from the filter dropdown, the results include any record that has EA anywhere in the given filtered field.  Am I coding this filter correctly?  Is this a bug?

       Select *
      from prefix_user_info_data uid
      where uid.fieldid = 67
      %%FILTER_USERS:uid.data%%

       

        Attachments

          Activity

            People

            Assignee:
            jleyva Juan Leyva
            Reporter:
            kristinmkilburn Kristin Kilburn, PMP
            Participants:
            Component watchers:
            Juan Leyva, Sara Arjona (@sarjona)
            Votes:
            2 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: