Handling different database connections

[Usman-Ejaz]

Describe the bug
I've 2 database connections, One for the main application and other one is for activity logs. Adding data to activity logs table is working fine, but when I'm retreiving data from acvitivut logs table, It is showing the error base table or view secondary_database.users not found. How can I override the causer relation to mention the database connection. I don't want to mention database connection name in each model.

[felipechiodini]

I dont know but you can try to overwrite the model class method and force the connection to wished database
make a custom model that extends the model from package Spatie\Activitylog\Models and overwrite the relation method

protected function morphInstanceTo($target, $name, $type, $id, $ownerKey)
{
    $instance = $this->newRelatedInstance(
        static::getActualClassNameForMorph($target)
    );

    if ($your_user_model) {
        $instance->setConnection($whised_connection);
    }

    return $this->newMorphTo(
        $instance->newQuery(), $this, $id, $ownerKey ?? $instance->getKeyName(), $type, $name
    );
}