# Filtering models in view
**URL:** https://forum.djangoproject.com/t/filtering-models-in-view/15392
**Category:** Forms & APIs
**Created:** [August 12, 2022, 10:47am UTC](https://forum.djangoproject.com/t/filtering-models-in-view/15392 "2022-08-12T10:47:12Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@MihaMarkovi](https://forum.djangoproject.com/u/MihaMarkovi)
#### Post date: [August 12, 2022, 10:47am UTC](https://forum.djangoproject.com/t/filtering-models-in-view/15392/1 "2022-08-12T10:47:12Z")
Hello everyone,
I have a question that is probably pretty basic.
I have a SQLite database that looks like this:
```auto
from django.db import models
# Create your models here.
class Company(models.Model):
title = models.CharField(max_length=200)
address = models.CharField(max_length=200)
post_office = models.CharField(max_length=200)
ddv_id = models.CharField(max_length=200)
def __str__ (self):
return self.title
class Bill(models.Model):
eor = models.CharField(max_length=100, primary_key=True)
producer = models.ForeignKey(Company, on_delete=models.CASCADE)
bill_number = models.CharField(max_length=200)
seller = models.CharField(max_length=200)
last_updated = models.DateTimeField('last updated')
tax_level = models.FloatField()
zoi = models.CharField(max_length=200)
status = models.BooleanField()
def __str__ (self):
return self.eor
class Product(models.Model):
bill = models.ForeignKey(Bill, on_delete=models.CASCADE)
product_title = models.CharField(max_length=200)
quantity = models.IntegerField()
value = models.FloatField()
def __str__ (self):
return self.product_title
```
In HTML (localhost/app/bill\_eom/products), where bill\_eom is primary key of Bill model.
**I want to display only products, that are associated with that bill.**
I have hard coded a bill\_eom in view for demonstration:
```auto
class ProductsView(generic.ListView):
template_name = 'app/bill_products.html'
context_object_name = 'product_list'
def get_queryset(self):
return Product.objects.filter(bill__eor="af4c16cf-7d92-fcbb-98b7-9c8f4acd81bb") # yes, this is bill's primary key
```
Then, there’s url side:
```auto
path('/products', views.ProductsView.as_view(), name='product')
```
and this is HTML side:
```auto
{% for product in product_list %}
{{ product.product_title }}
{% endfor %}
```
Thank you all alot in advance
---
### Author:  [@KenWhitesell](https://forum.djangoproject.com/u/KenWhitesell)
#### Post date: [August 12, 2022, 11:36am UTC](https://forum.djangoproject.com/t/filtering-models-in-view/15392/2 "2022-08-12T11:36:53Z")
You’re really close here.
In a CBV, the url parameters are stored in `self.kwargs`. So at any point in your CBV, you can reference that parameter as `self.kwargs['bill_id']`, making your get\_queryset look something like this:
```auto
def get_queryset(self):
return Product.objects.filter(bill__eor=self.kwargs['bill_id'])
```
---
### Author:  [@MihaMarkovi](https://forum.djangoproject.com/u/MihaMarkovi)
#### Post date: [August 12, 2022, 12:13pm UTC](https://forum.djangoproject.com/t/filtering-models-in-view/15392/3 "2022-08-12T12:13:23Z")
Thank you so much Ken. Now it works perfectly 🙂