流程打开没有数据（之前有数据）

chenminfq

流程原先有数据，后来为了增加sData2的值，写了一点修改，但是第一，第三节点的内容打开变成没有数据了，只有第二节点的有数据。能否帮忙看看。 activityTask.rar (175.25 KB, 下载次数: 171)

2018-3-27 16:25 上传

点击文件名下载附件
UI2 activityTask-process.rar (9.52 KB, 下载次数: 176)

2018-3-27 16:25 上传

点击文件名下载附件
Process

UI2中，activityTask.w 是父窗口，继承生成三个节点的窗口：activityTaskStart.w、activityTaskExec.w、activityTaskConfirm.w，
流程是 启动，执行，确认。
现在执行流程新建后，只有执行节点的窗口打开有数据。

jishuang

把sql语句打出来看看执行的sql是什么
http://bbs.wex5.com/forum.php?mo ... 4&pid=165004035

chenminfq

//在提交任务一览中点击之前生成并流转出去的任务，显示空
2018-03-27 17:08:18 [SQL Time]sql 执行时间：1ms, exec KSQL: select t from SA_Task t where t=:task
  --> sql:SELECT  t.sID FROM SA_Task t  WHERE t.sID =  ?
--> binds:[612D2B350FE34BB992C7BC1CD5B91BD7]
2018-03-27 17:08:18 [SQL Time]sql 执行时间：1ms, exec KSQL: select task.sParent, task.sData1, task.sData2, task.sData3, task.sData4 from SA_Task task where task=:task
  --> sql:SELECT  task.sParentID AS sParent, task.SDATA1 AS sData1, task.SDATA2 AS sData2, task.SDATA3 AS sData3, task.SDATA4 AS sData4 FROM SA_Task task  WHERE task.sID =  ?
--> binds:[612D2B350FE34BB992C7BC1CD5B91BD7]
2018-03-27 17:08:18 [SQL Time]sql 执行时间：1ms, exec KSQL: select task.sParent, task.sData1, task.sData2, task.sData3, task.sData4 from SA_Task task where task=:task
  --> sql:SELECT  task.sParentID AS sParent, task.SDATA1 AS sData1, task.SDATA2 AS sData2, task.SDATA3 AS sData3, task.SDATA4 AS sData4 FROM SA_Task task  WHERE task.sID =  ?
--> binds:[5B24BEDC179F4EA99CA2927C42FE7F42]
2018-03-27 17:08:18 [SQL Time]sql 执行时间：2ms, exec KSQL: SELECT Activity_task.*,Bpm_sys_code.CODE_NAME as TASK_STATUS_NAME,SA_OPPerson.sName as EXECUTOR_NAME,SA_OPPerson_2.sName as CONFIRMOR_NAME  FROM Activity_task Activity_task  optional  join Bpm_sys_code Bpm_sys_code on Activity_task.TASK_STATUS = Bpm_sys_code.CODE_ID AND Bpm_sys_code.CODE_FATHER_ID = '5' optional  join SA_OPPerson SA_OPPerson on SA_OPPerson = Activity_task.EXECUTOR optional  join SA_OPPerson SA_OPPerson_2 on Activity_task.CONFIRMOR = SA_OPPerson_2 WHERE ((Activity_task='0BC2851DB08547E6A504C12A64D48A65')) LIMIT 0, -1
  --> sql:SELECT  Activity_task.ACTIVITY_ID AS ACTIVITY_ID, Activity_task.TASK_ID AS Activity_task, Activity_task.COMPLETED_DATE AS COMPLETED_DATE, Activity_task.CONFIRMOR AS CONFIRMOR, SA_OPPerson_2.SNAME AS CONFIRMOR_NAME, Activity_task.EXECUTOR AS EXECUTOR, SA_OPPerson.SNAME AS EXECUTOR_NAME, Activity_task.REQUEST_DATE AS REQUEST_DATE, Activity_task.TASK_DESC AS TASK_DESC, Activity_task.TASK_FILE AS TASK_FILE, Activity_task.TASK_REPORT AS TASK_REPORT, Activity_task.TASK_STATUS AS TASK_STATUS, Bpm_sys_code.CODE_NAME AS TASK_STATUS_NAME, Activity_task.STASKID1 AS sTaskID1 FROM activity_task Activity_task LEFT JOIN bpm_sys_code Bpm_sys_code ON  (Activity_task.TASK_STATUS = Bpm_sys_code.CODE_ID) AND (Bpm_sys_code.CODE_FATHER_ID = ?)  LEFT JOIN SA_OPPerson SA_OPPerson ON SA_OPPerson.sID = Activity_task.EXECUTOR LEFT JOIN SA_OPPerson SA_OPPerson_2 ON Activity_task.CONFIRMOR = SA_OPPerson_2.sID  WHERE Activity_task.TASK_ID = ?
