search

cloudcreativity / laravel-json-api

JSON API (jsonapi.org) package for Laravel applications.
http://laravel-json-api.readthedocs.io/en/latest/
Apache License 2.0
778 stars 109 forks source link

filter slug and underscore #627

Open niskah-energies opened 2 years ago

niskah-energies commented 2 years ago

Hi,

I'm trying to filter my resource with a slug containing an underscore alpha_2, but it returns an error because slug is modified without underscore alpha2 before to call database. Is there a way to use underscore slugs ??

http://localhost:8000/api/v1/countries?page%5Bnumber%5D=1&page%5Bsize%5D=15&sort=-name&filter%5Balpha_2%5D=fr

error:

Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'alpha2' in 'where clause' (SQL: select count(*) as aggregate fromcountrieswherealpha2= fr andcountries.deleted_atis null) in file /Users/oujaber/Documents/www/xclusiv.fans-pwa/backend/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 703

Thank you.

lindyhopchris commented 2 years ago

Please can you share the filter code on the relevant adapter?