待办事项里点击一条记录后打开的页面没有信息

niujiawei

如上图所示，审批人员从待办事项里打开页面后没有显示数据，怎么回事啊？

jishuang

数据怎么过滤的?

niujiawei

jishuang 发表于 2012-12-14 16:33
数据怎么过滤的?

没有设置啊，流转的时候提示没有页面，然后我就用继承的方式根据mainActivity.w新建了一个.w页面，然后把bizData的auto-load属性值设为true，auto-new值设为false

jishuang

process组件的auto-filter怎么设置的？

niujiawei

jishuang 发表于 2012-12-14 16:52
process组件的auto-filter怎么设置的？

true

niujiawei

jishuang 发表于 2012-12-14 16:52
process组件的auto-filter怎么设置的？

process组件只能绑定一个bizData（id为bizData1），这个页面还有另外两个bizData（id分别为bizData2和bizData3），保存的时候我是在bizData1的onAfterSave事件中通过justep.xbl("bizData2").save()来做的。

jishuang

在这个环节的onload事件中获取一下data的rowid看是否能取到

niujiawei

jishuang 发表于 2012-12-14 17:45
在这个环节的onload事件中获取一下data的rowid看是否能取到

这个环节页面是businessActivity2.w，此页面的model的onload事件中添加如下代码：

1. businessActivity2.model1Load = function(event){
   
2.         alert("GO");
   
3.         var data1 = justep.xbl("bizData1");
   
4.         alert(data1);
   
5.         var dataCount = data1.getCount();
   
6.         alert(dataCount);
   
7.         for ( var i = 0; i < dataCount; i++) {
   
8.                  var rowid = data1.getRowId(i);
   
9.                 alert(rowid);
   
10.         }
    
11. };

复制代码

justep.xbl("bizData1").getCount()值为0

zhaixin

参照X5快速开发指南4.6.3.2 配置控制台显示调试信息，看看打开功能时发的sql是什么

niujiawei

zhaixin 发表于 2012-12-17 11:05
参照X5快速开发指南4.6.3.2 配置控制台显示调试信息，看看打开功能时发的sql是什么 ...

三张表，IDDKKHXX，DJDKHT，DJJKRYSF

1. 
   
2. 2012-12-17 12:11:03 获取数据库的连接参数：java:comp/env/system
   
3. 2012-12-17 12:11:03 /LoanApproval/LoanApproval/process/LoanApproval/loanApprovalProcess/businessActivity2/queryIFDKKHXXAction -> create conn :  name=java:comp/env/system, connNum = 1
   
4. 2012-12-17 12:11:03  exec KSQL: SELECT IFDKKHXX.*  FROM IFDKKHXX IFDKKHXX WHERE ((IFDKKHXX='2012121400041')) LIMIT 0, 20
   
5. --> sql:(SELECT  IFDKKHXX.XM AS XM, IFDKKHXX.ZT AS ZT, IFDKKHXX.SFZ AS SFZ, IFDKKHXX.ZY AS ZY, IFDKKHXX.YJCE AS YJCE, IFDKKHXX.JCBL AS JCBL, IFDKKHXX.YNSR AS YNSR, IFDKKHXX.DZ AS DZ, IFDKKHXX.YB AS YB, IFDKKHXX.DH1 AS DH1, IFDKKHXX.DH2 AS DH2, IFDKKHXX.DH3 AS DH3, IFDKKHXX.DH4 AS DH4, IFDKKHXX.GZDW AS GZDW, IFDKKHXX.DWDZ AS DWDZ, IFDKKHXX.EMAIL1 AS EMAIL1, IFDKKHXX.POXM AS POXM, IFDKKHXX.POZJLX AS POZJLX, IFDKKHXX.POZJHM AS POZJHM, IFDKKHXX.PODHHM AS PODHHM, IFDKKHXX.POGZDW AS POGZDW, IFDKKHXX.POYJCE AS POYJCE, IFDKKHXX.POJCBL AS POJCBL, IFDKKHXX.POYNSR AS POYNSR, IFDKKHXX.PONL AS PONL, IFDKKHXX.BEIZ AS BEIZ, IFDKKHXX.JLJGM AS JLJGM, IFDKKHXX.JLRQ AS JLRQ, IFDKKHXX.GXGY AS GXGY, IFDKKHXX.GXRQ AS GXRQ, IFDKKHXX.ZXRQ AS ZXRQ, IFDKKHXX.BTJE AS BTJE, IFDKKHXX.POBTJE AS POBTJE, IFDKKHXX.KHH AS KHH, IFDKKHXX.KHH AS IFDKKHXX FROM IFDKKHXX IFDKKHXX  WHERE IFDKKHXX.KHH = ?)
   
