laravel yajra datatable equivalent relation with multiple database search not working

[manishjesani912]

Manager.php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Manager extends Model
{
    protected $connection = 'moodlemanager';
    protected $table = 'managers';
    protected $fillable = ['moodle_id'];

    public function moodleUser()
    {
        return $this->hasOne('App\MoodleUser', 'id', 'moodle_id');
    }
}

MoodleUser.php

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class MoodleUser extends Model
{
    protected $connection = 'moodle';
    protected $table = 'mdl_user';
    protected $fillable = ['username', 'firstname', 'lastname'];

    public function Manager()
    {
        return $this->hasOne('App\Manager', 'id', 'moodle_id');
    }
}

DashboardController

<?php

namespace App\Http\Controllers\Dashboard;

use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use App\Http\Requests;
use App\Manager;
use App\MoodleUser;

class DashboardController extends Controller
{

   //Datatable ajax response function
    public function index(Request $request)
    {
        $data = Manager ::select'*')
            ->with(['MoodleUser ']);

         return Datatables::of($data)
                   ->editColumn('MoodleUser ', function ($data) {
                      $actions = $data->MoodleUser->userName;
                      return $actions;
                  })
                 ->make(true);

    }
}

I have two models with different database connection. I load datatable with relation it's working fine with loading but when search it's not working got error SQLSTATE[42S02]: Base table or view not found: 1146 Table

Please give me any suggestion.

Thanks.

• Operating System
• PHP Version 8.1
• Laravel Version 9
• Laravel-Datatables Version 10

[razorext2]

check the variable name in

MoodleUser.php

it must be $connection, not $conection

[yajra]

Searching on two different connections is fully not supported especially if they point to different databases.

However, if the 2 databases have read access between each other, you can use a query builder.

For example in Oracle, you can query 2 different DB/Schema and table by including the schema name in the SQL.

select leads.id, leads.name, users.name user
from
  db1.users,
  db2.leads
where
  leads.user_id = users.id