JLR,
You mean... to write a parser that parses raw "OFBiz SQL" (with OFBiz data types), and translates
that into RDBMS-specific SQL?
Jonathon
Jacques Le Roux wrote:
I did not resist to resurrect this old thread :
http://www.nabble.com/Dev---RFC%3A-ofbiz-entity-sql%2890--done%29-tf1313496.html#a3500828
FWIW
Jacques
De : "Jacques Le Roux" <[EMAIL PROTECTED]>
http://ofbiz.apache.org/docs/entity.html look at Grouping and Summary Data
Jacques
De : "vijay Si" <[EMAIL PROTECTED]>
Is there any funtionality provided for using aggregate functions
(sum,min,max..) and count() for querrying to data base through bsh.
for egg: how can we write following in BSH :
Select sum(order_id),sum(grand_total) from order_header where
order_type_id="PURCHASE_ORDER";
Regards