Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- result = Transaction.objects.filter(client=self).aggregate(
- positive=Coalesce(Sum(Case(When(op_type=TransactionType.ADD | op_type=TransactionType.FROM_OUTER_SYSTEM, then='sum'), default=0)), 0),
- negative=Coalesce(Sum(Case(When(op_type=TransactionType.OUT | op_type=TransactionType.TO_OUTER_SYSTEM, then='sum'), default=0)), 0))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement