Exclude one or multiple objects from Django Queryset Example

Hi Dev,

This simple article demonstrates how to exclude one or multiple objects from Django QuerySet. We'll walk through using Django's powerful exclude() method to filter out specific data. This method is especially useful when you want to get all records except those matching certain conditions.

Django's exclude() method filters out the objects that match the specified lookup conditions and returns a new QuerySet with the rest of the results.

You can apply this in Django 3 and above easily. Let’s go step-by-step with real-world examples.

We need a model first. Open the models.py and define an Employee model:

from django.db import models

# Create your models here.

class Employee(models.Model):
firstname = models.CharField(max\_length=255)
lastname = models.CharField(max\_length=255) 

Django Admin Interface:

from django.shortcuts import render
from django.http import HttpResponse
from core.models import Employee

def exclude(request):
employees = Employee.objects.exclude(firstname="Vishal").values()
print(employees)
return HttpResponse(employees) 

\[
{
'id': 1,
'firstname': 'Mehul',
'lastname': 'Bagda'
}
] 

Use __in with the exclude() method to skip multiple entries.

from django.shortcuts import render
from django.http import HttpResponse
from core.models import Employee

def exclude(request):
excludes = \['Mehul', 'Bhavesh']
employees = Employee.objects.exclude(firstname\_\_in=excludes).values()
print(employees)
return HttpResponse(employees) 

\[
{
'id': 2,
'firstname': 'Mehul',
'lastname': 'Bagda'
}
] 

I Hope It will help you....