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

Database engine consistency with DISTINCT group concat in report aggregation

    XMLWordPrintable

Details

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

    Description

      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/

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:

                Clockify

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