自定義sql action(標準動作擴展) , ::filter 報錯

594狂

1. 
   
2. Map<String, String> sql = new HashMap<String, String>();
   
3. sql.put(SQL.DEFAULT_DB_NAME,        
   
4. "Select po_puritem.id, po_puritem.po_status, md_customer.name, po_puritem.produce_target_date, po_purmaster.po_type, po_purmaster.cust_po_no,po_puritem.po_lineno,po_puritem.sku_no,po_puritem.po_qty From po_puritem Inner Join (po_purmaster Inner Join md_customer as md_customer on po_purmaster.customer_code = md_customer.customer_code) ON po_purmaster.id = po_puritem.po_id "
   
5. + "Where po_puritem.del_flag = '0' AND (po_puritem.current_station = 'PO30' OR po_puritem.current_station = 'PO31' OR po_puritem.current_station = 'PO32' OR po_puritem.current_station = 'PO33')"  
   
6. + " ::filter "
   
7. + " :: order by "
   
8. );
   

复制代码

後端:
.java文件中的sql語句添加
+ " ::filter "
+ " :: order by "

前端:
使用datatables的排序 和 smartfilter

我參考這篇教學做的 但是報錯
http://bbs.wex5.com/forum.php?mod=viewthread&tid=92168&extra=&page=1

jishuang

这个是baas里面的，不是BeX5中的

BeX5中要传参可以参考
然后自己接受到参数拼接语句/UI2/demo/actions/process/invokeAction/mainActivity.w