6. --> binds:[2012121400041]
   
7. --> dataModel|M|/LoanApproval/LoanApproval/data
   
8. --> fnModelnull
   
9. 2012-12-17 12:11:03
   
10. exec KSQL: SELECT IFDKKHXX.*  FROM IFDKKHXX IFDKKHXX WHERE ((IFDKKHXX='2012121400041')) LIMIT 0, 20
    
11.   --> sql:(SELECT  IFDKKHXX.XM AS XM, IFDKKHXX.ZT AS ZT, IFDKKHXX.SFZ AS SFZ, IFDKKHXX.ZY AS ZY, IFDKKHXX.YJCE AS YJCE, IFDKKHXX.JCBL AS JCBL, IFDKKHXX.YNSR AS YNSR, IFDKKHXX.DZ AS DZ, IFDKKHXX.YB AS YB, IFDKKHXX.DH1 AS DH1, IFDKKHXX.DH2 AS DH2, IFDKKHXX.DH3 AS DH3, IFDKKHXX.DH4 AS DH4, IFDKKHXX.GZDW AS GZDW, IFDKKHXX.DWDZ AS DWDZ, IFDKKHXX.EMAIL1 AS EMAIL1, IFDKKHXX.POXM AS POXM, IFDKKHXX.POZJLX AS POZJLX, IFDKKHXX.POZJHM AS POZJHM, IFDKKHXX.PODHHM AS PODHHM, IFDKKHXX.POGZDW AS POGZDW, IFDKKHXX.POYJCE AS POYJCE, IFDKKHXX.POJCBL AS POJCBL, IFDKKHXX.POYNSR AS POYNSR, IFDKKHXX.PONL AS PONL, IFDKKHXX.BEIZ AS BEIZ, IFDKKHXX.JLJGM AS JLJGM, IFDKKHXX.JLRQ AS JLRQ, IFDKKHXX.GXGY AS GXGY, IFDKKHXX.GXRQ AS GXRQ, IFDKKHXX.ZXRQ AS ZXRQ, IFDKKHXX.BTJE AS BTJE, IFDKKHXX.POBTJE AS POBTJE, IFDKKHXX.KHH AS KHH, IFDKKHXX.KHH AS IFDKKHXX FROM IFDKKHXX IFDKKHXX  WHERE IFDKKHXX.KHH = ?)
    
12. --> binds:[2012121400041]
    
13. 2012-12-17 12:11:03 sql 执行时间：15ms
    
14. 2012-12-17 12:11:03 KSQL 执行时间：676ms
    
15. 2012-12-17 12:11:03 查询count：
    
16. ->SQL :SELECT count(*) FROM IFDKKHXX IFDKKHXX  WHERE IFDKKHXX.KHH = ?
    
17. ->binds:[2012121400041]
    
18. 2012-12-17 12:11:03 根据名字dataSource获取Config ->/LoanApproval/LoanApproval/data/dataSource@Config
    
19. 2012-12-17 12:11:03 获取数据库的连接参数：java:comp/env/system
    
20. 2012-12-17 12:11:03 /LoanApproval/LoanApproval/process/LoanApproval/loanApprovalProcess/businessActivity2/queryIFDKKHXXAction -> create conn :  name=java:comp/env/system, connNum = 1
    
21. 2012-12-17 12:11:03
    
22. exec KSQL:
    
23.   --> sql:SELECT count(*) FROM IFDKKHXX IFDKKHXX  WHERE IFDKKHXX.KHH = ?
    
24. --> binds:[2012121400041]
    
25. 2012-12-17 12:11:03 sql 执行时间：3ms
    
26. 2012-12-17 12:11:05 /LoanApproval/LoanApproval/process/LoanApproval/loanApprovalProcess/businessActivity2/queryDJJKRYSFAction -> create conn :  name=java:comp/env/system, connNum = 1
    
27. 2012-12-17 12:11:05  exec KSQL: SELECT DJJKRYSF.*  FROM DJJKRYSF DJJKRYSF LIMIT 0, 20
    
