How can I find the union of two Django querysets?

by

This works and looks a bit cleaner:

records = query1 | query2

If you don’t want duplicates, then you will need to append .distinct():

records = (query1 | query2).distinct()

More Related Contents:

  1. Django dynamic model fields
  2. Django set default form values
  3. What’s the difference between select_related and prefetch_related in Django ORM?
  4. Can “list_display” in a Django ModelAdmin display attributes of ForeignKey fields?
  5. Django – No such table: main.auth_user__old
  6. How to create an object for a Django model with a many to many field?
  7. django abstract models versus regular inheritance
  8. Django Unique Together (with foreign keys)
  9. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  10. Django : Table doesn’t exist
  11. Get all related Django model objects
  12. Django Rest Framework and JSONField
  13. How to filter objects for count annotation in Django?
  14. How do I separate my models out in django?
  15. Writing a __init__ function to be used in django model
  16. Easiest way to rename a model using Django/South?
  17. Customize/remove Django select box blank option
  18. Duplicating model instances and their related objects in Django / Algorithm for recusrively duplicating an object
  19. Good ways to sort a queryset? – Django
  20. Resize fields in Django Admin
  21. Django DoesNotExist
  22. Identify the changed fields in django post_save signal
  23. Django 2.1.3 Error: __init__() takes 1 positional argument but 2 were given
  24. python_2_unicode_compatible error
  25. Django foreign key relation in template
  26. Django get_profile() method not working on extended User model
  27. How to store a dictionary on a Django Model?
  28. How to properly use the “choices” field option in Django
  29. update django database to reflect changes in existing models
  30. Django admin – inline inlines (or, three model editing at once)

Leave a Comment