many-to-many relation field__in - how to AND instead of OR?
0 views
Skip to first unread message
anentropic
Nov 25, 2009, 6:57:17 AM11/25/09
to Django users
I have a query like:
Product.objects.filter(categories__in=cat_ids).distinct()
where categories is a m2m field.
As I understand it this loads products which have belong to ANY of the
categories in cat_ids
How would I load only products which belong to ALL of the categories
in cat_ids?
(is this possible in ORM?)
I think in SQL you'd have to change the one IN clause to a series of
ANDs
Product.objects.filter(categories__in=cat_ids).distinct()
where categories is a m2m field.
As I understand it this loads products which have belong to ANY of the
categories in cat_ids
How would I load only products which belong to ALL of the categories
in cat_ids?
(is this possible in ORM?)
I think in SQL you'd have to change the one IN clause to a series of
ANDs
Reply all
Reply to author
Forward
0 new messages