关于数据排序的问题

风起长林开发

请问我现在查询出的流程审批记录改怎样排序，目前只能设置按字段没有办法设置按一定的条件排序，同样的在开发界面SQL中就可以执行SELECT SA_Task.*
FROM SA_Task SA_Task
WHERE (( (SA_Task.sWithdraw is null) OR (SA_Task.sWithdraw = 0) ) AND ( ( (SA_Task.sKindID = 'tkTask') AND (SA_Task.sExecutorPersonID is not null) AND ( SA_Task.sStatusID in ('tesPaused', 'tesFinished', 'tesReturned', 'tesAborted', 'tesTransmited', 'tesWaited') ) ) OR ( (SA_Task.sKindID = 'tkExecutor') AND ( SA_Task.sStatusID in ('tesPaused', 'tesFinished', 'tesReturned', 'tesAborted', 'tesTransmited') ) ) )) AND (((SA_Task.sData1 in (select x.sData1 from SA_Task x where x.sData1 = '8E9A7A015AD442C6805C9B5B960A8621'))))
ORDER BY (case SA_Task.sExecutorPersonName when 'user168' then 1 when 'system' then 2 else 3 end),SA_Task.sActualFinishTime desc LIMIT 0, 20
上面这段语句在SQL中就可以执行，但不知道该怎么设置，设置到orderby中后就报错

jishuang

自己重写queryAction，写ksql

风起长林开发

jishuang 发表于 2020-2-11 19:37
自己重写queryAction，写ksql

没有用，这段报错
ORDER BY (case SA_Task.sExecutorPersonName when 'user168' then 1 when 'system' then 2 else 3 end),SA_Task.sActualFinishTime desc LIMIT 0, 20

jishuang

如果ksql编辑器中测试正确，重写queryAction直接写完整的ksql就应该不行
不行就需要用sql实现

风起长林开发

jishuang 发表于 2020-2-12 09:20
如果ksql编辑器中测试正确，重写queryAction直接写完整的ksql就应该不行
不行就需要用sql实现 ...

你好，重写queryAction应该怎么重写，有没有例子程序，我参考一下，现在没有太多时间去学习了

jishuang

http://bbs.wex5.com/forum.php?mod=viewthread&tid=54836

风起长林开发

jishuang 发表于 2020-2-12 13:17
http://bbs.wex5.com/forum.php?mod=viewthread&tid=54836

请问.w文件js中能写ksql吗，好像执行不到报错

jishuang

不能

风起长林开发

jishuang 发表于 2020-2-12 18:00
不能

那要怎么才能写才行，有没有例子

风起长林开发

jishuang 发表于 2020-2-12 18:00
不能

另外写到这里也不行，前台报错
刷新数据失败！ ,
执行sql: SELECT SA_Task.*  FROM SA_Task SA_Task WHERE (( (SA_Task.sWithdraw is null) OR (SA_Task.sWithdraw = 0) ) AND ( ( (SA_Task.sKindID = 'tkTask') AND (SA_Task.sExecutorPersonID is not null) AND ( SA_Task.sStatusID in ('tesPaused', 'tesFinished', 'tesReturned', 'tesAborted', 'tesTransmited', 'tesWaited') ) ) OR ( (SA_Task.sKindID = 'tkExecutor') AND ( SA_Task.sStatusID in ('tesPaused', 'tesFinished', 'tesReturned', 'tesAborted', 'tesTransmited') ) ) )) AND (((SA_Task.sFlowID in (select x.sFlowID from SA_Task x where (x.sData1 = '26325199BB3A4FD3960F8C9548735565') and (x.sProcess='/OA/car/process/carUseApplyQuery/carUseApplyQueryProcess'))))) ORDER BY SA_Task.sActualFinishTime asc LIMIT 0, 20, binds: []出错
编码：JUSTEP150039