How to use “OR” using Django’s model filter system?

by

You can use Q objects to do what you want, by bitwise OR-ing them together:

from django.db.models import Q
Publisher.objects.filter(Q(name__contains="press") | Q(country__contains="U.S.A"))

Related Contents:

  1. sql “LIKE” equivalent in django query
  2. Raw SQL queries in Django views
  3. What is the SQL ”LIKE” equivalent on Django ORM queries?
  4. LEFT JOIN Django ORM
  5. What’s the difference between select_related and prefetch_related in Django ORM?
  6. How to see the raw SQL queries Django is running?
  7. Can “list_display” in a Django ModelAdmin display attributes of ForeignKey fields?
  8. Django auto_now and auto_now_add
  9. Django values_list vs values
  10. Automatic creation date for Django model form objects
  11. How to pull a random record using Django’s ORM?
  12. In Django, how does one filter a QuerySet with dynamic field lookups?
  13. How to filter objects for count annotation in Django?
  14. Django rest framework serializing many to many field
  15. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  16. Split models.py into several files
  17. Django signals vs. overriding save method
  18. Django filter many-to-many with contains
  19. django abstract models versus regular inheritance
  20. how to import csv data into django models
  21. Get all related Django model objects
  22. Check if OneToOneField is None in Django
  23. Django Model MultipleChoice
  24. django syncdb and an updated model
  25. How can I programmatically obtain the max_length of a Django model field?
  26. Django – FileField check if None
  27. django template system, calling a function inside a model
  28. Identify the changed fields in django post_save signal
  29. In the Django admin interface, is there a way to duplicate an item?
  30. How do I restrict foreign keys choices to related objects only in django
  31. one-to-many inline select with django admin
  32. How to use UUID
  33. update django database to reflect changes in existing models
  34. How to have a Python script for a Django app that accesses models without using the manage.py shell?
  35. Django Admin nested inline
  36. Django model fields validation
  37. Django model method – create_or_update
  38. How to create Password Field in Model Django
  39. Generate unique id in django from a model field
  40. How to set another Inline title in Django Admin?
  41. Adding Custom Django Model Validation
  42. Setting default value for Foreign Key attribute in Django
  43. Difference between ‘related_name’ and ‘related_query_name’ attributes in Django?
  44. Get a list of all installed applications in Django and their attributes
  45. Writing test cases for django models
  46. How to change Django Admin Custom list field label?
  47. Download a remote image and save it to a Django model
  48. Is there a datetime ± infinity?
  49. Django : Table doesn’t exist
  50. django post_save signals on update

Leave a Comment