Add GROUP_CONCAT aggregate function to views

Created on 16 August 2017, about 7 years ago
Updated 9 August 2024, 3 months ago

It would be very useful for to have a GROUP_CONCAT available as an aggregate function. like what we have now e.g. SUM, MIN, ...

✨ Feature request
Status

Needs work

Version

11.0 πŸ”₯

Component
ViewsΒ  β†’

Last updated about 4 hours ago

Created by

πŸ‡¦πŸ‡ΊAustralia b.ravanbakhsh Adelaide

Live updates comments and jobs are added and updated live.
  • Needs tests

    The change is currently missing an automated test that fails when run with the original code, and succeeds when the bug has been fixed.

Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • πŸ‡·πŸ‡ΊRussia Andrew Answer Novosibirsk

    Can we have a list of entity links instead of list of strings? It would be very useful too.

  • πŸ‡¬πŸ‡·Greece vensires

    This is actually a long standing issue and other than turning in into a MR so that we can easily update it with the latest module commits, I don't think this will ever get into core. The main reason is that GROUP_CONCAT() is only valid for MySQL databases. PostreSQL has STRING_AGG() and SQL Server requires some strange stuff to accomplish it.

    So, from what I understand, we have only a few options here.

    Either implement a solution taking into account the database type, either invoke a hook/event/plugin/something to allow other custom or contrib modules to add their own solutions. Contrib modules are more easy to target a specific database than core.

  • πŸ‡¨πŸ‡¦Canada phjou Vancouver πŸ‡¨πŸ‡¦ πŸ‡ͺπŸ‡Ί

    The patch was not working anymore on drupal 11, rewrote the patch and also fix a couple other comments since the patch was fixing that too.

  • πŸ‡§πŸ‡ͺBelgium f2boot

    Drupal in #43 was also working for Drupal 10.3.1,
    but Drupal 10.3.2 brings some clean up of comments in views module. Patch in #43 includes some of these that are therefore not needed anymore => removed from this patch

Production build 0.71.5 2024