You need to sign in to do that
Don't have an account?
vs94063
Issue with using "double" type field in the query WHERE clause
Hi,
One of my salesforce object has a field whose FieldType is "double" with a precision of 18 and a scale of 0.
When I use this field in the query WHERE clause "double_field1 = 12312312312", running the query fails with an error "MALFORMED_QUERY" but when i use the WHERE clause "double_field1 = 12312312312", it query runs fine (note that this value is one digit less than the previous one).
I was expecting that i should be able to supply an 18-digit number as the filter value (since the precision was 18 and scale was 0), is my understanding correct?
Let me know how to fix this issue.
Thank you
One of my salesforce object has a field whose FieldType is "double" with a precision of 18 and a scale of 0.
When I use this field in the query WHERE clause "double_field1 = 12312312312", running the query fails with an error "MALFORMED_QUERY" but when i use the WHERE clause "double_field1 = 12312312312", it query runs fine (note that this value is one digit less than the previous one).
I was expecting that i should be able to supply an 18-digit number as the filter value (since the precision was 18 and scale was 0), is my understanding correct?
Let me know how to fix this issue.
Thank you