[SalesForce] MALFORMED_SEARCH error with SOQL query in C# application

when I run this SOQL query via the Developer Console it works…

SELECT Id FROM Event WHERE Subject LIKE 'Order%Created'

SELECT Id FROM Event WHERE (Subject LIKE 'Order%Created')

But when I put this query into my C# application I get a "MALFORMED_SEARCH: No search term found. The search term must be enclosed in braces."

I've tried everything I can think of and reviewed all the available documentation that I could track down to no avail… What exactly is the SalesForce API expecting in this case??
remove signature

Best Answer

You haven't posted your code, but based on the error message it sounds like you're passing your SOQL query to the search function, when you should be passing it to the query function.

Related Solutions

[SalesForce] SOQL query not returning any record even when it is present. Trigger failing due to this

I observed the same issue in our full sandbox after a refresh. I believe it is a bug, though it is not yet on Salesforce's known issues list.

If you change your query to Select Id,Name from CaseTeamRole where Name != 'CSO', your query will probably return all results except the record where the Name is CSO.

If you change your query to Select Id,Name from CaseTeamRole where Name like '%s%', your query will probably return two records: CSO and Global Sales Manager.

It looks to me that the results only return if > 1 row is in the result set.

The workaround that could work for you is to query for all CaseTeamRole records and then loop through each result looking for Name = 'CSO'. For example:

for (CaseTeamRole ctr: [select id, name from CaseTeamRole])
{
 if(ctr.Name == 'CSO')
 {..do stuff.. }
}

If you happened to open a case with Salesforce, would be curious to know if they confirmed whether it is a bug or not.

[SalesForce] SOQL Order By with Limit

As long as the cost is below 1, you have little to worry about.

The main way you would increase your selectivity is by adding filters in your WHERE clause. Even if there is still a difference between the two, your query will be comfortably selective.

You need to make sure your filters all use indexes. Specifically based on your comments, that precludes the use of leading wildcards:

Using Leading % Wildcards

A LIKE condition with a leading % wildcard does not use an index.
SELECT Id FROM Account WHERE Name LIKE '%Acme%'

Best Answer

Related Solutions

[SalesForce] SOQL query not returning any record even when it is present. Trigger failing due to this

[SalesForce] SOQL Order By with Limit

Using Leading % Wildcards

Related Topic