Wait, whhhhat... o.O I'l try that now, thx.
On Wed, Jan 19, 2011 at 2:50 PM, Tom Evans <tevans...@googlemail.com> wrote:
> On Wed, Jan 19, 2011 at 11:26 AM, [CPR]-AL.exe <cpr.al....@gmail.com>
> wrote:
> > Hmm, yeah, but that still iterates over the objects and filters out
> > them by count on the application server, not on the database one :(
> >
> > I'm bypassing it already in my running project, but I try to avoid
> > using raw sql as longer as it is possible. So, the question, actually
> > remains open.
> >
> > It should go something like [pseudo-code]:
> >
> >
> Book.objects.values('tablefield').annotate(Count('tablefield')).filter('tablefield__count__gte
> > = 1)
> >
> > But, of course, that wouldn't work, because annotate's return value is
> > not a queryset :(
> >
>
> Er, says who?
>
> >>>
> Organization.objects.annotate(num_grps=Count('usergroup')).filter(num_grps__gt=2).values_list('id',
> flat=True)
> [6L, 36L, 19L, 20L, 24L, 32L, 33L, 35L]
>
> Cheers
>
> Tom
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To post to this group, send email to django-users@googlegroups.com.
> To unsubscribe from this group, send email to
> django-users+unsubscr...@googlegroups.com<django-users%2bunsubscr...@googlegroups.com>
> .
> For more options, visit this group at
> http://groups.google.com/group/django-users?hl=en.
>
>
--
Sincerely yours, Alexey.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@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.