28. --> sql:(SELECT  DJJKRYSF.ZT AS ZT, DJJKRYSF.HZXYH AS HZXYH, DJJKRYSF.GFHTH AS GFHTH, DJJKRYSF.FJZE AS FJZE, DJJKRYSF.YFJE AS YFJE, DJJKRYSF.HTJFRQ AS HTJFRQ, DJJKRYSF.HTQDRY AS HTQDRY, DJJKRYSF.JZMJ AS JZMJ, DJJKRYSF.PMJG AS PMJG, DJJKRYSF.LPMC AS LPMC, DJJKRYSF.LHDH AS LHDH, DJJKRYSF.SZDY AS SZDY, DJJKRYSF.SZSH AS SZSH, DJJKRYSF.DZ AS DZ, DJJKRYSF.SZQS AS SZQS, DJJKRYSF.FWJG AS FWJG, DJJKRYSF.FWLX AS FWLX, DJJKRYSF.YHDH AS YHDH, DJJKRYSF.DWMC AS DWMC, DJJKRYSF.YHZH AS YHZH, DJJKRYSF.BEIZ AS BEIZ, DJJKRYSF.HTH AS HTH, DJJKRYSF.HTH AS DJJKRYSF FROM DJJKRYSF DJJKRYSF)
    
29. --> binds:[]
    
30. --> dataModel|M|/LoanApproval/LoanApproval/data
    
31. --> fnModelnull
    
32. 2012-12-17 12:11:05
    
33. exec KSQL: SELECT DJJKRYSF.*  FROM DJJKRYSF DJJKRYSF LIMIT 0, 20
    
34.   --> sql:(SELECT  DJJKRYSF.ZT AS ZT, DJJKRYSF.HZXYH AS HZXYH, DJJKRYSF.GFHTH AS GFHTH, DJJKRYSF.FJZE AS FJZE, DJJKRYSF.YFJE AS YFJE, DJJKRYSF.HTJFRQ AS HTJFRQ, DJJKRYSF.HTQDRY AS HTQDRY, DJJKRYSF.JZMJ AS JZMJ, DJJKRYSF.PMJG AS PMJG, DJJKRYSF.LPMC AS LPMC, DJJKRYSF.LHDH AS LHDH, DJJKRYSF.SZDY AS SZDY, DJJKRYSF.SZSH AS SZSH, DJJKRYSF.DZ AS DZ, DJJKRYSF.SZQS AS SZQS, DJJKRYSF.FWJG AS FWJG, DJJKRYSF.FWLX AS FWLX, DJJKRYSF.YHDH AS YHDH, DJJKRYSF.DWMC AS DWMC, DJJKRYSF.YHZH AS YHZH, DJJKRYSF.BEIZ AS BEIZ, DJJKRYSF.HTH AS HTH, DJJKRYSF.HTH AS DJJKRYSF FROM DJJKRYSF DJJKRYSF)
    
35. --> binds:[]
    
36. 2012-12-17 12:11:05 sql 执行时间：107ms
    
37. 2012-12-17 12:11:05 查询count：
    
38. ->SQL :SELECT count(*) FROM DJJKRYSF DJJKRYSF
    
39. ->binds:[]
    
40. 2012-12-17 12:11:05 根据名字dataSource获取Config ->/LoanApproval/LoanApproval/data/dataSource@Config
    
41. 2012-12-17 12:11:05 获取数据库的连接参数：java:comp/env/system
    
42. 2012-12-17 12:11:05 /LoanApproval/LoanApproval/process/LoanApproval/loanApprovalProcess/businessActivity2/queryDJJKRYSFAction -> create conn :  name=java:comp/env/system, connNum = 1
    
43. 2012-12-17 12:11:05
    
44. exec KSQL:
    
45.   --> sql:SELECT count(*) FROM DJJKRYSF DJJKRYSF
    
46. --> binds:[]
    
47. 2012-12-17 12:11:06 sql 执行时间：38ms
    
48. 2012-12-17 12:11:08 /LoanApproval/LoanApproval/process/LoanApproval/loanApprovalProcess/businessActivity2/queryDJDKHTAction -> create conn :  name=java:comp/env/system, connNum = 1
    
49. 2012-12-17 12:11:08  exec KSQL: SELECT DJDKHT.*  FROM DJDKHT DJDKHT LIMIT 0, 20
    
