Thursday, March 21, 2013

How to create report in Salesforce with double quote in filter

A user come to me today asking how to create a report on Account with Account Name contain " (double quote) ?
Hmmm... it seems easily, just type " in report filter criteria using CONTAIN. But, it will not work, since " is consider as string function.

Checking to Salesforce community? @SteveMo response me with excellent answer. Type ' + " + ' (read: without + sign), instead of using " or \" (escape sequence in SOQL).

But I realize, after the report save and open the report again, the value for filter '"' is gone.

Not sure if this Salesforce bug? But, I believe this is something Salesforce need to look into.