I want to gain and OR operation in my exclude statement.
Like:
Select all those records where name is NOT Mason and Status is NOT Unactive
Select all those records where name is NOT Mason and Status is active
Users.objects.exclude(name="Mason", active=False)
But this is not an OR operation but AND. How to get OR operation.
In order to use exclude with OR opration. you have to use exclude twice.
Entry.objects.exclude(pub_date__gt=datetime.date(2005, 1, 3)).exclude(headline='Hello')
User.objects.exclude(name="Mason").exclude(active=False)
Read about complex lookups with Q objects doc. For your case:
from django.db.models import Q
q1 = Q(name="Mason")
q2 = Q(active=False)
Users.objects.exclude( q1 | q2 )
Or, more closed tou your SQL
#where name is NOT Mason and Status is NOT Unactive
Users.objects.filter( ~q1 & ~q2 )
#where name is NOT Mason and Status is active
q2 = Q(active=True)
Users.objects.filter( ~q1 & q2 )
