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”:
1 | Entry.objects.exclude(pub_date__gt=datetime.date(2005, 1, 3), headline='Hello') |
In SQL terms, that evaluates to:
1 2 | 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”:
1 | Entry.objects.exclude(pub_date__gt=datetime.date(2005, 1, 3)).exclude(headline='Hello') |
In SQL terms, that evaluates to:
1 2 3 | 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.