--> binds:[5, 0BC2851DB08547E6A504C12A64D48A65]
2018-03-27 17:08:18 [SQL Time]sql 执行时间：1ms, exec KSQL: SELECT Fy_sys_user.*,SA_OPPerson  FROM Fy_sys_user Fy_sys_user  optional  join SA_OPPerson SA_OPPerson on Fy_sys_user.USER_CODE = SA_OPPerson.sCode LIMIT 0, -1
  --> sql:SELECT  Fy_sys_user.DEPARTMENT AS DEPARTMENT, Fy_sys_user.GUID AS Fy_sys_user, SA_OPPerson.sID, Fy_sys_user.USER_CODE AS USER_CODE, Fy_sys_user.USER_NAME AS USER_NAME, Fy_sys_user.USER_POSITION AS USER_POSITION, Fy_sys_user.USER_SEX AS USER_SEX FROM fy_sys_user Fy_sys_user LEFT JOIN SA_OPPerson SA_OPPerson ON Fy_sys_user.USER_CODE = SA_OPPerson.SCODE
--> binds:[]
2018-03-27 17:08:19 [SQL Time]sql 执行时间：1ms, exec KSQL: SELECT Bpm_sys_code.*  FROM Bpm_sys_code Bpm_sys_code WHERE ((CODE_FATHER_ID=4)) LIMIT 0, -1
  --> sql:SELECT  Bpm_sys_code.GUID AS Bpm_sys_code, Bpm_sys_code.CODE_FATHER_ID AS CODE_FATHER_ID, Bpm_sys_code.CODE_ID AS CODE_ID, Bpm_sys_code.CODE_NAME AS CODE_NAME, Bpm_sys_code.CODE_NAME_EN AS CODE_NAME_EN, Bpm_sys_code.CREATE_DATE AS CREATE_DATE, Bpm_sys_code.DELETE_FLAG AS DELETE_FLAG, Bpm_sys_code.ORDER_BY AS ORDER_BY FROM bpm_sys_code Bpm_sys_code  WHERE CODE_FATHER_ID = ?
--> binds:[4]
//被指派者登录后在待办任务点击，显示需要执行的任务，有数据。
2018-03-27 17:11:17 [SQL Time]sql 执行时间：1ms, exec KSQL: select t from SA_Task t where t=:task
  --> sql:SELECT  t.sID FROM SA_Task t  WHERE t.sID =  ?
--> binds:[612D2B350FE34BB992C7BC1CD5B91BD7]
2018-03-27 17:11:17 [SQL Time]sql 执行时间：1ms, exec KSQL: select task.sParent, task.sData1, task.sData2, task.sData3, task.sData4 from SA_Task task where task=:task
  --> sql:SELECT  task.sParentID AS sParent, task.SDATA1 AS sData1, task.SDATA2 AS sData2, task.SDATA3 AS sData3, task.SDATA4 AS sData4 FROM SA_Task task  WHERE task.sID =  ?
--> binds:[612D2B350FE34BB992C7BC1CD5B91BD7]
2018-03-27 17:11:17 [SQL Time]sql 执行时间：1ms, exec KSQL: select task.sParent, task.sData1, task.sData2, task.sData3, task.sData4 from SA_Task task where task=:task
  --> sql:SELECT  task.sParentID AS sParent, task.SDATA1 AS sData1, task.SDATA2 AS sData2, task.SDATA3 AS sData3, task.SDATA4 AS sData4 FROM SA_Task task  WHERE task.sID =  ?
