id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
29762	Document how database routers are used for related object access	Vackar Afzal	VIZZARD-X	"When run  a filter query like this:

{{{
my_instance = MyModel.objects.using('NonDefaultDBConn').filter(some_field='XXXX')
my_instance.local_field  #This works
my_instance.fk_field     #This doesn't work
}}}

It fails when trying to access my_instance.fk_field as it defaults to using the 'default' connection and not 'NonDefaultDBConn'

I would assume that when fetching a model using 'NonDefaultDBConn' that all subsequent lookups should go through 'NonDefaultDBConn' and not 'default' 

If this is not the case, and this is expected behaviour how can I force fk lookups to go through 'NonDefaultDBConn'

I know I can run 
{{{
MyLinkedModel.objects.filter(x_instance=my_instance)
}}}
 
But this is massively in-efficient both from a performance and code maintainability point of view.

I am using Django 2.0 with the Oracle backend.
"	Cleanup/optimization	closed	Documentation	2.0	Normal	fixed	oracle, multidb	Ülgen Sarıkavak	Ready for checkin	1	0	0	0	0	0