You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Rishi Solanki <ri...@gmail.com> on 2011/08/05 10:40:29 UTC
Re: Entity engine, sql functions: MAX() MIN() AVG() and etc.
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 <bi...@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.
>
Re: Entity engine, sql functions: MAX() MIN() AVG() and etc.
Posted by biletnikov <bi...@gmail.com>.
Thank you very much.
On Fri, Aug 5, 2011 at 11:41 AM, Rishi Solanki [via OFBiz] <
ml-node+3720708-983638428-170824@n4.nabble.com> wrote:
> 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 <[hidden email]<http://user/SendEmail.jtp?type=node&node=3720708&i=0>>
> 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.
> >
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://ofbiz.135035.n4.nabble.com/Entity-engine-sql-functions-MAX-MIN-AVG-and-etc-tp3711848p3720708.html
> To unsubscribe from Entity engine, sql functions: MAX() MIN() AVG() and
> etc., click here<http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=3711848&code=YmlsZXRuaWtvdkBnbWFpbC5jb218MzcxMTg0OHwyMDcwNzk3NDQ4>.
>
>
--
Best regards,
Sergei Biletnikov
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Entity-engine-sql-functions-MAX-MIN-AVG-and-etc-tp3711848p3722457.html
Sent from the OFBiz - Dev mailing list archive at Nabble.com.