Hi I have created a query for my front end Search form which will work if no parameters is given it will load all data or if any of the parameter is given it will display based on that .
My query is below and it works fine
select * from XXVS_AR_INVOICE_SUM_FRM_VIEW where (((SOURCE=:id) OR ( :id IS NULL)) AND ((INV_NUM=:id1) OR ( :id1 IS NULL)) AND ((UPPER(CUST_NAME)=UPPER(:id2)) OR (:id2 IS NULL))AND ((ACCT_NUM=:id3) OR ( :id3 IS NULL)) AND ((INV_NUM=:id4) OR ( :id4 IS NULL)))
When i Create a Rest api using ords and define 5 parameters it is errored out to 400
My Rest service when no value is given to bind variables and clicking on test in set bind variables is directed to the http://1**.**.**:8080/apex/jetapps/admin/invpos/,,,,
Could anyone help on what i am missing here??
Thanks