Oracle ORDS Filter Query Date is NULL

Question

I use ORACLE ORDS. I have a collection with dates and want to filter all Dates with null values with the q parameter.

{"cancellation_date":"$null"}

I get an

ORA-01858 error

{"start_date":{"$eq":{"$date":"$null"}}}

gives me an Bad Request. Thanks

Answer 1

I think I just found a solution

{"cancellation_date": {"$null": null}}