Django query using OR

Question

I have a queryset of providers:

>>> provider_qs = Provider.objects.filter(...)
[<Provider: Gin Investors>, <Provider: IND INVESTORS>]

What would be the query to get all financial statements for those providers? Something like -

>> fs = FinancialStatement.objects.filter(provider__in provider_qs)

?

istruble · Accepted Answer · 2012-01-25 00:36:09Z

2

Yes, you can simply do:

fs = FinancialStatement.objects.filter(provider__in=provider_qs)

Django optimizes this into one SQL query. There is an example exactly for this in the Django QuerySet documentation:

inner_qs = Blog.objects.filter(name__contains='Cheddar')
entries = Entry.objects.filter(blog__in=inner_qs)

istruble

13.8k2 gold badges51 silver badges54 bronze badges

answered Jan 25, 2012 at 0:06

Mitar

7,2708 gold badges69 silver badges94 bronze badges

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

Comments

seler · Accepted Answer · 2012-01-25 02:00:22Z

0

You can do this in one line:

fs = FinancialStatement.objects.filter(provider__whatever__more='asd')

or using example from Mitar's answer:

entries = Entry.objects.filter(blog__name__contains='Cheddar')

You should really read more on Django querysets.

answered Jan 25, 2012 at 2:00

seler

9,2334 gold badges43 silver badges55 bronze badges