django filtering with q objects with dynamic fields

Question

I need to prepare filter with dynamic fields.. I don't know the field name so i need to give it dynamically. here what i tried so far,

gen_query = reduce(operator.or_, (Q(eval('%s=i' % (field, i))) for i in request.query_params.get(field).split(',')))

but it raising syntax error!

i am using, eval(field_name as string) still i am getting an error..

how to achieve this?

i want to do django filtering with q objects with dynamic fields

Dima Kudosh · Accepted Answer · 2017-11-22 14:20:06Z

8

You can create dict with parameters and unpack it in Q constructor:

gen_query = reduce(operator.or_, (Q(**{field: i}) for i in request.query_params.get(field).split(',')))

answered Nov 22, 2017 at 14:20

Dima Kudosh

7,4245 gold badges40 silver badges53 bronze badges

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

Comments

Nik · Accepted Answer · 2017-11-22 14:11:07Z

0

Could you use Q('{}={}'.format(field, i)) if you need string formatting?

answered Nov 22, 2017 at 14:11

Nik

9,5238 gold badges70 silver badges90 bronze badges

this is filter query... i think there is no meaning in it... your code will just do concatenation as i did.. its just an another method

Not working. :(