Sails Waterline Query Null Value

Question

I am trying to query null values from my database. What is the correct syntax?

I am using the sails SQL Server waterline adapter.

I have tried:

?ChoiceItem=isNull
?ChoiceItem=Null
?ChoiceItem="null"

I feel pretty sure it can be done.

Thanks

Answer 1

You can use Waterline query language

?where={"ChoiceItem":null}

I think this should work fine.