Hi Jonathon, i cannot use the view-entity for querrying, as it would cause a performance hit. Is there any other method to get the above querry. Do u know of any ways to do it through bsh script.
Regards On 9/15/07, Jonathon -- Improov <[EMAIL PROTECTED]> wrote: > > Use the GenericDelegator and related classes, I think. Or maybe not. I > can't recall the aggregate > functions there. > > The entity definitions do have those, though. The <view-entity>? Oh yes, > the <view-entity>. > > Try using DynamicViewEntity to construct a <view-entity>. > > Jonathon > > vijay Si wrote: > > 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 > > > > > > > > ------------------------------------------------------------------------ > > > > No virus found in this incoming message. > > Checked by AVG Free Edition. > > Version: 7.5.487 / Virus Database: 269.13.19/1008 - Release Date: > 9/14/2007 8:59 AM > >