How do I do an OR filter in a Django query?

by

There is Q objects that allow to complex lookups. Example:

from django.db.models import Q

Item.objects.filter(Q(creator=owner) | Q(moderated=False))

More Related Contents:

  1. How can I combine two or more querysets in a Django view?
  2. How to filter empty or NULL names in a QuerySet?
  3. Custom QuerySet and Manager without breaking DRY?
  4. Why does django’s prefetch_related() only work with all() and not filter()?
  5. Select DISTINCT individual columns in django?
  6. _set in Django for a queryset
  7. Raw SQL queries in Django views
  8. How to limit queryset/the records to view in Django admin site?
  9. Django: implementing JOIN using Django ORM?
  10. Django – filtering on foreign key properties
  11. How to create a Django queryset filter comparing two date fields in the same model
  12. Django Queryset with filtering on reverse foreign key
  13. How to dynamically provide lookup field name in Django query? [duplicate]
  14. Django lazy QuerySet and pagination
  15. Django: ManyToMany filter matching on ALL items in a list
  16. Django query datetime for objects older than 5 hours
  17. Django, query filtering from model method
  18. Django: Does prefetch_related() follow reverse relationship lookup?
  19. django most efficient way to count same field values in a query
  20. Django Order By Date, but have “None” at end?
  21. Django query case-insensitive list match
  22. Django: __in query lookup doesn’t maintain the order in queryset
  23. Django queryset get exact manytomany lookup [duplicate]
  24. how to write a query to get find value in a json field in django
  25. Django: How can I protect against concurrent modification of database entries
  26. How do you run a worker with AWS Elastic Beanstalk?
  27. Django : How can I see a list of urlpatterns?
  28. How to get Django and ReactJS to work together?
  29. django : Serving static files through nginx
  30. Can a dictionary be passed to django models on create?

Leave a Comment