Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-78784

Database engine consistency with DISTINCT group concat in report aggregation

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • 4.3
    • Report builder
    • Microsoft SQL
    • MOODLE_403_STABLE

      We currently can only perform DISTINCT [GROUP_CONCAT|STRING_AGG] aggregation on MySQL, Postgres & Oracle (reference)

      Oracle support was only recently added in MDL-72722. This issue is to investigate support for SQL Server - at which point the current implementation specific to Report builder can be moved into the DML drivers themselves to live alongside the sql_group_concat() API we added in MDL-52817

      Here are some references:

      1. https://www.epiusers.help/t/remove-duplicates-from-string-agg/79468/7
      2. https://www.sqlshack.com/string_agg-function-in-sql/

            Unassigned Unassigned
            pholden Paul Holden
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:

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