UI流程建模：单表流程和单表流程查询可否合成在一起，若能，能否提供详细样例

huanying441

UI流程建模：单表流程和单表流程查询可否合成在一起，若能，能否提供详细样例

liangyongfei

你是指BeX5 吧！请在BeX5 模块发帖
可以参考任务中心页面的实现

jishuang

如果是需要列表流程可以参考http://docs.wex5.com/bex5-process-question-list-10027/

huanying441

没ksql啥问题

  --> sql:SELECT  DE_CSDLC.fID AS DE_CSDLC, DE_CSDLC.FCS1 AS fCS1, DE_CSDLC.FCS2 AS fCS2, DE_CSDLC.VERSION AS version FROM DE_CSDLC DE_CSDLC  WHERE ? = ?
--> binds:[1, 0]
2017-09-05 14:56:45
exec KSQL: SELECT DE_CSDLC.*  FROM DE_CSDLC DE_CSDLC WHERE ((1=0)) LIMIT 0, 20
  --> sql:SELECT  DE_CSDLC.fID AS DE_CSDLC, DE_CSDLC.FCS1 AS fCS1, DE_CSDLC.FCS2 AS fCS2, DE_CSDLC.VERSION AS version FROM DE_CSDLC DE_CSDLC  WHERE ? = ?
--> binds:[1, 0]
2017-09-05 14:56:45 sql 执行时间：1ms
2017-09-05 14:56:45 sql 执行时间：1ms
2017-09-05 14:56:45 [SQL Time]sql 执行时间：1ms, exec KSQL: SELECT DE_CSDLC.*  FROM DE_CSDLC DE_CSDLC WHERE ((1=0)) LIMIT 0, 20
  --> sql:SELECT  DE_CSDLC.fID AS DE_CSDLC, DE_CSDLC.FCS1 AS fCS1, DE_CSDLC.FCS2 AS fCS2, DE_CSDLC.VERSION AS version FROM DE_CSDLC DE_CSDLC  WHERE ? = ?
--> binds:[1, 0]
2017-09-05 14:56:45
exec KSQL:
  --> sql:SELECT count(*) FROM DE_CSDLC DE_CSDLC  WHERE ? = ?
--> binds:[1, 0]
2017-09-05 14:56:45
exec KSQL:
  --> sql:SELECT count(*) FROM DE_CSDLC DE_CSDLC  WHERE ? = ?
--> binds:[1, 0]
2017-09-05 14:56:45 sql 执行时间：1ms
2017-09-05 14:56:45 sql 执行时间：1ms
2017-09-05 14:56:45 [SQL Time]sql 执行时间：1ms, exec KSQL:
  --> sql:SELECT count(*) FROM DE_CSDLC DE_CSDLC  WHERE ? = ?
--> binds:[1, 0]

jishuang

SELECT  DE_CSDLC.fID AS DE_CSDLC, DE_CSDLC.FCS1 AS fCS1, DE_CSDLC.FCS2 AS fCS2, DE_CSDLC.VERSION AS version FROM DE_CSDLC DE_CSDLC  WHERE ? = ?

这个不是查你的数据的吗？
process上的autoFilter设置为false

huanying441

好的

huanying441

我把process上的autoFilter设置为true。
exec KSQL: SELECT SA_Task.*  FROM SA_Task SA_Task WHERE ((SA_Task.sStatusID='tesReady' or SA_Task.sStatusID='tesExecuting')  and SA_Task.sExecutorFID like '/%' and (SA_Task.sCreatorPersonID=:_cpid)) ORDER BY sCreateTime DESC LIMIT 0, 5
  --> sql:SELECT  SA_Task.sID AS SA_Task, SA_Task.SACTIVITY AS sActivity, SA_Task.SCURL AS sCURL, SA_Task.SCREATETIME AS sCreateTime, SA_Task.SCREATORFNAME AS sCreatorFName, SA_Task.SDATA1 AS sData1, SA_Task.SDATA2 AS sData2, SA_Task.SDATA3 AS sData3, SA_Task.SDATA4 AS sData4, SA_Task.SEXECUTORFID AS sExecutorFID, SA_Task.SEXECUTORFNAME AS sExecutorFName, SA_Task.SEXECUTORNAMES AS sExecutorNames, SA_Task.SNAME AS sName, SA_Task.SPROCESS AS sProcess FROM SA_Task SA_Task  WHERE  ( (SA_Task.SSTATUSID = ?) OR (SA_Task.SSTATUSID = ?) ) AND (SA_Task.SEXECUTORFID LIKE ?) AND (SA_Task.SCREATORPERSONID =  ? )   ORDER BY sCreateTime DESC
