Django query filter with variable column

Question

I am trying to filter a queryset using

info=members.filter(name__contains=search_string)

The problem I have is I do not know which field the user wants to search ahead of time so I need to substitute 'name' with a variable as in

variable_column = 'name'
search_type = 'contains'
filter = variable_column + '__' + search_type
info=members.filter(filter=search_string)

How do I do that?

Rich

Gotta love StackOverflow. The problem you're struggling with was solved 10 years ago XD. — Akaisteph7
– Akaisteph7, Commented Mar 24, 2022 at 16:52

Community · Accepted Answer · 2017-05-23 12:10:26Z

209

Almost there..

members.filter(**{'string__contains': 'search_string'})

To understand what it's doing, google around : ) Understanding kwargs in Python

** expands dictionary key/value pairs to keyword argument - value pairs.

To adapt your example to the solution:

variable_column = 'name'
search_type = 'contains'
filter = variable_column + '__' + search_type
info=members.filter(**{ filter: search_string })

edited May 23, 2017 at 12:10

CommunityBot

11 silver badge

answered Jan 18, 2011 at 3:01

Yuji 'Tomita' Tomita

119k32 gold badges287 silver badges247 bronze badges

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

5 Comments

Chris Hawkes Over a year ago

This may be the best answer I've seen in a long time.

jonincanada Over a year ago

Or in reference to your django model: Members_Model.objects.filter(**{ filter: search_string })

Malik A. Rumi Over a year ago

Ok, really old question, I know, but: Doesn't the use of the name filter both as the object manager method and the key in the dict cause problems?

Faiz Hameed Over a year ago

Ok another question can this string have more than one keys and variables incorporate all variables?

Stop War Over a year ago

@Rich @jonincanada- Searching for possibilty of using variable in place of fields struck upon this nice solution. Now if I want to pass the model name also as a variable, how would I do that?

Viraj Wadate · Accepted Answer · 2020-05-16 03:21:22Z

-3

Syntax:

model_name.objects.filter(column_name='value')

Ex: In my scenario, I wanted to find out all records with status completed from the Student table.

Student.objects.filter(status="completed")

answered May 16, 2020 at 3:21

Viraj Wadate

6,2832 gold badges35 silver badges30 bronze badges

1 Comment

logicOnAbstractions Over a year ago

this is just a standard filter, has nothign to do witht he question.

Collectives™ on Stack Overflow

Django query filter with variable column

2 Answers 2

5 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

1 Comment

Linked

Related