在pgsql 子查询排序问题返回

SqlSugar 沟通中

 3  182

悬赏：0 飞吻

var resultQueryNewData = resultQuery.Select((x) => new t_sntestvalue_status

{

createdate = x.createdate,

sn = x.sn,

station = x.station,

testresult = x.testresult,

testvalue = x.testvalue,

islastflag = x.islastflag,

mahineno = x.mahineno,

projectno = x.projectno,

numberOfTimes = x.numberOfTimes,

processtag = x.processtag,

#region 增加子查询..

sntree = SqlFunc.Subqueryable<t_snTree>()

.Where(t => t.sn == x.sn)

.OrderBy(t=>t.createdate)

.SelectStringJoin(t => t.sntree, ",")

#endregion

});

在子查询中增加排序查询报错 column "t.createdate" must appear in the GROUP BY clause or be used in an aggregate function 我写原生sql查询改成

(SELECT string_agg(("sntree")::text, ',' ORDER BY "t"."createdate")

就可以了但是sqlsugar 中SelectStringJoin 并没有此场景重载，sqlsugar版本是 5.1.4.93 数据库是pgsql

热忱回答（3）