include relationships in queries about inertiajs-tables-laravel-query-builder HOT 4 CLOSED

There's some info about this on the Query Builder docs: https://spatie.be/docs/laravel-query-builder/v3/features/including-relationships#selecting-included-fields

from inertiajs-tables-laravel-query-builder.

The QueryBuilder also accepts an Eloquent Builder, so you could do something like this:

QueryBuilder::for(SomeModel::with('users'))

from inertiajs-tables-laravel-query-builder.

@zamblas you can aggregate the relations columns in the query builder:

QueryBuilder::for(Model::class)
->withAggregate('relation', 'column')

Then use like this:

$table->column('relation_column', 'Displayed name', sortable: true, searchable: true);

from inertiajs-tables-laravel-query-builder.

Is there any example available?

On a users table, I'm trying to add a column with the user role.
Got it to show using QueryBuilder::for(User::with('roles')) on the controller and on the .vue

<template #cell(roles)="{ item: user }">
    {{ user.roles.map(role => role.name).join(', ') }}
</template>

But when sorting that column it gives an error Unknown column 'roles' in 'order clause'.

How can I sort by relationship? I've tried adding 'roles', 'roles.name' to allowedSorts but with no success

from inertiajs-tables-laravel-query-builder.