Django: Getting column max value as Integer

Question

I have this:

maxAux = Auxi.objects.all().aggregate(Max('nroAux'))

Then I need to add +1 to its value, but doing:

maxAux = maxAux+1

will throw an error since aggregate(max returns a string value like {'nroAux__max': 5} and I only need this number 5.

Please avoid asnwering about id or django default autoincr column. I really need to make additions to my column nroAux. Thanks!!

ruddra · Accepted Answer · 2019-02-01 13:02:17Z

4

Aggregation actually returns a dictionary, and you can get the value same way as getting a value from dictionary using a key. For example (by using dict.get()):

maxAux = Auxi.objects.all().aggregate(max_val = Max('nroAux'))  # providing a key max_val

maxAux.get('max_val')

edited Feb 1, 2019 at 13:02

answered Feb 1, 2019 at 12:57

ruddra

52.1k7 gold badges82 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Django: Getting column max value as Integer

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related