Re: [google-appengine] Re: is there any max() function available in appengine datastore to find max of selected records

[Eli Jones]

Like Takashi says.. you can effectively get the max() for a numeric property
(db.FloatProperty() or db.IntegerProperty()) by issuing a command like he
gave.. or a more SQL looking query like this:

result = db.GqlQuery("Select * from Employee Order By salary desc").fetch(1)
maxsalary = result[0].salary

Other built in SQL functions like Sum() aren't really doable though. (Not in
a simple way).

On Sun, Mar 14, 2010 at 10:12 PM, Takashi Matsuo
<matsuo.taka...@gmail.com>wrote:

> Hi,
>
> Perhaps you can order by salary property descending, and just get the
> first one, for getting max value.
>
> max_salaried_employee = Employee.all().order("-salary").get()
> max_salary = max_salaried_employee.salary
>
> hope this helps
>
> --
> Takashi Matsuo
> Kay's daddy
>
>
>
> On Mon, Mar 15, 2010 at 11:00 AM, Greg <g.fawc...@gmail.com> wrote:
> > On Mar 14, 3:48 am, pyrocks <kiranbe...@gmail.com> wrote:
> >> here shall we have any max() function available like in oracle to find
> >> max salaried employee.
> >
> > In a word, no. You need to store the maximum salary in the datastore,
> > and every time time a salary changes check to see if it exceeds the
> > maximum, and update it if so.
> >
> > --
> > You received this message because you are subscribed to the Google Groups
> "Google App Engine" group.
> > To post to this group, send email to google-appeng...@googlegroups.com.
> > To unsubscribe from this group, send email to
> google-appengine+unsubscr...@googlegroups.com<google-appengine%2bunsubscr...@googlegroups.com>
> .
> > For more options, visit this group at
> http://groups.google.com/group/google-appengine?hl=en.
> >
> >
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine" group.
> To post to this group, send email to google-appeng...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine+unsubscr...@googlegroups.com<google-appengine%2bunsubscr...@googlegroups.com>
> .
> For more options, visit this group at
> http://groups.google.com/group/google-appengine?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To post to this group, send email to google-appeng...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine?hl=en.