Django filtering with query with many objects

Question

sorry, I can't imagine better title for my question

I have two filters

themes = Theme.objects.filter(grade = st.grade) # returns many objects
tests = Test.objects.filter(theme=themes)

I want to return all objects, that equal to any object from themes, but it returns only objects then equal to first object from themes

ndpu · Accepted Answer · 2014-01-24 08:35:26Z

3

If theme in Test is ForeignKey to Theme, you can do it in one query:

tests = Test.objects.filter(theme__grade=st.grade)

answered Jan 24, 2014 at 8:35

ndpu

22.6k6 gold badges61 silver badges72 bronze badges

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

Comments

Serafeim · Accepted Answer · 2014-01-24 08:30:55Z

2

Use in:

tests = Test.objects.filter(theme__in=themes)

answered Jan 24, 2014 at 8:30

Serafeim

15.1k15 gold badges96 silver badges136 bronze badges