Having trouble using whereHas inside whereHas

[buglinjo]

• Laravel Cross Database Subqueries Version: 5.6.5
• PHP Version: 7.3
• Database Driver & Version: MySQL 8.0

Description:

Is there a way to make queries like ->whereHas('foo', function($q) { $q->whereHas('bar', ... ) }) work?

Steps To Reproduce:

If I do:

Model::whereHas('foo', function ($q) {
    $q->where('column', '=', 'asd');
})->get();

everything works fine, but if I try this:

Model::whereHas('foo', function ($q) {
    $q->whereHas('bar', function ($q) {
         //anything here is still using default connection.
    });
})->get();

it is still using default connection.

[Zuhdannur]

up gan

[MwSpaceLLC]

Hi there, we want to write that for us all work fine in mysql with package cross-database.

In this query User are in DB1 and categories are in DB2. the result work great!

For us, we must specify relation connection ('database.relation') in :

And for User, we must replace Authenticatable with new model class:

Thanks for the trick :+1:

[gfernandez-me]

for me, it keeps doing the query in the wrong db

generic model: query: user model relation (users table on database1, roles and roles_user on database2) role model (database2)

error:

Undefined table: 7 ERROR: relation \"roles\" does not exist

[gfernandez-me]

Forget it, I removed the library and extended belongsToMany, it was easier. This library only was creating problems in other parts