Looping through annotate query

Question

Initially I asked this question, and I wanted to give credit to Daniel. Here is the new issue I have however.

I have this which works great, but I'm having a minor issue.

total_list = plan.investment_set.filter(maturity_date__gte= '%s-1-1' % current_year).values('financial_institution').annotate(Sum('maturity_amount'))

I'm having trouble displaying the financial institution name. When I loop through total list and put loop_variable.financial_institution it shows me the ID but not the name.

Any ideas on how to fix this?

nrabinowitz · Accepted Answer · 2011-09-29 18:43:45Z

1

Assuming that the "financial_institution" model has a name field, I think you could just add it to the list of values you're asking for:

total_list = plan.investment_set.filter(
    maturity_date__gte= '%s-1-1' % current_year
).values(
    'financial_institution',
    'financial_institution__name'
).annotate(Sum('maturity_amount'))

answered Sep 29, 2011 at 18:43

nrabinowitz

55.7k10 gold badges152 silver badges169 bronze badges

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

Collectives™ on Stack Overflow

Looping through annotate query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related