Django filter objects based on list values

Question

I have a listTextField in my modal called technology. I want to filter objects based on an array, if every array value is present in the technology field.

tech = ['a','b',....] #dynamic list
mentors_list = Mentor.objects.filter(
            **{"technology__contains" : value for value in tech}) #this doesn't work

Mentor class has (among other fields) :

class Mentor(Meta):
    technology = ListTextField(
        base_field=models.CharField(max_length=20),
        size=10, max_length=(10 * 11))

Basically i want all objects in mentor_list whose technology field must contain all the values from tech array ( but may contain some extra values ).

Andrei Berenda · Accepted Answer · 2018-05-29 02:30:33Z

3

From the documentation You can chain Q object with & to check multiple entries contains in the ListTextField.

from functools import reduce 

technologies = ['a','b'] # your dynamic list

queries = [Q(technology__contains=technology) for technology in technologies]

query = reduce(lambda x, y: x & y, queries)

mentors_list = Mentor.objects.filter(query)

Ref: How to dynamically compose an OR query filter in Django?

edited May 29, 2018 at 2:30

Andrei Berenda

1,9862 gold badges15 silver badges30 bronze badges

answered May 29, 2018 at 1:36

user459872

26k4 gold badges51 silver badges74 bronze badges

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

1 Comment

user459872 Over a year ago

Glad to help you. :)

Collectives™ on Stack Overflow

Django filter objects based on list values

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related