Chaining multiple filter() in Django, is this a bug?

by

The way I understand it is that they are subtly different by design (and I am certainly open for correction): filter(A, B) will first filter according to A and then subfilter according to B, while filter(A).filter(B) will return a row that matches A ‘and’ a potentially different row that matches B.

Look at the example here:

https://docs.djangoproject.com/en/dev/topics/db/queries/#spanning-multi-valued-relationships

particularly:

Everything inside a single filter() call is applied simultaneously to filter out items matching all those requirements. Successive filter() calls further restrict the set of objects

…

In this second example (filter(A).filter(B)), the first filter restricted the queryset to (A). The second filter restricted the set of blogs further to those that are also (B). The entries select by the second filter may or may not be the same as the entries in the first filter.`

More Related Contents:

  1. Issue with ManyToMany Relationships not updating immediately after save
  2. How to view corresponding SQL query of the Django ORM’s queryset?
  3. Why does django’s prefetch_related() only work with all() and not filter()?
  4. Select DISTINCT individual columns in django?
  5. How to rename items in values() in Django?
  6. django-orm case-insensitive order by
  7. Django: implementing JOIN using Django ORM?
  8. List field in model?
  9. How to query Case-insensitive data in Django ORM?
  10. Default image for ImageField in Django’s ORM
  11. Django ORM: Group by and Max
  12. Django: ManyToMany filter matching on ALL items in a list
  13. How to use custom manager with related objects?
  14. Django queryset get exact manytomany lookup [duplicate]
  15. Creating Partial Indexes with Django 1.7
  16. Saving Many To Many data via a modelform in Django
  17. Get model’s fields in Django
  18. Can django’s auth_user.username be varchar(75)? How could that be done?
  19. Manager isn’t available; User has been swapped for ‘pet.Person’
  20. How to get the list of the authenticated users?
  21. Django: How do I add arbitrary html attributes to input fields on a form?
  22. creating my own context processor in django
  23. Get list item dynamically in django templates
  24. How to cURL an Authenticated Django App?
  25. Example of Django Class-Based DeleteView
  26. Accelerate bulk insert using Django’s ORM?
  27. Django: permission denied when trying to access database after restore (migration)
  28. Setting default value for Foreign Key attribute
  29. ModelForm with OneToOneField in Django
  30. How to simplify migrations in Django 1.7?

Leave a Comment