Django Query using contains with a list as a source?

Question

I have a list of postcodes for example:-

postcodes = ['LDN 4DN','MAN 4RF']

The address field has the post code in it, sample address fields are

'1 downing street, London, England, LDN 4DN' '10 the avenues, Manchester, England, MAN 4RF' '20 the Highalnds, Scotland, SCT L40'

Im using

site = SiteData.objects.filter(address__icontains=postcodes[0]))

In a loop to get each site, but that seems a bit lengthy, is it possible to do contains in?

can i run a query to get for example the records for the two postcodes in the list?

Thanks

I've modified your question to make it slightly clearer what the issue is. feel free to roll back if this is incorrect — Sayse
– Sayse, Commented Dec 9, 2016 at 12:03
hi i don tneed it to be case insentive? the question was how i can use contains and in, in the same query. — AlexW
– AlexW, Commented Dec 9, 2016 at 12:14
icontains is a case insensitive contains, contains on its own is what in essentially does anyway — Sayse
– Sayse, Commented Dec 9, 2016 at 12:15
"contains on its own is what in essentially does anyway" - err, quite not actually. field__contains='xxx' translates to a field like "%xxx%" (mysql syntax) clause, while field__in=("a", "b", "c") translates to a standard SQL in clause, ie field in("a", "b", "c") - which is logically equivalent to (field = 'a' or field = 'b' or field='c'). — bruno desthuilliers
– bruno desthuilliers, Commented Dec 9, 2016 at 12:38

bruno desthuilliers · Accepted Answer · 2016-12-09 12:05:56Z

16

That wont work, obviously - but you can use models.Q to build a "or" query:

import operator

clauses = (Q(address__icontains=p) for p in postcodes)
query = reduce(operator.or_, clauses)
site = SiteData.objects.filter(query)

answered Dec 9, 2016 at 12:05

78.3k6 gold badges103 silver badges129 bronze badges

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

Comments

Danny Vu · Accepted Answer · 2021-04-07 07:05:55Z

0

You could use Django's Overlap filter to achieve this.

From the docs:

Returns objects where the data shares any results with the values passed. Uses the SQL operator &&.

So, you could try:

site = SiteData.objects.filter(address__overlap=postcodes))

answered Apr 7, 2021 at 7:05

Danny Vu

1512 silver badges3 bronze badges

It should be noted that this only works for PostgreSQL.

It should also be noted this only works with Array type fields.