django queryset or condition code example

Example 1: and condition with or in django

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

Example 2: query with condition django

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

Example 3: or operator in django queryset

from django.db.models import Q

Contact.objects.filter(Q(last_name__icontains=request.POST['query']) | 
                               Q(first_name__icontains=request.POST['query']))

Example 4: django or

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