Using QueryBuilder as scope in a model

[berkaygure]

Hi folks,

I want to ask this:

I have a trait called Filterable, and it has a scope. It looks like this:

    public function scopeFilter(Builder $query): QueryBuilder
    {
        $filter = $this->filterable ?? [];
        $sortables = $this->sortable ?? [];

        return QueryBuilder::for($query) // also tried self::class
            ->allowedSorts($sortables)
            ->allowedFilters($filter);
    }

I want to use it like this:

 MyModel::filter()->with('country')->paginate();

It works perfectly on a non-related field, but when I tried to filter or sort on a related field, it won't work. It puts my filter into the main query instead of the related model.

Here is the SQL output:

select * from "locations" where "locations"."deleted_at" is null order by "country"."name" asc

Is it a bug, or I can't use it like this?

Any Idea?

[berkaygure]

Ah, I figured out that there is no problem with using it as a scope. The problem was related to sorting. There is no support to sort a column with a related column directly. I fixed my issue, and this was helpful. #36