How to filter objects with foreignkey field?

[Edw125]

Hello everyone! I work with this framework recently and I have question: how to build a query that will filter objects Cohort by foreignkey field Cohort.course? In the photo, my request gives an error. Please tell me how to solve

[dantownsend]

@Edw125 Hi - I think it's almost there. I can just spot one minor issue.

cohort = await Cohort.objects().get_or_create(
   (Cohort.number == str(array[5])) & (Cohort.course.id == int(course.id))
)

With get_and_create you can only pass in a single value for the where clause at the moment (so you have to use &). We should probably change it.

Does that work for you? If not, can you provide what error is raised?

[Edw125]

Thank you very much, the suggested method helped

[dantownsend]

Awesome, glad it worked.