PostgreSQL error on Filter Relationship

[joaoVtr]

Hi. I have a problem when i try to filter a relationship on QueryBuilder. Error SQLSTATE[42883] Undefined function: 7 ERROR: function lower

My error

My code

 $query = QueryBuilder::for($this->model)
            ->allowedFilters($columns);

And my query

I'm using Laravel 9, PostgreSQL 13.5, PHP 8.1

The issue #73 have a similar problem, but i dont understood the solution.

[joaovdiasb]

Hi, i belive it's becouse of this line: https://github.com/spatie/laravel-query-builder/blob/2e738da1ed5c34a452b1fc041862a5852ef8704d/src/Filters/FiltersPartial.php#L21 With some types of column you will be able to do it this way, but not for types like uuid, bigint... the solution i found was to create a custom filter

and hi from Brazil, ES

[joaoVtr]

@joaovdiasb Obrigado pela resposta. Também criei um filtro pra isso. Nos resta ficar de olho caso o pacote faça alguma atualização a respeito. vlw