Hello,
I am running into an issue when using the LIKE operator on my webservice. In order to make the like more effective, I have added a percent sign before and after the text I want to search on. This way I can bring back results that have my text anywhere within the result. Example, I am searching for records with "Mills" in them. I use "%Mills%" when querying their results.
Here is my URL for my search:
http://localhost:9090/server/phit/Reporting_Service/views/sv_report?$filter=%22Producer%22+like+%27%25Mills%25%27
And the full error message:
There was an error while generating this response:
URLDecoder: Illegal hex characters in escape (%) pattern - For input string: "Mi"
I really need the ability to search using wild cards. Please advise the best way to do this.
Thanks,
Nate