search

spatie / laravel-query-builder

Easily build Eloquent queries from API requests
https://spatie.be/docs/laravel-query-builder
MIT License
4k stars 392 forks source link

Filter not in #932

Closed elvispdosreis closed 4 months ago

elvispdosreis commented 4 months ago

I need to do a select using not in

/api/servico?filter[tag]=unifamiliar,multifamiliar,galpao_industria,comercial_sala,loteamento

servicos.tag not in

select
  *
from
  servicos
where
  servicos.tag in (
    'unifamiliar',
    'multifamiliar',
    'galpao_industria',
    'comercial_sala',
    'loteamento'
  )

Is there any way for me to deny the field type /api/servico?filter[!tag]=unifamiliar,multifamiliar or /api/servico?filter[tag]=!unifamiliar,!multifamiliar