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

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • None
    • 3.8
    • None
    • 3.8.0 (2019122000)
    • MOODLE_38_STABLE

      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%%

       

            jleyva Juan Leyva
            kristinmkilburn Kristin Kilburn, PMP
            Votes:
            2 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.