I think you didn't really look well anotate, because it looks like it is what you qre looking for ! Or is there something I misunderstood ?
http://docs.djangoproject.com/en/dev/ref/models/querysets/#annotate-args-kwargs "Annotates each object in the QuerySet with the provided list of aggregate values (averages, sums, etc) that have been computed over the objects that are related to the objects in the QuerySet. Each argument to annotate() is an annotation that will be added to each object in the QuerySet that is returned." On Jun 11, 12:24 am, SlafS <[email protected]> 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 <[email protected]> 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 > > [email protected] > > > On Jun 10, 5:01 pm, SlafS <[email protected]> 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
