Hello all.
I was wondering if it is possible to use relations with multiple database connections. The concept is that the backend_users and all system tables are in the "main" database. Another database will be dedicated to a particular plugin being developed.
When using a relation to the backend_users it generates a SQL error because it doesn't prefix the table with the correct database. I have even tried extending that class and supplying the connection directly.
Below is the SQL error occurring.
Base table or view not found: 1146 Table 'plugindb.backend_users' doesn't exist (SQL: select notes.*, (select concat(last_name, ', ', first_name) from contacts where notes.contact_id = contacts.id) as contact, (select concat(last_name, ', ', first_name) from backend_users where notes.owner_id = backend_users.id) as owner from notes where notes.client_id = 2 and notes.client_id is not null order by created_at desc)
If this functionality does not exist then I can post something in the feature requests or look into changing this if someone could point me in the right path. Thanks in advance!