HI Folks,
I'm using I am using ORDS 19.1 and Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production and i would like to pass multiple values for a parameter.
I am able to perform get the desired result using the below parameters
http://server:port/ords/land_survey_information/parcels_available/?q={ "country": {"$eq": "A"},"city": {"$or": [{"$eq":"B"},{"$eq":"C"},{"$eq":"D"}]}}
But my city values can be N(dynamic in nature) and i would not like to keep on amending $eq $or values in my URL before
I can also write custom select under a rest data services and make use of pipelines function to make use of comma separated values to get the data similar to what is defined https://oracle-base.com/articles/misc/dynamic-in-lists here.
However, i would prefer if i can avoid writing custom stuffs as i have many tables working on a similar IN clause.
Is there a way i can apply where IN clause concept directly rest URL
Regards, Ajax