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
10100	"""exclude"" by annotation works like ""filter"""	Pavel Anossov		"""Exclude"" by annotation does not negate lookup parameters:
{{{
>>> [g.num for g in Group.objects.annotate(num=Count('sites')).exclude(num=73)]
[73]
>>> [g.num for g in Group.objects.annotate(num=Count('sites')).filter(num=73)]
[73]

>>> e = Group.objects.annotate(num=Count('sites')).exclude(num=73).query.as_sql()
>>> f = Group.objects.annotate(num=Count('sites')).filter(num=73).query.as_sql()
>>> e == f
True

>>> Group.objects.annotate(num=Count('sites')).exclude(num=73).query.as_sql()
(u'SELECT (...), COUNT(`sites`.`id`) AS `num` FROM `site_groups` LEFT OUTER JOIN `sites` ON (`site_groups`.`id` = `sites`.`group_id`) GROUP BY site_groups.id HAVING COUNT(`urls`.`id`) = %s  ORDER BY NULL', (73,))
}}}"		closed	Database layer (models, ORM)	dev		fixed			Unreviewed	0	0	0	0	0	0