How to search in relations?

[perffy]

Hi guys,

i am using Laravel 8 with "rappasoft/laravel-livewire-tables": "^0.3".
What I have are three models: League, Country, and CountryTranslation.
What I want is to list all Leagues and to be able to search for the country name, which is in the CountryTranslation model.

League Model:

class League extends Model
{
    public function country()
    {
        return $this->belongsTo(Country::class)->with('translations');
    }
}

Country Model:

class Country extends Model
{
    public function translations()
    {
        return $this->hasMany(CountryTranslation::class, 'country_id');
    }
}

Livewire Table:

class LeaguesTable extends TableComponent
{
    use HtmlComponents;

    public $sortField = 'id';
    public $sortDirection = 'ASC';
    public $status;
    public $sport;

    public function mount($status = 'active', $sport = 1): void
    {
        $this->status = $status;
        $this->sport = $sport;
    }

    public function query(): Builder
    {
		if($this->sport) return League::select(['*'])->with('country', 'type')->where('sport_id', $this->sport);
        else return League::select(['*'])->with('country', 'type');
    }

    public function columns(): array
    {
        return [
            Column::make(__('ID'))
                ->searchable()
                ->sortable(),
			Column::make(__('Name'))
                ->searchable()
                ->sortable()
				->format(function (League $model) {
                    return view('backend.leagues.includes.edit', ['model' => $model]);
                }),
            Column::make(__('Country'), 'country_id')
                ->searchable(function (Builder $query, $term) {
                    $query->join('country_translations as ct', 'ct.country_id', '=', 'leagues.country_id')
                        ->orWhere('ct.name', 'like', '%'.$term.'%');
                })
                ->sortable()
                ->format(function (League $model) {
                    $def_lang = config('settings.admin.default_lang');
                    return $this->html($model->country->translations->where('lang', $def_lang)->first()->name);
                }),
            Column::make(__('Actions'))
                ->format(function (League $model) {
                    return view('backend.leagues.includes.actions', ['model' => $model]);
                }),
        ];
    }
}

I am joining the tables in the searchable() function, but when I check the debugbar I get only:
select * fromleagueswheresport_id = '1' and (leagues.idlike '%argen%' orleagues.namelike '%argen%') order byid asc limit 25 offset 0

How can I resolve that?

[perffy]

@rappasoft Can you please help me to solve this?

[rappasoft]

It looks like you're using a really old version, you should upgrade first and see if that solves your problems.

[perffy]

thank you very much! :)