I'm trying to consume Oracle ORDS endpoint which works correct. The problem is when i try to add a query of type NOT LIKE I'm receiving - bad request (400)
My URL looks like :
https://my.api.com/v1/results?q="type":{"$not like":"FP%"}}
encoded :
https://my.api.com/v1/results?q=%7B%22type%22%3A%7B%22%24notlike%22%3A%22FP%25%22%7D%7D
I've also tried with :
https://my.api.com/v1/results?q=%7B%22type%22%3A%7B%22%24not%20like%22%3A%22FP%25%22%7D%7D
but not of them works. If i use only LIKE , the API works as expected. The question is if NOT LIKE is supported at all ? If not what workaround i could use ?
We don't support a query parameter filter for a 'NOT LIKE' predicate. You can see the full list in the docs
What we do have is $instr and $ninstr
I have examples for using INSTR and LIKE here.
So a GET on my activities list, with this query parameter filter added -
/?q={"activity_name":{"$ninstr":"run"}}
Brings me back activities that that don't have RUN, run, or Run in the name is said activity.