--> binds:[tesReady, tesExecuting, /%, PSN01]
2017-09-05 17:11:27
exec KSQL: SELECT SA_Task.*  FROM SA_Task SA_Task WHERE ((SA_Task.sStatusID='tesReady' or SA_Task.sStatusID='tesExecuting')  and SA_Task.sExecutorFID like '/%' and (SA_Task.sCreatorPersonID=:_cpid)) ORDER BY sCreateTime DESC LIMIT 0, 5
  --> sql:SELECT  SA_Task.sID AS SA_Task, SA_Task.SACTIVITY AS sActivity, SA_Task.SCURL AS sCURL, SA_Task.SCREATETIME AS sCreateTime, SA_Task.SCREATORFNAME AS sCreatorFName, SA_Task.SDATA1 AS sData1, SA_Task.SDATA2 AS sData2, SA_Task.SDATA3 AS sData3, SA_Task.SDATA4 AS sData4, SA_Task.SEXECUTORFID AS sExecutorFID, SA_Task.SEXECUTORFNAME AS sExecutorFName, SA_Task.SEXECUTORNAMES AS sExecutorNames, SA_Task.SNAME AS sName, SA_Task.SPROCESS AS sProcess FROM SA_Task SA_Task  WHERE  ( (SA_Task.SSTATUSID = ?) OR (SA_Task.SSTATUSID = ?) ) AND (SA_Task.SEXECUTORFID LIKE ?) AND (SA_Task.SCREATORPERSONID =  ? )   ORDER BY sCreateTime DESC
--> binds:[tesReady, tesExecuting, /%, PSN01]
2017-09-05 17:11:27 sql 执行时间：1ms
2017-09-05 17:11:27 sql 执行时间：1ms
2017-09-05 17:11:27 [SQL Time]sql 执行时间：1ms, exec KSQL: SELECT SA_Task.*  FROM SA_Task SA_Task WHERE ((SA_Task.sStatusID='tesReady' or SA_Task.sStatusID='tesExecuting')  and SA_Task.sExecutorFID like '/%' and (SA_Task.sCreatorPersonID=:_cpid)) ORDER BY sCreateTime DESC LIMIT 0, 5
  --> sql:SELECT  SA_Task.sID AS SA_Task, SA_Task.SACTIVITY AS sActivity, SA_Task.SCURL AS sCURL, SA_Task.SCREATETIME AS sCreateTime, SA_Task.SCREATORFNAME AS sCreatorFName, SA_Task.SDATA1 AS sData1, SA_Task.SDATA2 AS sData2, SA_Task.SDATA3 AS sData3, SA_Task.SDATA4 AS sData4, SA_Task.SEXECUTORFID AS sExecutorFID, SA_Task.SEXECUTORFNAME AS sExecutorFName, SA_Task.SEXECUTORNAMES AS sExecutorNames, SA_Task.SNAME AS sName, SA_Task.SPROCESS AS sProcess FROM SA_Task SA_Task  WHERE  ( (SA_Task.SSTATUSID = ?) OR (SA_Task.SSTATUSID = ?) ) AND (SA_Task.SEXECUTORFID LIKE ?) AND (SA_Task.SCREATORPERSONID =  ? )   ORDER BY sCreateTime DESC
--> binds:[tesReady, tesExecuting, /%, PSN01]

jishuang

1.设置为false不是true
2.sql看查自己业务表的，不是看SA_Task的

huanying441

--> sql:SELECT  DE_CSDLC.fID AS DE_CSDLC, DE_CSDLC.FCS1 AS fCS1, DE_CSDLC.FCS2 AS fCS2, DE_CSDLC.VERSION AS version FROM DE_CSDLC DE_CSDLC  WHERE ? = ?
--> binds:[1, 0]
2017-09-05 14:56:45
exec KSQL: SELECT DE_CSDLC.*  FROM DE_CSDLC DE_CSDLC WHERE ((1=0)) LIMIT 0, 20
  --> sql:SELECT  DE_CSDLC.fID AS DE_CSDLC, DE_CSDLC.FCS1 AS fCS1, DE_CSDLC.FCS2 AS fCS2, DE_CSDLC.VERSION AS version FROM DE_CSDLC DE_CSDLC  WHERE ? = ?
--> binds:[1, 0]
2017-09-05 14:56:45 sql 执行时间：1ms
2017-09-05 14:56:45 sql 执行时间：1ms
2017-09-05 14:56:45 [SQL Time]sql 执行时间：1ms, exec KSQL: SELECT DE_CSDLC.*  FROM DE_CSDLC DE_CSDLC WHERE ((1=0)) LIMIT 0, 20
  --> sql:SELECT  DE_CSDLC.fID AS DE_CSDLC, DE_CSDLC.FCS1 AS fCS1, DE_CSDLC.FCS2 AS fCS2, DE_CSDLC.VERSION AS version FROM DE_CSDLC DE_CSDLC  WHERE ? = ?
--> binds:[1, 0]
2017-09-05 14:56:45
exec KSQL:
  --> sql:SELECT count(*) FROM DE_CSDLC DE_CSDLC  WHERE ? = ?
--> binds:[1, 0]
2017-09-05 14:56:45
exec KSQL:
  --> sql:SELECT count(*) FROM DE_CSDLC DE_CSDLC  WHERE ? = ?
--> binds:[1, 0]
2017-09-05 14:56:45 sql 执行时间：1ms
2017-09-05 14:56:45 sql 执行时间：1ms
2017-09-05 14:56:45 [SQL Time]sql 执行时间：1ms, exec KSQL:
  --> sql:SELECT count(*) FROM DE_CSDLC DE_CSDLC  WHERE ? = ?
--> binds:[1, 0]

jishuang

process组件上的autoFilter设置为false了吗？sql中输出的条件明显还是true，要设置为false