oracle-databaseoracle-ords

ORDS not like - is it possible?


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 ?


Solution

  • 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.

    enter image description here