Django Filter Queryset Model

Question

How can I filter my table to only show the quotes from a project.

In order to display all quotes, I am using {% for quote in quotes.all %}

Now, I would like to display quote relative to a site. Which means when selecting my site_id, I`ll be able to only see the quote relative to this site_id. I could write something like

{% for quote in quotes.all %}
    {% if quote chantier.id %}
    {% endif %}
{% endfor %}

but this is wrong.

Here is my model for quote:

models.py

class Quote(models.Model):
    name = models.CharField(max_length=30)    
    site = models.ForeignKey(Site, on_delete=models.CASCADE)

How can I display all quotes from this site?

Many Thanks,

Where does this chantier comes from?

willeM_ Van Onsem
– willeM_ Van Onsem

2020-06-07 20:27:35 +00:00
Commented Jun 7, 2020 at 20:27 — willeM_ Van Onsem
– willeM_ Van Onsem, Commented Jun 7, 2020 at 20:27

willeM_ Van Onsem · Accepted Answer · 2020-06-07 20:31:27Z

2

You can make a url path that contains the site_id:

# app_name/urls.py

from django.urls import path
from app_name import views

urlpatterns = [
    path('site/<int:site_id>/', views.quotes_of_site, name='quotes_of_site'),
    # …
]

in the view, you can then filter by site_id:

# app_name/views.py

from django.shortcuts import render
from app_name.models import Quote

def quotes_of_site(request, site_id):
    quotes = Quote.objects.filter(site_id=site_id)
    return render(request, 'name_of_template.html', {'quotes': quotes})

and then iterate over this QuerySet:

{% for quote in quotes %}
    …
{% endfor %}

answered Jun 7, 2020 at 20:31

willeM_ Van Onsem

482k33 gold badges483 silver badges624 bronze badges

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

Collectives™ on Stack Overflow

Django Filter Queryset Model

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related