difference between filter with multiple arguments and chain filter in django

by

As you can see in the generated SQL statements the difference is not the “OR” as some may suspect. It is how the WHERE and JOIN is placed.

Example1 (same joined table): from https://docs.djangoproject.com/en/dev/topics/db/queries/#spanning-multi-valued-relationships

Blog.objects.filter(
       entry__headline__contains="Lennon", 
       entry__pub_date__year=2008)

This will give you all the Blogs that have one entry with both (entry__headline__contains="Lennon") AND (entry__pub_date__year=2008), which is what you would expect from this query.

Result:

Blog with {entry.headline: 'Life of Lennon', entry.pub_date: '2008'}

Example 2 (chained)

Blog.objects.filter(
       entry__headline__contains="Lennon"
           ).filter(
       entry__pub_date__year=2008)

This will cover all the results from Example 1, but it will generate slightly more result. Because it first filters all the blogs with (entry__headline__contains="Lennon") and then from the result filters (entry__pub_date__year=2008).

The difference is that it will also give you results like:

A single Blog with multiple entries 

{entry.headline: '**Lennon**', entry.pub_date: 2000}, 
{entry.headline: 'Bill', entry.pub_date: **2008**}

When the first filter was evaluated the book is included because of the first entry (even though it has other entries that don’t match). When the second filter is evaluated the book is included because of the second entry.

One table: But if the query doesn’t involve joined tables like the example from Yuji and DTing. The result is same.

More Related Contents:

  1. How to query as GROUP BY in django?
  2. How do I filter query objects by date range in Django?
  3. Convert Django Model object to dict with all of the fields intact
  4. Django auto_now and auto_now_add
  5. Programmatically saving image to Django ImageField
  6. Django FileField with upload_to determined at runtime
  7. how to import csv data into django models
  8. In Django, how does one filter a QuerySet with dynamic field lookups?
  9. How do I clone a Django model instance object and save it to the database?
  10. Django Aggregation: Summation of Multiplication of two fields
  11. How to limit the maximum value of a numeric field in a Django model?
  12. How to get two random records with Django
  13. What is the most efficient way to store a list in the Django models?
  14. multiple databases and multiple models in django
  15. Django: Display Choice Value
  16. Django: Why do some model fields clash with each other?
  17. Using a Django custom model method property in order_by()
  18. Create Django model or update if exists
  19. Split models.py into several files
  20. Django DateField default options
  21. Django Admin nested inline
  22. How do I create a slug in Django?
  23. How to override the default value of a Model Field from an Abstract Base Class
  24. How can I find the union of two Django querysets?
  25. Count number of records by date in Django
  26. Django override save for model only in some cases?
  27. How can I set two primary key fields for my models in Django?
  28. Django ModelForm to have a hidden input
  29. How to delete a record in Django models?
  30. Django cannot import name x [duplicate]

Leave a Comment