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 25307 Cannot use .annotate with conditional expressions Jared Proffitt nobody "I am trying to create a query that first annotates a `Count`, then aggregates some `Sum`s together using `Case` objects. If I do the query without the annotate, everything is fine. If I do the query without any `Case` objects in the aggregate, everything is fine. But when they are both present I get this error: {{{ 'WhereNode' object has no attribute 'get_source_expressions' }}} My query is something like this: {{{ counts = models.Package.objects.annotate( used_count=Count('projects') ).distinct().aggregate( no_parent=Sum(Case( When(parent_id__isnull=True, then=1), default=0, output_field=IntegerField() )) ) }}} I would like to eventually add the `used_count` value in the aggregate, but this itself won't even run." Bug closed Database layer (models, ORM) dev Normal fixed josh.smeaton@… matt@… Simon Charette newport.travis@… Ready for checkin 1 0 0 1 0 0