laravel-json-api
laravel-json-api copied to clipboard
filter slug and underscore
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 from
countrieswhere
alpha2= fr and
countries.
deleted_at is null) in file /Users/oujaber/Documents/www/xclusiv.fans-pwa/backend/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 703
Thank you.
Please can you share the filter code on the relevant adapter?