How to fetch arrayfield data in django with postgres

Question

I'm trying to fetch users list based on their language(from ArrayField). A single user can have multiple languages. When i passed single language{'Hindi'}, it fetches all the records except user with multiple languages, but if passed parameters {'Hindi','bangla','kannada'} then it gives me a specific record,how can i fetch the users list with hindi and other than hindi as well . I have tried with .all also but it didn't worked for me. Any help would be appreciated.

models.py

# DESCRIPTION: This function gets the drivers list by lang.
    @classmethod
    def get_driver_by_lang(cls, driver_lang):
        try:
            driver_details = cls.objects.filter(language = driver_lang)
            data = serializers.serialize("json", driver_details)
            data = json.loads(data)
            return data
        except :
            return False

also you probably have the wrong database design. searching for specific array elements can be a sign of database misdesign. check this answer — xxbinxx
– xxbinxx, Commented Jul 22, 2019 at 6:20

mhd · Accepted Answer · 2019-07-22 06:26:09Z

2

How about this:

driver_details = cls.objects.filter(language__contains = driver_lang)

edited Jul 22, 2019 at 6:26

answered Jul 22, 2019 at 6:15

mhd

4,76711 gold badges40 silver badges54 bronze badges

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

3 Comments

xxbinxx Over a year ago

won't it be cls.objects.filter(language__contains=[driver_lang])?

Prathamesh Doke Over a year ago

without '[]' it is working. let me check again with [].

Prathamesh Doke Over a year ago

with the [] it gives an error, but without it , its working. Thanks @mhd

Collectives™ on Stack Overflow

How to fetch arrayfield data in django with postgres

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related