grid控件自带的排序功能不对

jishuang

在bizData上设置order by看看你的sql中会不会输出

确认queryAciton设置的是下面的sql?SELECT sum(PRJ_PRJ.eIncome) as eIncomes,sum(PRJ_PRJ.eCost) as eCosts,
sum(PRJ_PrjSum.SUMQRHT) as SUMQRHTS,sum(PRJ_PrjSum.SUMJFJS) as SUMJFJSS,
sum(PRJ_PrjSum.SUMAMOUNT) as SUMAMOUNTS,sum(PRJ_PrjSum.SUMRECAMOUNT) as SUMRECAMOUNTS,
sum(PRJ_PrjSum.SUMYSKKP) as SUMYSKKPS,sum(PRJ_PrjSum.SUMYSK) as SUMYSKS,
sum(PRJ_PrjSum.SUMCGDD) as SUMCGDDS,sum(PRJ_PrjSum.SUMCGSP) as SUMCGSPS,
sum(PRJ_PrjSum.SUMCGFK) as SUMCGFKS,sum(PRJ_PrjSum.SUMFBWT) as SUMFBWTS,
sum(PRJ_PrjSum.SUMFBJS) as SUMFBJSS,sum(PRJ_PrjSum.SUMFBSP) as SUMFBSPS,
sum(PRJ_PrjSum.SUMFBFK) as SUMFBFKS,sum(PRJ_PrjSum.SUMCZ) as SUMCZS,
sum(PRJ_PrjSum.SUMNBCB) as SUMNBCBS  FROM PRJ_PRJ PRJ_PRJ  optional  join PRJ_PrjSum PRJ_PrjSum on PRJ_PrjSum.prjNo = PRJ_PRJ.prjNo WHERE (PRJ_PRJ.fDelFlag = 1 AND ( PRJ_PRJ.prjNo is not null OR PRJ_PRJ.prjName is not null ) AND PRJ_PRJ.prjStatus  = '进行中') AND (((PRJ_PRJ.fCreatePersonFID='/100000.ogn/100005.dpt/J100164@100005.psm'  or PRJ_PRJ.prjChiefID = 'J100164')))

lygyy007

设置了order by，显示的数据是按照orderby 的正序排列正确的排列了，但是控制台没有输出orderby 这些语句，而且点击字段排序还是不对。

jishuang

用的是平台默认的queryAction吗？