CODEWITHSUNDEEP
pythondjangodjango-querysetdjango-database
David Schumann
David Schumann

Reputation: 14793

Construct Django Query with dynamic complex AND + OR structure

I need to query MyField for a list of language:country tuples. (

The SQL I want would be:

SELECT * FROM MyField WHERE
language=my_tuples[0][0] AND country=my_tuples[0][1] OR
language=my_tuples[1][0] AND country=my_tuples[1][1] OR
language=my_tuples[2][0] AND country=my_tuples[2][1] OR
...

I saw this similar question but couldn't quite get it to work: Django: OR queries with dynamic field names

Upvotes: 0

Views: 116

Answers (1)

David Schumann
David Schumann

Reputation: 14793

I figured it out with a bit of tinkering:

    qs = self.MyField.all()
    q = Q()

    for combination in my_tuples:
        q = q | Q(Q(language=combination['language']) & Q(country=combination['country']))

    return qs.filter(q)

Upvotes: 1

Related Questions