Look into the entitymodel.xml view entities. You will see the alias entity-alias="" name="" and function="avg or count or max or min or sum". For this you need to set the flag group-by="true" on field for which you want to see the max or min or avg. so that it will work on that set only.
HTH! Rishi Solanki Manager, Enterprise Software Development HotWax Media Pvt. Ltd. Direct: +91-9893287847 http://www.hotwaxmedia.com On Tue, Aug 2, 2011 at 3:24 PM, biletnikov <biletni...@gmail.com> wrote: > Hello, > is it possible to use the sql functions : MAX() MIN() AVG() and etc. via > the entity engine? > And how to do that? > > Thanks. > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/Entity-engine-sql-functions-MAX-MIN-AVG-and-etc-tp3711848p3711848.html > Sent from the OFBiz - Dev mailing list archive at Nabble.com. >