feathersjs / feathers

The API and real-time application framework
https://feathersjs.com
MIT License
14.97k stars 742 forks source link

Find Query - test if column is null #3483

Closed elvince closed 1 month ago

elvince commented 1 month ago

Steps to reproduce

Create a feather app with knex. Create a shema with a nullable/optional column

Query to filter all row where the optional column is null

Expected behavior

Get the resutls

Actual behavior

Can't it to work at all. $ne: do not accept null value If I set it to undefined, I have a binding error in knex.

Could you please help to create this query? I read the docs and I can't get any explanation on how to write this kind of query.

Thanks,