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