id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
6065	Field Lookup - notin	RichardH <Richard.House@…>	nobody	"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."		closed	Database layer (models, ORM)	dev		invalid	NOT IN		Unreviewed	1	0	0	0	0	0