On Fri, Jul 4, 2014 at 5:23 PM, Stephen J. Butler <[email protected]> wrote: > * Build a list of relevant containers first: > Container.objects.filter(item__previous__isnull=True, > item__flag=True).values_list('pk', flat=True). Then > Items.objects.filter(current=True, container__in=flagged_containers). Not a > problem as long as your query doesn't grow too large for your DB (that is, > too many containers that might be considered)
i guess Items.objects.filter(current=True, container__in=Container.objects.filter(item__previous__isnull=True, item__flag=True)) would be better, it gives the the opportunity to not get the container list in Python. ... and this is more appropriate on django-users -- Javier -- You received this message because you are subscribed to the Google Groups "Django developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/django-developers. To view this discussion on the web visit https://groups.google.com/d/msgid/django-developers/CAFkDaoROfS14GrKPb-7XbSTGxyb8g1hNBvZSFDQhSzwTEq7DOg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
