We are trying to implement wildcard search using ORDS in one of the application, does oracle ORDS support lower or upper functions in query parameters ? I tried to look at the documentation, found nothing so far.
Some of the columns in the table has mixed data (Lower, Upper and Mix) and we don't want to massage the source column data to either full lower or upper, so that user can do at his end instead of doing at the source data, we want to inform user to do while making the request.
We are on ORDS 20.2, could someone please help me on this, if there is anything that can be done at the ORDS level.
we are trying to hit the endpoint like below but it is not working as expected because the data in the column is in mixed format. (Some Lower, Some Upper, Some with Initcap, Some Mixed format etc.)
https://dev.net:8002/ords/hr/data/refcode?q={"code_type": {"$eq": "BOROUGH"},"code": {"$or": [{"$like":"%25bro%25"}, {"$like":"%25BRO%25"}]}}