How to Perform NOT Queries in Django ORM

"The NOT operator (~) in Django is used to negate conditions specified within a query. It works with the Q object, which allows you to encapsulate complex queries using Pythonic syntax."

"To perform NOT queries in Django ORM, you need to import the Q object from django.db.models and then use the ~ operator to negate a condition. The general syntax is as follows: result = Model.objects.filter(~Q(condition))."

"In this example, the query will fetch all books where the is_out_of_stock field is not True. This effectively excludes books that are marked as 'out of stock' from the query result."

The NOT operator, represented by the tilde (~), is used in Django ORM to negate conditions in queries. It works with the Q object to create complex queries. To perform NOT queries, import the Q object and use the ~ operator to filter out records that do not meet specified criteria. For example, to exclude books marked as 'out of stock', the query would be: Book.objects.filter(~Q(is_out_of_stock=True)). This effectively retrieves all books that are in stock.

Read at Djangocentral