id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
25982	Djago ORM. Filter using multi-valued queryset	Freddie O'Donnell	nobody	"As I understand it, and from the error I received, trying to filter based on a multi-valued queryset cant be done (the error I received was something like ""cant filter using multi-valued querysets""). It is possible that one may wish to filter based on a pair of values. Commutativity of the tuples should be considered. Eg Filter the following: 

Object.objects.values_list(""v1"",""v2"").filter(AnotherObject.objects.values_list(""v1"",""v2""))

Eg,
[(1,2),(5,7),(3,8),(9,3)].filter ([(1,2),(3,9)]) = [(5,7),(3,8),(9,3)]

here (9,3) == (3,9) is false. Non-commutative

For commutative comparison we have Eg,

[(1,2),(5,7),(3,8),(9,3)].filter ([(1,2),(3,9)]) = [(5,7),(3,8)]

here (9,3) == (3,9) is true.

The non-commutative case was necessary in an example I had. I hacked it where I created lists and compared using lists. However this requires a db evaluation.

"	New feature	closed	Database layer (models, ORM)	1.8	Normal	needsinfo	mutli-value, valuequeryset		Unreviewed	0	0	0	0	0	0