Django: Add subquery to a nested model

Question

I have the following models in my project. An SRV contains many projects, and each project contains several tasks. I am detailing each SRV in a template and showing a list of all associated projects.

class Srv(models.Model):
    srv_year = models.CharField(max_length=4)

class Project(models.Model):
    srv = models.ForeignKey(Srv, on_delete=models.CASCADE, null=True, blank=True)

class Todo(models.Model):
    project = models.ForeignKey(Project, on_delete=models.CASCADE, null=True, blank=True)
    state = models.BooleanField(blank=True, null=True, default=False)

in views.py I want to get the completed tasks associated with each project, but I always get all the tasks associated with all projects from the SRV (main model)

class srvdetail(LoginRequiredMixin, DetailView):
    model = Srv
    template_name = 'srv_detail.html'
    slug_field = 'slug'

UPDATE:

Add a couple of definitions in the Project model and printed them in the template as follows:

class Project(models.Model):
    #...

    def todo_done(self):
        return self.todo_set.filter(state=True).count() * 100 / self.todo_set.all().count()

    def todo_left(self):
        return self.todo_set.filter(state=False).count() * 100 / self.todo_set.all().count()

In my template:

{% for project in srv.project_set.all %}
{{project.todo_done|floatformat:0|intcomma}}% complete
{{project.todo_left|floatformat:0|intcomma}}% left
{% endfor %}

Thank you for your comments @NKSM

Daniel · Accepted Answer · 2021-01-18 20:20:52Z

1

Why not something like?

Todo.objects.filter(
    state = <state>,
    project__srv = <srv_instance>
)

Update:

template.html:

{% for srv in srvs %}
  <div> srv year: {{srv.srv_year}} </div>
  {% for project in srv.project_set.all %}
    <div> project id: {{project.id}} </div>
    {% for todo in project.todo_set.all %}
      {% if todo.state %}
        <div> todo id: {{todo.id}} </div>
      {% endif %}
    {% endfor %}
  {% endfor %}
{% endfor %}

edited Jan 18, 2021 at 20:20

answered Jan 18, 2021 at 15:26

Daniel

3,5371 gold badge10 silver badges28 bronze badges

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

2 Comments

Drennos Over a year ago

sorry, but i don't understand how to incorporate this into code. I understand that I must get the tasks per project and send it as context for each project listed

Daniel Over a year ago

We'll you don't really need to do this in the view - see my updated answer.

NKSM · Accepted Answer · 2021-01-23 00:20:07Z

1

Try the below code:

in your view:

projects = Project.objects.filter(todo__state=True)

in your template:

<table>
    <tr>
        <th>srv year</th>
        <th>project ID</th>
        <th>Total number of completed tasks</th>
    </tr>
    {% for project in projects %}
    <tr>
        <td>{{ project.srv.srv_year }}</td>
        <td>{{ project.pk }}</td>
        <td>{{ project.todo_set.count }}</td>
    </tr>
    {% enfor %}
</table>

edited Jan 23, 2021 at 0:20

answered Jan 18, 2021 at 19:48

NKSM

5,8944 gold badges31 silver badges43 bronze badges

3 Comments

Drennos Over a year ago

How can I send this value to each project in the template? the Django system on the cli correctly detects the number of completed tasks per project associated with the SRV

NKSM Over a year ago

@Drennos, i have updated my answer. This should be work.

Drennos Over a year ago

I managed to send extra content to my template by adding definitions in my model

Collectives™ on Stack Overflow

Django: Add subquery to a nested model

2 Answers 2

Update:

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Update:

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related