Django object_name rendering in template

Question

I've seen a SO post on this but can't seem to find it.

My results are rendering in my template with the object_name as
{'sessions__sum': 29649}

instead of just
29649.

How can I show just the sum? Thank you.

Update

I realize, out of lack of knowledge, I may not have asked my question correctly, so below is my view and a screenshot of my template, rendered in the browser. Hopefully this will help clear things up.

view

year_weekly_filter.filter(created__week_day=1).aggregate(Sum('sessions'))
monday2014 = year_weekly_filter.filter(created__week_day=2).aggregate(Sum('sessions'))

Template

{{ monday2014 }}

ScreenShot - how its rendering in the browser

If you're going to down vote, then you should provide some professional and useful feedback. If not for me, at least for other users that may see this post. — Charles Smith
– Charles Smith, Commented Mar 23, 2016 at 8:25

Georgina S · Accepted Answer · 2016-03-24 09:49:25Z

1

You should note that: "aggregate() is a terminal clause for a QuerySet that, when invoked, returns a dictionary of name-value pairs." - Django Docs
If you just want a single value to be returned to a variable and not a dict, use .get like so:

monday2014 = year_weekly_filter.filter(created__week_day=2).aggregate(Sum('sessions')).get('sessions__sum',0)

answered Mar 24, 2016 at 9:49

Georgina S

4672 silver badges9 bronze badges

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

2 Comments

Charles Smith Over a year ago

I have been banging my head for a day trying to figure this out...just didn't know how to ask the question. Thank you!!!

Georgina S Over a year ago

No problem! I came across this recently in my own work and was baffled by it for a bit, makes sense to return a dict for creating multiple aggregations in a single query.

Community · Accepted Answer · 2017-05-23 12:23:47Z

1

Do you mean the {{object}} in the template is rendered by the dictionary object? In this case, the key is accessed in this way.

{{object.sessions__sum}}

and you may get help in this and the related documentation is here.

I don't have enough points to add a comment, so I leave my guess here.

edited May 23, 2017 at 12:23

CommunityBot

11 silver badge

answered Mar 23, 2016 at 8:40

Leonard2

8908 silver badges21 bronze badges

Collectives™ on Stack Overflow

Django object_name rendering in template

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related