Skip to main content
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
Was there a sample use case of when we hit such a large number?
Hi Mandy, I recently started going through all of the unanswered or unresolved problems and questions here. 


Found this is as a bug,this should be handled in rules screen at UI Level. I've raised a zendesk ticket, will let you know once this is resolved. Thanks for letting us know. 



This issue has been addressed in V5.10 release.

Reply