Yes, I'm aware of the background of the problem but i was wondering if
I can somehow "workaround" it.
Thanks for Your help
On 10 Cze, 23:34, Dan Harris <dih0...@gmail.com> wrote:
> The problem is the GROUP BY you are looking to get. The problem with
> doing a group by you don't get the whole object which is what the
> Django queryset is trying to return:
>
> res = queryset.annotate(Count("name"))
>
> This will give you a result set that you want and you can iterate over
> like:
>
> {% for r in res %}
> {{ r.name }} - {{ r.name__count}}
> {% endfor %}
>
> however there may be duplicated {{ r.name }}
>
> Dan Harris
> dih0...@gmail.com
>
> On Jun 10, 5:24 pm, SlafS <slaf...@gmail.com> wrote:
>
> > Thanks.
>
> > I've already tried that but this isn't quite what i'm looking for. As
> > u wrote this returns a list, but I would like to obtain my calculated
> > property when I'm iterating over this. Like so (let's say the result
> > is in res variable) :
>
> > {% for r in res %}
> > {{r.xxx}} - {{r.name__count}}
> > {% endfor %}
>
> > I'm starting to think that there's no such nice way to acheive that :/
>
> > On 10 Cze, 23:06, Dan Harris <dih0...@gmail.com> wrote:
>
> > > Here is an example:
>
> > > # In models.py
> > > class TestModel(models.Model):
> > > name = models.CharField()
>
> > > # Get a listing of unique names and their counts
> > > # In some view
> > > from django.db.models import Count
>
> > > TestModel.objects.values("name").annotate(Count("name"))
>
> > > This will return a list of the form:
>
> > > [{'name__count': 2, 'name': u'aaaa'}, {'name__count': 1, 'name':
> > > u'bbbbbbb'}]
>
> > > Hope this helps!
>
> > > Dan Harris
> > > dih0...@gmail.com
>
> > > On Jun 10, 5:01 pm, SlafS <slaf...@gmail.com> wrote:
>
> > > > Hi there!
> > > > I have a question. If i have a model with some fields (let's say all
> > > > CharFields named aaa,bbb,ccc etc. and some calculated properties named
> > > > xxx and zzz) how can I obtain something similar to
>
> > > > "SELECT aaa, count(aaa) FROM my_model_table GROUP BY aaa;"
> > > > i.e. a list of - lazy loaded - objects with distinct aaa values and an
> > > > extra column which indicates how many entries of a specific aaa are in
> > > > the table.
>
> > > > I would like to acheive that with QuerySet and annotate so that I can
> > > > get a list of objects to use their other properties (xxx or zzz) e.g.
> > > > in my template
>
> > > > Regards
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
