Display Django values() on Foreign Key in template as object instead of its id

django django-templates django-aggregation
simi picture simi · Oct 21, 2009 · Viewed 9.8k times · Source

I have a queryset in Django that calls Model.objects.values('item')... where 'item' is a Foreign Key. 

class Words(models.Model):
  word = models.CharField()

class Frequency(models.Model):
  word = models.ForeignKey(Words)
  ...

So this returns the item id and displays as an id in the template. How do I show the actual item value in the template instead of the id?

Answer

Achimnol picture Achimnol · Oct 21, 2009

To refer properties of Foreign Key items, you should use '__' lookup notation in fields. MyModel.objects.values('item__prop1', 'item__prop2', ...) should work for you.

And you can print it in templates by referencing the property names like this, when the name of template variable for the result is values.

{% for v in values %}
    Prop1: {{ v.item__prop1 }}
    Prop2: {{ v.item__prop2 }}
    ...
{% endfor %}

Related questions

How to set a value of a variable inside a template code?

Say I have a template <html> <div>Hello {{name}}!</div> </html> While testing it, it would be useful to define the value of the variable without touching the python code that invokes …

Read More
How to get the current URL within a Django template?

I was wondering how to get the current URL within a template. Say my current URL is: .../user/profile/ How do I return this to the template?

Read More
Django - iterate number in for loop of a template

I have the following for loop in my django template displaying days. I wonder, whether it's possible to iterate a number (in the below case i) in a loop. Or do I have to store it in the database and …

Read More