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
Question
Malformed Query when querying for a large 10+ digit number
+5Was there a sample use case of when we hit such a large number?
+1Hi 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.
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.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.