Nested Django query

Question

Say I have a user id, and the users table also has a manytomany field "teacher id". This points to the teachers table. There is a substitutes table where a foreign key is teacher id, meaning that each substitute can only substitute for one teacher, but there may be many substitutes to that teacher. (This is not really what my fields represent, but I'm just using an example.) How, in Django, would I get all the substitute id's for all teachers who are teachers for a given user id? I know how to do it in SQL, but not really sure how the Django version is.

(This is similar to a question I had before, but not the same!)

You need to have a good read of the Django QuerySet Documentation which explains exactly how to do this sort of query. — Thomas
– Thomas, Commented Nov 1, 2013 at 1:41

Vital Belikov · Accepted Answer · 2013-11-01 01:09:43Z

2

You can use something like this:

Substitute.objects.filter(teacher__user=user.pk)

answered Nov 1, 2013 at 1:09

Vital Belikov

3642 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

Nested Django query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related