tableRead-notes

tableRead-like

http://192.168.10.8:8080/erp/tableRead?
db=BR201312111529
&table=SOPOQTY
&order=recordID%20asc%20
&limit=25&offset=0&fields=recordid,if(isnull(SALES_ORDER),%22%22,SALES_ORDER),if(isnull(ITEM),%22%22,ITEM),if(isnull(DESCRIPTION),%22%22,DESCRIPTION),if(isnull(NAME),%22%22,NAME),if(isnull(SOQTY-POQTY),%22%22,SOQTY-POQTY)&key=sosta&value=%27A%27%20and%20SUPPLIER:`%`%20
&format=S,S,S,S,S,S
&where=where%20SOqty%3Epoqty%20and%20SUPPLIER%20like%20`^^`
&callback=?


example : where  (like, inlist , >  )
where=where SOqty>poqty  and SUPPLIER like `^'+parent.currentEntity+'^` and 
FIND_IN_SET(TRIM(SODP_RecordID),"'+parent.currentChoose+'"):0