Re: how to query max count

2014-10-20 Thread dk
ok that max(the_max) didn't work every time it provide a different result (looking into this) just updating the post in case someone was looking into this as a solution. On Thursday, October 16, 2014 12:21:33 AM UTC-5, dk wrote: > > looks like it works like this > > the_max = Choice.objects.fil

Re: how to query max count

2014-10-15 Thread dk
looks like it works like this the_max = Choice.objects.filter(date=date) print max(the_max) On Monday, October 13, 2014 6:14:28 PM UTC-5, dk wrote: > I need to learn how to use aggregation in django, I was thinking on > filter by date, > and then loop the query and make a dictionary with

Re: how to query max count

2014-10-13 Thread dk
I need to learn how to use aggregation in django, I was thinking on filter by date, and then loop the query and make a dictionary with the name, and += value and then use the python max function. On Monday, October 13, 2014 3:12:39 AM UTC-5, JirkaV wrote: > Hi there, > > you could do it m

Re: how to query max count

2014-10-13 Thread Jirka Vejrazka
Hi there, you could do it manually by counting occurrences or you could take a look at aggregation functions here: https://docs.djangoproject.com/en/1.7/topics/db/aggregation/ Do as it suits your use case. HTH Jirka On 13 October 2014 06:30, dk wrote: > I am storing the information

how to query max count

2014-10-12 Thread dk
I am storing the information in the database like this. class Choice(models.Model): restaurant = models.ForeignKey(Restaurant) person = models.ForeignKey(Person) date = models.DateField("time published") time = models.TimeField("date published") that way I can get the person and