How to perform OR condition in django queryset?

by 
from django.db.models import Q
User.objects.filter(Q(income__gte=5000) | Q(income__isnull=True))

via Documentation

More Related Contents:

  1. Django Aggregation: Summation of Multiplication of two fields
  2. Getting the SQL from a Django QuerySet [duplicate]
  3. Django orm get latest for each group
  4. LEFT JOIN Django ORM
  5. How to delete a record in Django models?
  6. How do I filter query objects by date range in Django?
  7. Convert Django Model object to dict with all of the fields intact
  8. Django filter queryset __in for *every* item in list
  9. How can I filter a date of a DateTimeField in Django?
  10. Optimizing database queries in Django REST framework
  11. How to create an object for a Django model with a many to many field?
  12. Django: Adding “NULLS LAST” to query
  13. Serializing Foreign Key objects in Django
  14. Django Blob Model Field
  15. many-to-many in list display django
  16. How to see the raw SQL queries Django is running?
  17. How to log all sql queries in Django?
  18. Direct assignment to the forward side of a many-to-many set is prohibited. Use emails_for_help.set() instead
  19. How to combine multiple querysets in Django?
  20. aggregate() vs annotate() in Django
  21. Count() vs len() on a Django QuerySet
  22. What is an efficient way of inserting thousands of records into an SQLite table using Django?
  23. Simple Subquery with OuterRef
  24. Using .aggregate() on a value introduced using .extra(select={…}) in a Django Query?
  25. How to do many-to-many Django query to find book with 2 given authors?
  26. django filter on the basis of text length
  27. What is the default order of a list returned from a Django filter call?
  28. Django filter JSONField list of dicts
  29. How to annotate Count with a condition in a Django queryset
  30. Can a dictionary be passed to django models on create?

Leave a Comment