How can I combine two or more querysets in a Django view?

by

Concatenating the querysets into a list is the simplest approach. If the database will be hit for all querysets anyway (e.g. because the result needs to be sorted), this won’t add further cost.

from itertools import chain
result_list = list(chain(page_list, article_list, post_list))

Using itertools.chain is faster than looping each list and appending elements one by one, since itertools is implemented in C. It also consumes less memory than converting each queryset into a list before concatenating.

Now it’s possible to sort the resulting list e.g. by date (as requested in hasen j’s comment to another answer). The sorted() function conveniently accepts a generator and returns a list:

result_list = sorted(
    chain(page_list, article_list, post_list),
    key=lambda instance: instance.date_created)

If you’re using Python 2.4 or later, you can use attrgetter instead of a lambda. I remember reading about it being faster, but I didn’t see a noticeable speed difference for a million item list.

from operator import attrgetter
result_list = sorted(
    chain(page_list, article_list, post_list),
    key=attrgetter('date_created'))

More Related Contents:

  1. How to combine multiple querysets in Django?
  2. How do I do an OR filter in a Django query?
  3. How to filter empty or NULL names in a QuerySet?
  4. Custom QuerySet and Manager without breaking DRY?
  5. Why does django’s prefetch_related() only work with all() and not filter()?
  6. Select DISTINCT individual columns in django?
  7. _set in Django for a queryset
  8. Raw SQL queries in Django views
  9. django dynamically filtering with q objects
  10. How to limit queryset/the records to view in Django admin site?
  11. Django: implementing JOIN using Django ORM?
  12. Django – filtering on foreign key properties
  13. How to create a Django queryset filter comparing two date fields in the same model
  14. Django Queryset with filtering on reverse foreign key
  15. How to dynamically provide lookup field name in Django query? [duplicate]
  16. Django lazy QuerySet and pagination
  17. Django: ManyToMany filter matching on ALL items in a list
  18. Django query datetime for objects older than 5 hours
  19. Django, query filtering from model method
  20. Django: Does prefetch_related() follow reverse relationship lookup?
  21. django most efficient way to count same field values in a query
  22. Django Order By Date, but have “None” at end?
  23. Django query case-insensitive list match
  24. Django: __in query lookup doesn’t maintain the order in queryset
  25. Django queryset get exact manytomany lookup [duplicate]
  26. how to write a query to get find value in a json field in django
  27. Docker app server ip address 127.0.0.1 difference of 0.0.0.0 ip
  28. Django The ‘image’ attribute has no file associated with it
  29. Django query filter with variable column
  30. How do I set up Jupyter/IPython Notebook for Django?

Leave a Comment