SOQL query: the different between “1638369480000” and “1638369480000.0”

querysoql

An error occurred when I run this SOQL query.

SELECT long_number FROM some_table WHERE long_number <= 1638369480000

Error message:

MALFORMED_QUERY: some_table WHERE long_number <= 1638369480000

ERROR at Row:1:Column:57 For input string: "1638369480000"

I solved the error by adding ".0" to the end of long_number.

SELECT Timestamp__c FROM IoTRM_FacilityLog__c WHERE Timestamp__c <= 1638369480000.0

Can anyone help me understand why adding ".0" can solve this error?

Best Answer

SOQL uses 32-bit signed integers, meaning the maximum integer value is 2,147,483,647.

SOQL doesn't understand long literals (e.g. something like 1638369480000L). It'll complain about the 'L', and if you leave it out it'll try to treat it like an int.

By adding .0 to the number literal, SOQL treats it as a Decimal, which can handle literals larger than 32 bits.

+edit:

Though if you're really trying to use a timestamp here, using a Datetime field instead of a Decimal would probably be a better decision.

You can get a Long timestamp (since unix epoch, 1970-01-01T00:00:00Z) by using the getTime() method, and turn a timestamp into a Datetime using newInstance().

Related Solutions

[SalesForce] Escaping + in Salesforce REST QUERY

This is not the most elegant solution but I've encountered the same problem before, you're more than welcome to use this:

    strQuery = 'YOUR+QUERY+HERE';
    strQuery = strEndPoint.replace('%','%25');
    strQuery = strEndPoint.replace(' ','%20');
    strQuery = strEndPoint.replace('+','%2B');
    strQuery = strEndPoint.replace('\'','%27');

then add more escape character replacements as necessary depending on the characters you're using in your querystring.

After all that, just append strQuery to 'https://na16.salesforce.com/services/data/v32.0/query/?q='.

[SalesForce] group by soql query

There is an inherent irony in grouping by a field that claims in its API Name to be unique. Each grouping should theoretically contain just one record. It would perhaps make more sense if the field were simply renamed Product_Name__c. But I digress. If you are sure you want to do groupings, you can get the record count for each Unique_Name__c as follows:

SELECT count(Id) records, Unique_Name__c
FROM OpportunityLineItem
GROUP BY Unique_Name__c

Any fields you want to query for individually must be grouped. You can group multiple fields, which would look like:

SELECT Id, Unique_Name__c
FROM OpportunityLineItem
GROUP BY Id, Unique_Name__c

Or you can group just one:

SELECT Unique_Name__c
FROM OpportunityLineItem
GROUP BY Unique_Name__c

Best Answer

+edit:

Related Solutions

[SalesForce] Escaping + in Salesforce REST QUERY

[SalesForce] group by soql query

Related Topic