exclude(**kwargs)
Returns a new QuerySet
containing objects that do not match the given lookup parameters.
The lookup parameters (**kwargs
) should be in the format described in Field lookups below. Multiple parameters are joined via AND
in the underlying SQL statement, and the whole thing is enclosed in a NOT()
.
This example excludes all entries whose pub_date
is later than 2005-1-3 AND whose headline
is “Hello”:
Entry.objects.exclude(pub_date__gt=datetime.date(2005, 1, 3), headline='Hello')
In SQL terms, that evaluates to:
SELECT ... WHERE NOT (pub_date > '2005-1-3' AND headline = 'Hello')
This example excludes all entries whose pub_date
is later than 2005-1-3 OR whose headline is “Hello”:
Entry.objects.exclude(pub_date__gt=datetime.date(2005, 1, 3)).exclude(headline='Hello')
In SQL terms, that evaluates to:
SELECT ... WHERE NOT pub_date > '2005-1-3' AND NOT headline = 'Hello'
Note the second example is more restrictive.
If you need to execute more complex queries (for example, queries with OR
statements), you can use Q objects
.
Please login to continue.