Multiple data source, one datatable

[taufiqridha]

Hi is there anyone has successfully implement multiple data source to one datatable ?
So let say we want 3 models / database / eloquent to display in one datatable...

any advice would be thankful
Taufiq

[yajra]

You can use DataTableHtml.

php artisan datatables:make Demo --builder

This will create DemoDataTableHtml that you can reuse on any page by calling DemoDataTableHtml::make().

Controller

    public function index(UsersDataTable $dataTable)
    {
        $demo = DemoDataTableHtml::make();
        
        return $dataTable->render('users::index', compact('demo'));
    }

View

{{ $dataTable->table() }}
{{ $demo->table() }}

@push('scripts')
{{ $dataTable->scripts() }}
{{ $demo->scripts() }}
@endpush

[yajra]

Oh just realized my mistake, the question is multiple sources and not multiple dataTable :)

[yajra]

For multiple data sources, we usually use UNION SQL.

[yajra]

If sources are from different databases, you would need to use one big collection instead. But note the performance issue for bulk data.