Need to get a distinct category list from many to many

Hello,

I Have a product table that has a many to many relation to a category table.

When I query the products, I want to display a unique list of the categories associated with the product query.

product table

product_id

categories = models.ManyToManyField(Category, related_name="cat")

category table

category_id

product_category table

product_id

category_id

I tried this, but it is not working.

            c = Product.objects.filter(keywords__contains=search, is_active=True).distinct('category_id')

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.