Django filter objects based on related field

Question

I have a blog setup with Entries with a many to many field to Categories.

categories = models.ManyToManyField(Category)

I have a view in which I'd like to list all of the Entries, but filter based on Entries that have a relation to the Category, which will be represented in the url as a slug.

Here is my view function so far:

def category_detail(self, request, slug):
  entries = Entry.live.all().filter()
  categories = Category.objects.all()
  return render(request, 'coltrane/entry_archive.html', 
   {"entries": entries, "categories": categories})

A category list is appearing in the sidebar, which is why I'm passing those values in the dict. I'd like to add some logic in the entries filter to return something along the lines of categories.title = slug

It's very easy to do what you are asking but your question is not clear. Please show more of your models and specify the exact filtering you require. — Two-Bit Alchemist
– Two-Bit Alchemist, Commented Jan 14, 2015 at 16:33
Example: categories.title = slug. What is the value of slug and where does it come from? Is slug unique? — Two-Bit Alchemist
– Two-Bit Alchemist, Commented Jan 14, 2015 at 16:34

catavaran · Accepted Answer · 2015-01-14 16:59:26Z

1

Do you really mean categories.title = slug?

entries = Entry.live.filter(categories__title=slug)

edited Jan 14, 2015 at 16:59

answered Jan 14, 2015 at 16:34

catavaran

45.7k8 gold badges104 silver badges89 bronze badges

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

2 Comments

byrdr Over a year ago

Thank you, easier than I thought.

Two-Bit Alchemist Over a year ago

You can even leave out .all() -- it is implied for operations like filter() and only explicitly required on an unfiltered delete.

Collectives™ on Stack Overflow

Django filter objects based on related field

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related