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
30340	Filtering after `.difference()` does not work	Herman S	nobody	"Example:


{{{
In [*]: User.objects.filter(
    ...:     id__in=[1,2,3,4],
    ...: ).difference(
    ...:     User.objects.filter(
    ...:         id__in=[1,2],
    ...:     )
    ...: ).values_list(
    ...:     'id', flat=True
    ...: ).filter(
    ...:     id=3,
    ...: )
Out[*]: <UserQuerySet [3, 4]>
}}}

The expected output from the query above is of course only `[3,]` and not `[3,4]`

Haven't tested this in 2.2."	Bug	closed	Database layer (models, ORM)	2.1	Normal	duplicate			Unreviewed	0	0	0	0	0	0