Join other table in the inertiaTable QueryBuilder request

[landryjohn]

I wish to know the proper way to write a querybuilder request for inertia table which can make me use foreign fields in the table. (As weel as fields concatanations).

When i use for instance

$orders = QueryBuilder::for(Order::class) ->defaultSort('created_at') ->allowedIncludes(['user']) ->select('orders.id', 'orders.total_price', DB::raw("concat(users.last_name, ' ', users.first_name) as full_name"), 'orders.paid', 'orders.shipped', 'orders.created_at', 'users.email') ->join('users', 'orders.user_id', '=', 'users.id') -> ...

It works, but i lost all the datatables functionnalities (Filter, Search, Sort, ...)

Thank