Question
Malformed Query when querying for a large 10+ digit number
When filtering for a number larger than 2,147,483,647, you get the error of Malformed Query. It turns out that this is a limitation in SFDC, that Salesforce passes a 32 bit integer into the query, unless you explicitly tell it to use a double. The solution that SFDC gives is to add a ".0" onto the end of the number. In Gainsight, we remove the decimals when running queries, so that solution does not work when running queries in rules engine. It would be a nice idea to give the option in Rules engine to ignore or use the decimals.
You can find the SFDC thread here:
https://developer.salesforce.com/forums/?id=906F00000008ycqIAA
You can find the SFDC thread here:
https://developer.salesforce.com/forums/?id=906F00000008ycqIAA