50. --> sql:(SELECT  DJDKHT.KHH AS KHH, DJDKHT.DBLX AS DBLX, DJDKHT.DKYT AS DKYT, DJDKHT.JKYJ AS JKYJ, DJDKHT.ZT AS ZT, DJDKHT.JKJE AS JKJE, DJDKHT.QHKJE AS QHKJE, DJDKHT.LLDM AS LLDM, DJDKHT.LL AS LL, DJDKHT.FXLL AS FXLL, DJDKHT.HKZQ AS HKZQ, DJDKHT.HKFS AS HKFS, DJDKHT.HKR AS HKR, DJDKHT.JKQX AS JKQX, DJDKHT.WTDKYH AS WTDKYH, DJDKHT.JSSTYH AS JSSTYH, DJDKHT.HKZH AS HKZH, DJDKHT.QSRQ AS QSRQ, DJDKHT.DQRQ AS DQRQ, DJDKHT.ZHBZ AS ZHBZ, DJDKHT.ZHDKHTH AS ZHDKHTH, DJDKHT.ZHDKJE AS ZHDKJE, DJDKHT.ZHDKYHKE AS ZHDKYHKE, DJDKHT.ZHDKLL AS ZHDKLL, DJDKHT.ZHDKMS AS ZHDKMS, DJDKHT.BEIZ AS BEIZ, DJDKHT.DJGY AS DJGY, DJDKHT.DJRQ AS DJRQ, DJDKHT.SHGY AS SHGY, DJDKHT.SHRQ AS SHRQ, DJDKHT.ZXGY AS ZXGY, DJDKHT.ZXRQ AS ZXRQ, DJDKHT.YDJCBZ AS YDJCBZ, DJDKHT.HTH AS HTH, DJDKHT.HTH AS DJDKHT FROM DJDKHT DJDKHT)
    
51. --> binds:[]
    
52. --> dataModel|M|/LoanApproval/LoanApproval/data
    
53. --> fnModelnull
    
54. 2012-12-17 12:11:08
    
55. exec KSQL: SELECT DJDKHT.*  FROM DJDKHT DJDKHT LIMIT 0, 20
    
56.   --> sql:(SELECT  DJDKHT.KHH AS KHH, DJDKHT.DBLX AS DBLX, DJDKHT.DKYT AS DKYT, DJDKHT.JKYJ AS JKYJ, DJDKHT.ZT AS ZT, DJDKHT.JKJE AS JKJE, DJDKHT.QHKJE AS QHKJE, DJDKHT.LLDM AS LLDM, DJDKHT.LL AS LL, DJDKHT.FXLL AS FXLL, DJDKHT.HKZQ AS HKZQ, DJDKHT.HKFS AS HKFS, DJDKHT.HKR AS HKR, DJDKHT.JKQX AS JKQX, DJDKHT.WTDKYH AS WTDKYH, DJDKHT.JSSTYH AS JSSTYH, DJDKHT.HKZH AS HKZH, DJDKHT.QSRQ AS QSRQ, DJDKHT.DQRQ AS DQRQ, DJDKHT.ZHBZ AS ZHBZ, DJDKHT.ZHDKHTH AS ZHDKHTH, DJDKHT.ZHDKJE AS ZHDKJE, DJDKHT.ZHDKYHKE AS ZHDKYHKE, DJDKHT.ZHDKLL AS ZHDKLL, DJDKHT.ZHDKMS AS ZHDKMS, DJDKHT.BEIZ AS BEIZ, DJDKHT.DJGY AS DJGY, DJDKHT.DJRQ AS DJRQ, DJDKHT.SHGY AS SHGY, DJDKHT.SHRQ AS SHRQ, DJDKHT.ZXGY AS ZXGY, DJDKHT.ZXRQ AS ZXRQ, DJDKHT.YDJCBZ AS YDJCBZ, DJDKHT.HTH AS HTH, DJDKHT.HTH AS DJDKHT FROM DJDKHT DJDKHT)
    
57. --> binds:[]
    
58. 2012-12-17 12:11:08 sql 执行时间：12ms2012-12-17 12:11:08 KSQL 执行时间：2250ms
    
59. 2012-12-17 12:11:08 查询count：
    
60. ->SQL :SELECT count(*) FROM DJDKHT DJDKHT
    
61. ->binds:[]
    
62. 2012-12-17 12:11:08 获取数据库的连接参数：java:comp/env/system
    
63. 2012-12-17 12:11:08 /LoanApproval/LoanApproval/process/LoanApproval/loanApprovalProcess/businessActivity2/queryDJDKHTAction -> create conn :  name=java:comp/env/system, connNum = 1
    
64. 2012-12-17 12:11:08
    
65. exec KSQL:
    
66.   --> sql:SELECT count(*) FROM DJDKHT DJDKHT
    
67. --> binds:[]
    
68. 2012-12-17 12:11:08 sql 执行时间：3ms

复制代码