--> binds:[5B24BEDC179F4EA99CA2927C42FE7F42]
2018-03-27 17:11:17 [SQL Time]sql 执行时间：2ms, exec KSQL: SELECT Activity_task.*,Bpm_sys_code.CODE_NAME as TASK_STATUS_NAME,SA_OPPerson.sName as EXECUTOR_NAME,SA_OPPerson_2.sName as CONFIRMOR_NAME  FROM Activity_task Activity_task  optional  join Bpm_sys_code Bpm_sys_code on Activity_task.TASK_STATUS = Bpm_sys_code.CODE_ID AND Bpm_sys_code.CODE_FATHER_ID = '5' optional  join SA_OPPerson SA_OPPerson on SA_OPPerson = Activity_task.EXECUTOR optional  join SA_OPPerson SA_OPPerson_2 on Activity_task.CONFIRMOR = SA_OPPerson_2 WHERE ((Activity_task='0BC2851DB08547E6A504C12A64D48A65')) LIMIT 0, -1
  --> sql:SELECT  Activity_task.ACTIVITY_ID AS ACTIVITY_ID, Activity_task.TASK_ID AS Activity_task, Activity_task.COMPLETED_DATE AS COMPLETED_DATE, Activity_task.CONFIRMOR AS CONFIRMOR, SA_OPPerson_2.SNAME AS CONFIRMOR_NAME, Activity_task.EXECUTOR AS EXECUTOR, SA_OPPerson.SNAME AS EXECUTOR_NAME, Activity_task.REQUEST_DATE AS REQUEST_DATE, Activity_task.TASK_DESC AS TASK_DESC, Activity_task.TASK_FILE AS TASK_FILE, Activity_task.TASK_REPORT AS TASK_REPORT, Activity_task.TASK_STATUS AS TASK_STATUS, Bpm_sys_code.CODE_NAME AS TASK_STATUS_NAME, Activity_task.STASKID1 AS sTaskID1 FROM activity_task Activity_task LEFT JOIN bpm_sys_code Bpm_sys_code ON  (Activity_task.TASK_STATUS = Bpm_sys_code.CODE_ID) AND (Bpm_sys_code.CODE_FATHER_ID = ?)  LEFT JOIN SA_OPPerson SA_OPPerson ON SA_OPPerson.sID = Activity_task.EXECUTOR LEFT JOIN SA_OPPerson SA_OPPerson_2 ON Activity_task.CONFIRMOR = SA_OPPerson_2.sID  WHERE Activity_task.TASK_ID = ?
--> binds:[5, 0BC2851DB08547E6A504C12A64D48A65]
2018-03-27 17:11:17 [SQL Time]sql 执行时间：1ms, exec KSQL: SELECT Fy_sys_user.*,SA_OPPerson  FROM Fy_sys_user Fy_sys_user  optional  join SA_OPPerson SA_OPPerson on Fy_sys_user.USER_CODE = SA_OPPerson.sCode LIMIT 0, -1
  --> sql:SELECT  Fy_sys_user.DEPARTMENT AS DEPARTMENT, Fy_sys_user.GUID AS Fy_sys_user, SA_OPPerson.sID, Fy_sys_user.USER_CODE AS USER_CODE, Fy_sys_user.USER_NAME AS USER_NAME, Fy_sys_user.USER_POSITION AS USER_POSITION, Fy_sys_user.USER_SEX AS USER_SEX FROM fy_sys_user Fy_sys_user LEFT JOIN SA_OPPerson SA_OPPerson ON Fy_sys_user.USER_CODE = SA_OPPerson.SCODE
--> binds:[]
2018-03-27 17:11:17 [SQL Time]sql 执行时间：1ms, exec KSQL: SELECT Bpm_sys_code.*  FROM Bpm_sys_code Bpm_sys_code WHERE ((CODE_FATHER_ID=4)) LIMIT 0, -1
  --> sql:SELECT  Bpm_sys_code.GUID AS Bpm_sys_code, Bpm_sys_code.CODE_FATHER_ID AS CODE_FATHER_ID, Bpm_sys_code.CODE_ID AS CODE_ID, Bpm_sys_code.CODE_NAME AS CODE_NAME, Bpm_sys_code.CODE_NAME_EN AS CODE_NAME_EN, Bpm_sys_code.CREATE_DATE AS CREATE_DATE, Bpm_sys_code.DELETE_FLAG AS DELETE_FLAG, Bpm_sys_code.ORDER_BY AS ORDER_BY FROM bpm_sys_code Bpm_sys_code  WHERE CODE_FATHER_ID = ?
--> binds:[4]


上述两套SQL是一样的。

jishuang

不会显示数据的页面打开执行的sql到数据库中能查出数据吗？

chenminfq

可以。

jishuang

data的刷新后事件中获取data，然后toJson()看看里面有数据吗？

chenminfq

有个判断没对，自动 new了一条数据。谢谢
请结贴