function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
sbasba 

Self Service Portal

I am trying to use a Self Service Portal using ASP.Net/C# and Sales force API. I want user to type in a text and the application should search for the text in Solution Details. But API Query is not allowing to use WHERE condition (Filter) with SolutionNote field?   Is there a way to do this? Any help on this matter is appreciated.
SuperfellSuperfell
Use the search API call.
sbasba
I tried the Serach call and I got this error:
 
"An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.Services.Protocols.SoapException: MALFORMED_SEARCH: "
Here is my code:

sforce.SearchResult sr = binding.search("find " + "{'" + txtSearch.Text + "'}" + " in ALL FIELDS returning Solution (Id, SolutionName, SolutionNumber)");

txtSearch is the text box in the webform.
 
Any help on this matter is appreciated.

 
SuperfellSuperfell
There's a bunch of reserved characeters that need escaping in the search text, you don't seem to be handling that. see the SOSL docs.
sbasba

That helped. Thanks.