Adding groupbByConcat support to dbtng

Created on 30 January 2013, over 12 years ago

Updated 30 April 2025, 4 months ago

It would be pretty cool to have a groupby_concat() functionality in dbtng.

For mysql that's support native, but for pgsql there seems to be quite some workarounds: http://stackoverflow.com/questions/2560946/postgresql-group-concat-equiv... , but no idea about sqlite so far.

As the pgsql variant would probably just support the columns and maybe the seperator what about the following pseudo-code/signature:


interface SelectInterface ... {
  function groupByAggregate($seperator = ',') {
    $fields = func_get_args();
    // Remove the separators
    array_shift($fields);
  }
}

✨ Feature request

Status

Postponed: needs info

Version

11.0 🔥

Component

database system

Created by

🇩🇪Germany dawehner

Live updates comments and jobs are added and updated live.

stale-issue-cleanup
To track issues in the developing policy for closing stale issues, [Policy, no patch] closing older issues

Incomplete comments

Comments & Activities

Not all content is available!

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

Comment 4 months ago →
🇺🇸United States smustgrave
Thank you for sharing your idea for improving Drupal.

We are working to decide if this proposal meets the Criteria for evaluating proposed changes. There hasn't been any discussion here for over 8 years which suggests that this has either been implemented or there is no community support. Your thoughts on this will allow a decision to be made.

Since we need more information to move forward with this issue, the status is now Postponed (maintainer needs more info). If we don't receive additional information to help with the issue, it may be closed after three months.

Thanks!
Comment about 11 hours ago →
🇺🇸United States smustgrave
Wanted to bump 1 more time before closing.

contrib.social Blog FAQ Discussions

Production build 0.71.5 2024