Filter relationship by Yajra laravel-datatable serverside searchbuilder

[enaeim]

Hi friends.
I Use Yajra/laravel-datatable to datatable server side and datatables searchbuilder extension for serverside filter. And this work correctly.
But how to add a relationship field to searchbuilder. For example, in my project, in the admin panel, there is a table containing all the admins of the site and there is no column as the their roles. But I want to search and find users who are operators in searchbuilder. How do I implement this using searchbuilder and yajra?
I am new to datatables, yajra and jquery.
I would be very grateful if you could guide me or introduce me to the tutorial link or in-depth tutorial on this.
Thanks a lot.

Originally posted by @enaeim in #2648 (comment)

[github-actions]

This issue is stale because it has been open for 30 days with no activity. Remove stale label or comment or this will be closed in 7 days.

[yajra]

You can use filterColumn

    return DataTables::eloquent($model)
                ->filterColumn('relation_name', function($query, $keyword) {
                    $query->whereHas('relation', fn($q) => $q->where('relation_name', $keyword));
                })
                ->toJson();

[github-actions]

This issue is stale because it has been open for 30 days with no activity. Remove stale label or comment or this will be closed in 7 days.

[github-actions]

This issue was closed because it has been inactive for 7 days since being marked as stale.

[humbertleonardo]

@enaeim Could you teach me how to use SearchBuilder together with the ServerSide option? I've analyzed Issue #2648 but I still can't get it to work

[enaeim]

@enaeim Could you teach me how to use SearchBuilder together with the ServerSide option? I've analyzed Issue #2648 but I still can't get it to work

Hello. Yes I can. But not now. I will get back to you within the next few days.

[humbertleonardo]

@enaeim Could you teach me how to use SearchBuilder together with the ServerSide option? I've analyzed Issue #2648 but I still can't get it to work

Hello. Yes I can. But not now. I will get back to you within the next few days.

Okay, thank you very much for your attention. If you can make the code you implemented available in some repository, I can try to do it myself