list by related_name is empty

[NikitaAleshnikov]

Models:


in DB:


if i try to get reverse FK, chat.contests return [ ]
what is wrong?

[collerek]

It's hard to tell without the actual code you use but i would guess you do not provide select_related or prefetch_related. If you query from chat the related models are not loaded by default. If you query from contest the models are not loaded by default too but you get a primary key only model (special model with only on populated that you can load in separate call)

So you need to run

chat = await Chat.objects.select_related("contests").get(id=xxx)
assert len(chat.contests)>0

#or you can use separate query if you already have chat
await chat.contests.all()

[NikitaAleshnikov]

Thanks!