Django: OR queries with dynamic field names

Question

I have a value and want to get all instances having the value in one or more column. And to make this a bit more complex, the field list is dynamic.

So, what I have is: ['field1', 'field2', 'field3', ...]

What I need is: Q(field1='value') | Q(field2='value') | Q(field3='value') | ...

How can I get this?

David Wolever · Accepted Answer · 2012-04-26T19:37:59.350

7

Use ** dictionary-to-kw-args expansion:

q = Q()
for field in fields:
    q = q | Q(**{field: "value"})

(as Q() yield a Q which "does nothing", as far as I can tell)

edited Apr 26 '12 at 19:37

answered Apr 26 '12 at 19:32

David Wolever

Thanks for the update, because less than two can definitly happen. – Martin Apr 26 '12 at 19:38
1

No problem. In fact, I've taken out the original, as `reduce` is generally a bad idea, and the newer version is basically better in every way. – David Wolever Apr 26 '12 at 19:39

1 Answers1