Styjun

I am attempting to create a search functionality that returns products that are associated with a vendor. In each listing that is returned I would like to have the vendor name and create a link to the vendor's page using the vendor primary key.

The relationship between both tables is created in a vendor_id as a foreign key pointing to the vendor table.

Ideally in the output I could do something like:

% for product in products %
 product.title <br />
 product.description <br />
 <a href="% url 'vendor' vendor.id %">vendor.name</a>
% endfor %

I can get all vendors, but that seems inefficient, and I am not sure how to make the relationship between the vendor who "owns" the product in that cycle of the loop. I've seen a post on select_related but that did not work for me, and appears to be used with objects.get instead of objects.filter

Here is my search functionality defined in view.py

def search(request):
 queryset_list = Products.objects.order_by('id')

 if 'keywords' in request.GET:
 keywords = request.GET['keywords']

 if keywords:
 queryset_list = queryset_list.filter(description__icontains=keywords)

 context = 
 'products': queryset_list
 

 return render(request, 'products/search.html', context)

models (products)

class Products(models.Model):
 title = models.CharField(max_length=200)
 description = models.TextField()
 vendor = models.ForeignKey(Vendors, on_delete=models.CASCADE)

models (vendor)

class Vendors(models.Model):
 uid = models.OneToOneField(User, on_delete=models.CASCADE)
 name = models.CharField(max_length=200)

You could access the vender of the corresponding product by product.vendor.id in the template
try this,

% for product in products %
 product.title <br />
 product.description <br />
 <a href="% url 'vendor' product.vendor.id %">product.vendor.name</a>
% endfor %

you can do something like this

% for product in products %
 product.title <br />
 product.description <br />
 <a href="% url 'vendor' product.vendor.id %">product.vendor.name</a>
% endfor %