Thread Details

This is a minor issue but since everything else works so great, I thought you might want to know.

When including an escape character in a query, the color scheme gets messed up for everything following.
in this example, we want to exclude accounts with the MFG_Rep_Name__c = O'Connor -- that requires an escape sequence: O\'C%

The UI treats this like a regular text single-quote.  All subsequent coloring is off.  The query DOES still work. 

((ACCOUNT.MFG_Rep_Name__c LIKE 'o\'C%' or
--ACCOUNT.MFG_Rep_Name__c LIKE 'Frank%' ) OR
--(ACCOUNT.MFG_Rep_Name__c LIKE 'Fjm%' ) OR
--(ACCOUNT.MFG_Rep_Name__c LIKE 'Loving%' ) OR
--(ACCOUNT.MFG_Rep_Name__c LIKE 'RepNet%' ) OR

Expected: 

((ACCOUNT.MFG_Rep_Name__c LIKE 'o\'C%' or

--ACCOUNT.MFG_Rep_Name__c LIKE 'Frank%' ) OR
--(ACCOUNT.MFG_Rep_Name__c LIKE 'Fjm%' ) OR
--(ACCOUNT.MFG_Rep_Name__c LIKE 'Loving%' ) OR
--(ACCOUNT.MFG_Rep_Name__c LIKE 'RepNet%' ) OR

Thanks for letting us know, Bradley.  We'll take a look at it.

We've corrected the issue.  The fix is included in the next release, due out in March.

This issue has been resolved in SOQL Studio 2021.1.290, released Monday, 3/15/2021