Apex SOQL query removing object type designation from id in query

Question

I am attempting to query a custom object that has a master detail lookup relation with opportunities. When I build the query dynamically I am getting an SOQL error:

System.QueryException: unexpected token: 'A000000VmhPyIAJ'

The first three characters of the ID have been dropped in that exception, the full ID is:

006A000000VmhPyIAJ

If I dump the query string with System.debug I get this (with the full ID):

SELECT id, isdeleted, name, createddate, createdbyid, lastmodifieddate, lastmodifiedbyid, systemmodstamp, lastactivitydate, opportunity__c, issue__c, description__c, ... FROM Exceptions__c WHERE Opportunity__c = 006A000000VmhPyIAJ

If I pass this exact same string into the database.query() I get results as expected.

Anyone have any idea what is causing this? The code that is generating that query is a library that I use for hundreds of other queries through out our custom Apex, and none of those queries are failing.

The actual query block:

try {

    String query = 'SELECT  id,  isdeleted,  name,  createddate,  createdbyid,  lastmodifieddate,  lastmodifiedbyid,  systemmodstamp,  lastactivitydate,  opportunity__c,  issue__c,  description__c,  ... FROM Exceptions__c WHERE Opportunity__c = 006A000000VmhPyIAJ';
    exceptions = database.query( query );

} catch(DmlException e) {

    System.debug('DmlException: ' + e);

}

David · Accepted Answer · 2017-09-22 14:44:29Z

0

Forgot to escape single quotes on the where clause value.

WHERE Opportunity__c = '006A000000VmhPyIAJ'

answered Sep 22, 2017 at 14:44

David

2531 gold badge2 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Apex SOQL query removing object type designation from id in query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related