Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR PYTHON

case statement in querset django

# 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')
Source by docs.djangoproject.com #
 
PREVIOUS NEXT
Tagged: #case #statement #querset #django
ADD COMMENT
Topic
Name
7+9 =