CODEWITHSUNDEEP
pythondjango
Eimantas
Eimantas

Reputation: 429

Django multi level querying

I am using my custom created User model and I have two basic models:

class Subject(models.Model):
    user = models.ForeignKey(settings.AUTH_USER_MODEL)
    title = models.TextField(max_length=1000)

class Topic(models.Model):
    user = models.ForeignKey(settings.AUTH_USER_MODEL)
    subject = models.ForeignKey(Subject)

Is there any way (without an external package like Django-mptt) to query Topics which belong to a particular Subject and were created by a particular User? I mean when a user logs in, I want to make a list like that:

Edited: here's the list that I want to make:

Hello user. Thank you for logging in.

Your items:

etc.

I am not sure how to do that. It might be easy but I am just a beginner.

Edit: the answer was a simple nested for loop, I am sorry for any confusion created.

Upvotes: 0

Views: 130

Answers (1)

Daniel Roseman
Daniel Roseman

Reputation: 599630

The question is still confusing, because there is still no querying of topics or subjects going on. You are simply iterating through a user's topics, and for each topic you are iterating through the subjects.

<ul>
  {% for topic in user.topic_set.all %}
    <li>{{ topic.title }}
      <ul>
        {% for subject in topic.subject_set.all %}
          <li>{{ subject.title }}</li>
        {% endfor %}
      </ul>
    </li>
  {% endfor %}
</ul>

Upvotes: 1

Related Questions