Breaking News: Grepper is joining You.com. Read the official announcement!

case statement in querset django

Trained Tuna answered on February 24, 2022 Popularity 9/10 Helpfulness 4/10

answer case statement in querset django

case statement in querset django

Comment

# Creating a calculated column named 'discount' on Client table 
# Using conditional case statement with nested When -> Then logic
Client.objects.annotate(
     discount=Case(
         When(account_type=Client.GOLD, then=Value('5%')),
         When(account_type=Client.PLATINUM, then=Value('10%')),
         default=Value('0%'),
     ),
 ).values_list('name', 'discount')

Popularity 9/10 Helpfulness 4/10 Language python

Source: docs.djangoproject.com

Tags: case-statement django python

Link to this answer
Share Copy Link