How to perform OR condition in django queryset

Question

I want to write a Django query equivalent to this SQL query   SELECT   from user where income  gt   5000 or income is NULL    How to construct the Django queryset filter   User objects filter income  gte 5000  income 0    This doesn t work  because it ANDs the filters  I want to OR the filters to get union of individual querysets

User · Accepted Answer

from django db models import Q User objects filter Q income  gte 5000    Q income  isnull True     via Documentation

User · Answer

Just adding this for multiple filters attaching to Q object  if someone might be looking to it  If a Q object is provided  it must precede the definition of any keyword arguments  Otherwise its an invalid query  You should be careful when doing it  an example would be from django db models import Q User objects filter Q income  gte 5000    Q income  isnull True  category  income    Here the OR condition and a filter with category of income is taken into account

User · Answer

Both options are already mentioned in the existing answers   from django db models import Q q1   User objects filter Q income  gte 5000    Q income  isnull True     and  q2   User objects filter income  gte 5000    User objects filter income  isnull True    However  there seems to be some confusion regarding which one is to prefer   The point is that they are identical on the SQL level  so feel free to pick whichever you like   The Django ORM Cookbook talks in some detail about this  here is the relevant part     queryset   User objects filter          first name  startswith  R          User objects filter      last name  startswith  D      leads to  In  5   str queryset query  Out 5    SELECT  auth user   id    auth user   password    auth user   last login    auth user   is superuser    auth user   username    auth user   first name    auth user   last name    auth user   email    auth user   is staff    auth user   is active    auth user   date joined  FROM  auth user  WHERE   auth user   first name   text LIKE R  OR  auth user   last name   text LIKE D      and  qs   User objects filter Q first name  startswith  R     Q last name  startswith  D      leads to  In  9   str qs query  Out 9    SELECT  auth user   id    auth user   password    auth user   last login     auth user   is superuser    auth user   username    auth user   first name      auth user   last name    auth user   email    auth user   is staff      auth user   is active    auth user   date joined  FROM  auth user    WHERE   auth user   first name   text LIKE R  OR  auth user   last name   text LIKE D      source  django-orm-cookbook

User · Answer

Because QuerySets implement the Python   or   operator      or union  it just works  As you d expect  the   binary operator returns a QuerySet so order by     distinct    and other queryset filters can be tacked on to the end   combined queryset   User objects filter income  gte 5000    User objects filter income  isnull True  ordered queryset   combined queryset order by  -income     Update 2019-06-20  This is now fully documented in the Django 2 1 QuerySet API reference  More historic discussion can be found in DjangoProject ticket  21333

[python] How to perform OR condition in django queryset?

Examples related to python

Examples related to sql

Examples related to django

Examples related to django-queryset

Examples related to django-orm