Gorm Postgres hopes to add string.agg to replace GroupConcat

Describe the feature

count, err := qu.WithContext(ctx). Select( qu.UID, qu.Name, qu.Avatar, qu.PhoneNumber, qu.Email, qu.Gender, qu.BirthDay, qu.Address, qu.Desc, qu.IsDefault, qu.Status, qr.Name.GroupConcat().As("Role"), qd.Name.As("Dept"), qu.LastLoginTime, qu.CreatedAt, ). Where(where...). LeftJoin(qur, qur.UID.EqCol(qu.UID)). LeftJoin(qr, qr.Label.EqCol(qur.RoleLabel)). LeftJoin(qd, qd.Label.EqCol(qu.DepartmentLabel)). Group( qu.ID, qu.UID, qu.Name, qu.Avatar, qu.PhoneNumber, qu.Email, qu.Gender, qu.BirthDay, qu.Address, qu.Desc, qu.IsDefault, qu.Status, qd.Name, qu.LastLoginTime, qu.CreatedAt, ). Order(order). ScanByPage(&result, (s.CurrentPage-1)*s.PageSize, s.PageSize)

Motivation

Related Issues

Motivation

Related Issues

Comment From: github-actions[bot]

This issue has been automatically marked as stale because it has been open 360 days with no activity. Remove stale label or comment or this will be closed in 180 days