調用action後 data有數據 但datatables無法顯示出來

594狂

-------------------------------------------------------------------------------------------
rs.getString(1);
有數據
------------------------------------------------------------------------------------------------
Table table= com.justep.system.util.BizUtils.resultSet2Table(rs, "/dfs/dfs1/data");
System.out.println(new com.justep.system.transform.Table2Row().transform(table,null).asXML());
table沒數據

jishuang

把输出的信息发一下看看

594狂

1. Pending on MOQ confirmation
   
2. 2016-12-24 19:03:24.78
   
3. Container type is chosen
   
4. 2016-12-24 19:03:24.78
   
5. Truck-booking files are ready
   
6. 2016-12-24 19:03:24.78
   
7. Palletization method is determined
   
8. 2016-12-24 19:03:24.78
   
9. Production completed
   
10. 2016-12-24 19:03:24.78
    
11. Set to ship
    
12. 2016-12-24 19:03:24.78
    
13. Scheduled for production
    
14. 2016-12-24 19:03:24.78
    
15. Production in progress
    
16. 2016-12-24 19:03:24.78
    
17. Grouped into batch
    
18. 2016-12-24 19:03:24.78
    
19. DN No is created
    
20. 2016-12-24 19:03:24.78
    
21. Released
    
22. 2016-12-24 19:03:24.78
    
23. Pending on MOQ confirmation
    
24. 2016-12-24 19:03:24.78
    
25. <rows><userdata name="model">/dfs/dfs1/data</userdata><userdata name="id-column-name">shown_state</userdata><userdata name="id-column-type">String</userdata><userdata name="id-column-define"/><userdata name="userdata">whereVersion</userdata><userdata name="relations">EXPRESS</userdata><userdata name="relation-types">DateTime</userdata><userdata name="relation-alias">create_date</userdata><userdata name="sys.rowid">shown_state</userdata></rows>

复制代码

jishuang

就简单的selece把后面的inner 去掉看看是否正确

594狂

---

查詢語句改成->  String sql="Select * from po_processlog";
轉table後依舊無數據
以下是輸出

1. Cisco - NV&RE
   
2. Apple ACK
   
3. Apple ACK
   
4. Cisco - NV&RE
   
5. Cisco - NV&RE
   
6. Apple ACK
   
7. Apple ACK
   
8. Apple ACK
   
9. Apple ACK
   
10. Apple ACK
    
11. Apple ACK
    
12. Apple ACK
    
13. Cisco -NV&RE
    
14. Apple ACK
    
15. Cisco - NV&RE
    
16. Apple ACK
    
17. Cisco -NV&RE
    
18. Cisco - NV&RE
    
19. Apple ACK
    
20. Apple ACK
    
21. Cisco -NV&RE
    
22. Apple ACK
    
23. Cisco - NV&RE
    
24. Cisco -NV&RE
    
25. Cisco - NV&RE
    
26. Apple ACK
    
27. Cisco - NV&RE
    
28. Cisco - NV&RE
    
29. Apple ACK
    
30. Cisco - NV&RE
    
31. Apple ACK
    
32. Apple ACK
    
33. Apple ACK
    
34. Cisco - NV&RE
    
35. Apple ACK
    
36. Cisco - NV&RE
    
37. Apple ACK
    
38. Cisco - NV&RE
    
39. Cisco -NV&RE
    
40. Apple ACK
    
41. Apple ACK
    
42. Cisco -NV&RE
    
43. <rows><userdata name="model">/dfs/dfs1/data</userdata><userdata name="userdata">whereVersion</userdata><userdata name="relations">EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS</userdata><userdata name="relation-types">String,String,String,String,String,Integer,String,String,String,DateTime,String,DateTime,String</userdata><userdata name="relation-alias">id,route_name,po_no,station_code,station_status,pf_value,del_flag,remarks,create_by,create_date,update_by,update_date,poitem_id</userdata></rows>

复制代码

jishuang

这个表对应的有概念吗？本地测试没问题

594狂

有設概念阿.....。為何會抓的到欄位名但抓不到數據呢....

jishuang

把你的BIZ层ontology和java等文件发一下，我用你的测试看看

594狂

發了...............
java文件:   Dfs1.java
ontology文件:   dfs1_ontology

jishuang

你好楼主，这个问题需要我在本地环境进行问题重现，所以会花费较长时间，请你耐心等待，我完成后会第一时间反馈结果，谢谢！