Search code examples
pythondjangopython-3.xdetailsview

Python Django - Show all assigned objects on the web page

I am developing web app for tracking orders. And I would like to display all orders which were created by a user via detailView.

models.py

class Order(models.Model):
    ...    
    user = models.ForeignKey(MyUser, on_delete=models.CASCADE)
    order_number = models.CharField(max_length=150)

 class MyUser(models.Model):
    eid = models.CharField(max_length=7)
    name = models.CharField(max_length=150)
    surname = models.CharField(max_length=150)

views.py 

     class UserDetailView(generic.DetailView):
        model = MyUser
        template_name = "database/user_detail.html"


     def get_queryset(self):
        return Order.objects.all().order_by("-id")

user_detail.html

     {% extends "base.html" %}
     {% block content %}
     <body>
         <h1> {{ user.eid }} {{ user.name }} {{ user.surname }} 
         </h1>
         {% for order in orders %}
             order.order_number
         {% endfor %}
      {% endblock %}

With this code I receive error: page not found: No Order found matching the query.

If i delete the def get_queryset() in the views.py, it shows only the users eid and name. Not sure how I can get all the assigned orders to the particular user.

Solution

  • Django allows you to follow relationships "backwards", meaning you can query all records of a modelB that has a FK or OneToOne relationship to your modelA.

    class ModelA(models.Model):
    pass

class ModelB(models.Model):
    model_a = models.ForeignKey(ModelA)

...
modela = ModelA.objects.get(id=x)
queryset = modela.modelb_set()

    That said, you can do this in your template:

    {% for order in user.order_set.all %}... {% endfor %}

    More info here: https://docs.djangoproject.com/en/2.2/topics/db/queries/#following-relationships-backward