google-appengine  

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

Takashi Matsuo
Sun, 14 Mar 2010 19:13:11 -0700

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