Skip to main content
mandy_major
Gainsight Employee ⭐️⭐️
July 5, 2016
Question

Malformed Query when querying for a large 10+ digit number

  • July 5, 2016
  • 3 replies
  • 79 views
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

3 replies

dstokowski
Gainsight Employee ⭐️⭐️
July 7, 2016
Was there a sample use case of when we hit such a large number?
sai_ram
Expert ⭐️⭐️
June 19, 2017
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. 

pavan_bandi
Gainsight Employee ⭐️
Gainsight Employee ⭐️
August 16, 2018
This issue has been addressed in V5.10 release.