Articles → DJANGO → Different Functions Of Queryset In Django

Different Functions Of Queryset In Django

In this article, we will discuss about different functions of queryset.

What Is Queryset?

Queryset allows you to get data from database.

Functions

In this article, we will discuss about following functions

Filter
Update
Exclude

For this we will take the get_list example which we have worked in previous article

Picture showing the view populated using the get_list method

Click to Enlarge

Filter

Filter function allows you to filter records based on certain criteria. Consider the following example

def get_list(request):
    template_name = "get_list.html"
    queryset = MyNewScreen.objects.all()
    queryset = queryset.filter(name="test123")
    print(queryset.count())
    context = {"list": queryset}
    return render(request, template_name, context)

Picture showing the list of records after the filter is applied on it

Click to Enlarge

Update

Update method allows you to update data.

def get_list(request):
    template_name = "get_list.html"
    queryset = MyNewScreen.objects.all()
    queryset.update(name="test567")
    print(queryset.count())
    context = {"list": queryset}
    return render(request, template_name, context)

Here, we are updating all the records. Here is the final list

Picture showing the list of records once the data is updated

Click to Enlarge

Exclude

This method allows to exclude the record from the list

def get_list(request):
    template_name = "get_list.html"
    queryset = MyNewScreen.objects.all()
    queryset = queryset.exclude(name="test44")
    print(queryset.count())
    context = {"list": queryset}
    return render(request, template_name, context)

Picture showing the list of records after the execution of exclude function

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Monday, January 13, 2020

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**