Additionally, you will understand how to use the ‘not in’<\/strong> in the view and template of your Django project. Finally, you will learn about the filter method exclude()<\/strong> in Django.<\/p>\n In this section, we are going to discuss the “not in”<\/strong> filter in Django. <\/p>\n In Python Django, the “not in”<\/strong> filter or we can say that the operator acts in the exact opposite way as the “in”<\/strong> filter. It tests for the presence of a specified value within a sequence, but the return values are the reverse of the “in”<\/strong> filter.<\/p>\n When the “not in”<\/strong> filter is used in the condition with the value present inside<\/strong> the sequence, the statement returns the boolean result False<\/strong>. Whereas when the value is not present inside<\/strong> the sequence, the statement returns the boolean result True<\/strong>.<\/p>\n From the sequence we mean, it can be lists, tuples, arrays, strings, dictionaries, etc.<\/p>\n Read: Python Django vs ReactJS<\/a><\/p>\n In this section, we’ll learn to use the Django filter or we can say the operator “not in” in the Python list. And, in Django, the “not in”<\/strong> operators are commonly used in the if tags<\/strong>. <\/p>\n In Django, there are two ways to use the “not in”<\/strong> filter in the list:<\/p>\n So, let’s understand each way using a few examples. But first set the project environment by following the below steps:<\/p>\n Open your command prompt and create a virtual environment named ‘env’<\/strong> using the below code.<\/p>\n Activate the environment.<\/p>\n Install the latest version of Django.<\/p>\n Create a Django project ‘django_filter’<\/strong> using the below command.<\/p>\n Now create a Django app ‘django_notin’<\/strong> using the below command.<\/p>\n Then open the project in your preferred IDE such as Visual Studio Code<\/strong> and set the project and app-level URL patterns.<\/p>\n So open the urls.py<\/strong> file of your Django project ‘django_filter’<\/strong> and add the following lines of code.<\/p>\n Also set the URL at the app level, so create a new file urls.py<\/strong> in your Django app ‘django_notin’<\/strong> and in that file add the following lines of code.<\/p>\n Now create a view named ‘filter_app’<\/strong> that contains a list of blog names and pass the blogs to the template filter_app.html<\/strong>. <\/p>\n So for the demonstration of the “not-in”<\/strong> operator which acts as a filter, here you will learn how to filter the list of data using the “not-in<\/strong>.<\/p>\n Open the views.py<\/strong> file of your Django app ‘django_notin’<\/strong> and add the following lines of code.<\/p>\n In the above code define the view named ‘filter_app’<\/strong> that contains a list of blogs.<\/p>\n Also create the template file, that creates a new folder template in your Django app ‘django_notin’<\/strong>. In that folder create a new file filter_app.html<\/strong> and add the following lines of code.<\/p>\n In the filter_app.html<\/strong> file, we are just using the variable to get the result. In the end, we will get the following output.<\/p>\n So run the Django server by running the below command in your terminal.<\/p>\n After running the server go to the URL http:\/\/127.0.0.1:8000\/<\/strong> and you see the output as shown below.<\/p>\n As you can see the result is a False<\/strong> value which means the string ‘MySql’<\/strong> exists in the blogs<\/strong> list. Here you can consider how ‘not in’ <\/strong>checks for the not existence of the specific value in the list and returns the boolean.<\/p>\n This means it filtres the value in the list, if that value exists in the list it returns False<\/strong> otherwise returns True<\/strong>.<\/p>\n Let’s take one more example and this time check with the list of integer values.<\/p>\n Add the following line of code in your view filter_app<\/strong> as shown below<\/p>\n In the above code, line 4 defines the list of integer values and stores them in the order<\/strong> variable. Then in line 5 check if the value 99<\/strong> is not present in the order list and if the value is not present then it returns True<\/strong>, otherwise False<\/strong>.<\/p>\n Also, modify the template filter_app.html<\/strong> file and add the following lines of code:<\/p>\n We simply use the variable to get the result in the filter_app.html<\/strong> file. Finally, we’ll get the following result.<\/p>\n Now again open the URL http:\/\/127.0.0.1:8000\/<\/strong> and you see the result as shown below.<\/p>\n From the above output result equal True<\/strong> means the value 99<\/strong> doesn’t present the order list.<\/p>\n In the above topics you used the ‘not in’<\/strong> operator as a filter in your view function but you can also use it in the template with the help of the Django template tag.<\/p>\n Let’s see an example where you create a list of programming languages in your view named filter_app<\/strong> by adding the following code in your views.py<\/strong> file.<\/p>\n The above code passes the list of languages<\/strong> and the variable test<\/strong> that contains a single value in the list to the template ‘filter_app.html’<\/strong>.<\/p>\n Then add the following lines of code in the template filter_app.html<\/strong> file:<\/p>\n Here, we add the “is not” <\/strong>operator in the template using the {%if%}<\/strong> tag at line 13. The tag evaluates the variables, if the condition is \u201ctrue\u201d<\/strong> the block {{test}} is not present in language list {{languages}}<\/strong> is executed.<\/p>\n Otherwise, in case of a “false”<\/strong> value, the {% else %}<\/strong> part of the block {{test}} is present in the language list {{languages}}<\/strong> is executed.<\/p>\n In the above, you can see that the block {{test}} is not present in the language list {{languages}}<\/strong> is executed because the [‘C Sharp’] is not present in the list of languages.<\/p>\n Which means ‘not in’<\/strong> within the {%if%}<\/strong> returns True<\/strong> value.<\/p>\n Take one more example and add the following lines of code to your views.py<\/strong> file<\/p>\n In the above code with the view ‘filter_app’<\/strong>, the list of vowels and test list\u00a0is defined and then these lists are passed as context to the filter_app.html<\/strong> page.<\/p>\n Also add the following code in the filter_app.html<\/strong> file:<\/p>\n Again go to the URL http:\/\/127.0.0.1:8000\/<\/strong> and see the output as shown below.<\/p>\n Read: Python Django random number<\/a><\/p>\n In this section, you’ll learn how to use the alternate method to the “not in”<\/strong> filter in Django models. In Django, “not in”<\/strong> means selecting the objects that contain the values that are not there in the given iterable.<\/p>\n Basically, In Django, we don’t have any filter with the name “not in”. So, to work in the same way as the “not in” filter works. There is an exclude() method with the “in”<\/strong> lookup in Django.<\/p>\n The exclude method returns the objects that do not match the given parameters.<\/p>\n The syntax is given below:<\/strong><\/p>\n Let’s see different examples to clearly understand the concept of “exclude()”<\/strong>.<\/p>\n Firstly, create the model with the name Employee<\/strong> in the model.py<\/strong> file of the app and add the following line of code.<\/p>\n Then, register the model. For this, add the following code in the admin.py<\/strong> file of the Django app ‘django_notin’<\/strong>.<\/p>\n Then open the Admin panel and add some of the records related to the Employee<\/strong> as shown in the below picture. If you want to know how to create an admin user, then refer to this tutorial Python admin<\/a><\/p>\n After adding records you see the page as shown below.<\/p>\n After that open the Python shell by running the below command in your terminal.<\/p>\n In this example, you’ll use the exclude<\/strong> method with the “in”<\/strong> field lookup. Here exclude some specific ages from the Age field.<\/p>\n In the above code, simply use the exclude method with the “in”<\/strong> field lookup to select the objects which do not have age<\/strong> values like 28 and 26<\/strong>. It will return all two objects that do not have these age values.<\/p>\n In this Python Django Tutorial, you have learned “Python filter not in Django<\/strong>” and also learned how to use the “not in” in the view and the template side.<\/p>\n Also, take a look at some more Django tutorials.<\/p>\nFilter not in Django<\/h2>\n
Django filter not in the list<\/h3>\n
\n
python -m venv env<\/code><\/pre>\nenv\\Scripts\\activate<\/code><\/pre>\npip install django<\/code><\/pre>\ndjango-admin startproject django_filter .<\/code><\/pre>\npython manage.py startapp django_notin<\/code><\/pre>\n![\"Filter](\"https:\/\/pythonguides.com\/wp-content\/uploads\/2023\/09\/Filter-not-in-Django-Project-Setup-1024x620.jpg\" "\\"Filter")
<\/figure>\n<\/div>\nfrom django.contrib import admin\nfrom django.urls import path, include\n\nurlpatterns = [\n path('admin\/', admin.site.urls),\n path('', include('django_notin.urls'))\n]<\/code><\/pre>\n![\"Filter](\"https:\/\/pythonguides.com\/wp-content\/uploads\/2023\/09\/Filter-not-in-Django-Project-URL-Setup.jpg\" "\\"Filter")
<\/figure>\n<\/div>\nfrom django.urls import path\r\nfrom .views import *\r\n\r\nurlpatterns = [\r\n path('', filter_app, name='filter_app')\r\n]<\/code><\/pre>\n![\"Filter](\"https:\/\/pythonguides.com\/wp-content\/uploads\/2023\/09\/Filter-not-in-Django-App-URL-Setup.jpg\" "\\"Filter")
<\/figure>\n<\/div>\nDjango filter not in list using views<\/h3>\n
from django.shortcuts import render\n\n# Create your views here.\n\ndef filter_app(request):\n blogs = [\"Python\", \"MariaDB\", \"MySql\", \"Machine Learning\", \"PostgreSql\"] \n result = (\"MySql\" not in blogs )\n return render(request, 'filter_app.html', {'result':result})<\/code><\/pre>\n![\"Filter](\"https:\/\/pythonguides.com\/wp-content\/uploads\/2023\/09\/Filter-not-in-Django-View-1024x341.jpg\" "\\"Filter")
<\/figure>\n<\/div>\n\n
<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n <meta charset=\"UTF-8\">\n <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n <title>PythonGuides<\/title>\n<\/head>\n\n<body>\n <font color=\"green\">\n Check MySql present in Blog or not (while using \"not in\" operator)\n <br>\n <br>\n <\/font>\n <font color=\"red\">\n <b> Result : <\/b>{{result}}\n <\/font>\n<\/body <\/html><\/code><\/pre>\n![\"Django](\"https:\/\/pythonguides.com\/wp-content\/uploads\/2023\/09\/Django-filter-not-in-list-using-views-tempalate-1024x489.jpg\" "\\"Django")
<\/figure>\n<\/div>\npython manage.py runserver<\/code><\/pre>\n![\"django](\"https:\/\/pythonguides.com\/wp-content\/uploads\/2021\/08\/django-filter-not-in-list-using-views-1024x238.png\" "\\"django")
<\/figure>\n<\/div>\nfrom django.shortcuts import render\n\n# Create your views here.\n\ndef filter_app(request):\n order = [100, 101, 102, 103, 104, 105] \n result = (99 not in order)\n return render(request, 'filter_app.html', {'result':result})<\/code><\/pre>\n![\"Django](\"https:\/\/pythonguides.com\/wp-content\/uploads\/2023\/09\/Django-filter-not-in-list-using-template-view-1024x409.jpg\" "\\"Django")
<\/figure>\n<\/div>\n<!DOCTYPE html>\n<html lang=\"en\">\n\n<head>\n <meta charset=\"UTF-8\">\n <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n <title>PythonGuides<\/title>\n<\/head>\n\n<body>\n <font color=\"green\">\n Check Order Number 99 present in Order or not (while using \"not in\" operator)\n <br>\n <br>\n <\/font>\n <font color=\"red\">\n <b> Result : <\/b>{{result}}\n <\/font>\n<\/body <\/html><\/code><\/pre>\n![\"Django](\"https:\/\/pythonguides.com\/wp-content\/uploads\/2023\/09\/Django-filter-not-in-list-using-template-1024x433.jpg\" "\\"Django")
<\/figure>\n<\/div>\n![\"python](\"https:\/\/pythonguides.com\/wp-content\/uploads\/2021\/08\/python-django-filter-not-in-list-using-views-1024x209.png\" "\\"python")
<\/figure>\n<\/div>\nDjango filter not in list using a template tag<\/h3>\n
from django.shortcuts import render\n\n# Create your views here.\n\ndef filter_app(request):\n languages = [\"C\", \"C++\", \"Python\", \"Java\"]\n test = [\"C Sharp\"]\n return render(request, 'filter_app.html', {'languages': languages, 'test':test})<\/code><\/pre>\n![\"Django](\"https:\/\/pythonguides.com\/wp-content\/uploads\/2023\/09\/Django-filter-not-in-list-using-a-template-tag-view-1024x333.jpg\" "\\"Django")
<\/figure>\n<\/div>\n<!DOCTYPE html>\n<html lang=\"en\">\n\n<head>\n <meta charset=\"UTF-8\">\n <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n <title>PythonGuides<\/title>\n<\/head>\n\n<body>\n <p>\n {% if test is not languages %}\n {{test}} is not present in language list {{languages}}\n {% else %}\n {{test}} is present in language list {{languages}}\n {% endif %}\n <\/p>\n<\/body \n<\/html><\/code><\/pre>\n![\"Django](\"https:\/\/pythonguides.com\/wp-content\/uploads\/2023\/09\/Django-filter-not-in-list-using-a-template-tag-1024x500.jpg\" "\\"Django")
<\/figure>\n<\/div>\n![\"django](\"https:\/\/pythonguides.com\/wp-content\/uploads\/2021\/08\/django-filter-not-in-list-using-template.png\" "\\"django")
<\/figure>\n<\/div>\nfrom django.shortcuts import render\n\n# Create your views here.\n\ndef filter_app(request):\n vowels = [\"A\", \"E\", \"I\", \"O\", \"U\"]\n test = [\"A\"]\n return render(request, 'filter_app.html', {'vowels': vowels, 'test':test})<\/code><\/pre>\n![\"Django](\"https:\/\/pythonguides.com\/wp-content\/uploads\/2023\/09\/Django-filter-not-in-list-using-a-template-view-1024x418.jpg\" "\\"Django")
<\/figure>\n<\/div>\n<!DOCTYPE html>\n<html lang=\"en\">\n\n<head>\n <meta charset=\"UTF-8\">\n <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n <title>PythonGuides<\/title>\n<\/head>\n\n<body>\n <p>\n {% if test is not vowels %}\n {{test}} is one of the five friend\n {% else %}\n {{test}} is not in the list of five friend\n {% endif %}\n <\/p>\n<\/body \n<\/html><\/code><\/pre>\n![\"Django](\"https:\/\/pythonguides.com\/wp-content\/uploads\/2023\/09\/Django-filter-not-in-list-using-a-template-1024x467.jpg\" "\\"Django")
<\/figure>\n<\/div>\n![\"python](\"https:\/\/pythonguides.com\/wp-content\/uploads\/2021\/08\/python-django-filter-not-in-list-uisng-template.png\" "\\"python")
<\/figure>\n<\/div>\nDjango model filter not in<\/h3>\n
queryset = model_name.objects.exclude(parameter__in=[])<\/code><\/pre>\nfrom django.db import models\r\n\r\nclass Employee(models.Model):\r\n first_name = models.CharField(max_length=200)\r\n last_name = models.CharField(max_length=200)\r\n position = models.CharField(max_length=100)\r\n age = models.PositiveIntegerField()\r\n \r\n def __str__(self): \r\n return \"%s %s %s %s\" % (self.first_name, self.last_name, self.position, self.age) <\/code><\/pre>\n![\"Django](\"https:\/\/pythonguides.com\/wp-content\/uploads\/2023\/09\/Django-model-employee-filter-not-in-1024x372.jpg\" "\\"Django")
<\/figure>\n<\/div>\nfrom django.contrib import admin\r\nfrom .models import Employee\r\n\r\n\r\nclass AdminEmployee(admin.ModelAdmin):\r\n list_display = ['first_name', 'last_name', 'position', 'age']\r\n\r\nadmin.site.register(Employee, AdminEmployee)<\/code><\/pre>\n![\"Django](\"https:\/\/pythonguides.com\/wp-content\/uploads\/2023\/09\/Django-register-model-employee-filter-not-in-1024x502.jpg\" "\\"Django")
<\/figure>\n<\/div>\n![\"Django](\"https:\/\/pythonguides.com\/wp-content\/uploads\/2023\/09\/Django-register-admin-employee-filter-not-in-1024x473.jpg\" "\\"Django")
<\/figure>\n<\/div>\n![\"django](\"https:\/\/pythonguides.com\/wp-content\/uploads\/2022\/02\/django-model-filter-not-in-1024x207.png\" "\\"django")
python manage.py shell<\/code><\/pre>\n# Import<\/strong>\n\nfrom django_notin.models import Employee\n\n# QuerySet<\/strong>\n\nqueryset = Employee.objects.exclude(Age__in=[28, 26])\nprint(queryset)<\/code><\/pre>\n![\"Django](\"https:\/\/pythonguides.com\/wp-content\/uploads\/2023\/09\/Django-model-filter-not-in-1024x244.jpg\" "\\"Django")
<\/figure>\n<\/div>\nConclusion<\/h2>\n