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
> > 
> 

Reply via email to