How to use ORDS filters for   "or" and "and" clause

Docs link

https://docs.oracle.com/cd/E56351_01/doc.30/e87809/developing-REST-applications.htm#GUID-24ED886F-6B34-4570-A964-015A5A6…

complexKey

  "$and"

  "$or"

...

Column context override

(Example: salary greater than 1000 and name like S%)

{

  "SALARY": {"$and": [{"$gt": 1000},{"ENAME": {"$like":"S%"}} ] }

}

Implicit and in columns

```

{

  "SALARY": [{"$gt": 1000},{"$lt":4000}]

}

```

High order AND

(All first columns and or high order operators -- $and and $ors -- defined at the first level of the JSON will be joined and an implicit AND)

(Example: Salary greater than 1000 and name starts with S or T)

{

  "SALARY": {"$gt": 1000},

  "ENAME": {"$or": [{"$like":"S%"}, {"$like":"T%"}]}

}