Field Lookup - notin

[RichardH <Richard.House@…>]

Field Lookups include IN which is the SQL equivalent of:

SELECT ... WHERE id IN (1, 3, 4);

The docs example is:

Entry.objects.filter(id__in=[1, 3, 4])

However, there is no Field lookup for the SQL equivalent of:

SELECT ... WHERE id NOT IN (1, 3, 4);

The attached patch implements NOTIN shown in the example:

Entry.objects.filter(id__notin=[1, 3, 4])

It works on sqlite, but I haven't tested it extensively. Someone with more than my limited understanding of the db code needs to look for possible implications.

[RichardH <Richard.House@…>]

Patch for implementing NOTIN

[ubernostrum]

This is what exclude() is for; otherwise every database lookup operator would need a corresponding "not" version.

[RichardH <Richard.House@…>]

Thanks. The pointer to exclude()has provided me with enlightenment :)
Richard