[SalesForce] unknown parsing error in soql query

I receive unknown parsing error while executing following soql query in dev console.

SELECT Name,OwnerId from account where ID in (Select AccountId from User WHERE Id = 00536000005bkdTAAQ)

I want to look at accounts associated with this user.

Best Answer

You need to wrap the Id value in single quotes ('):

WHERE Id = '00536000005bkdTAAQ'
//         ^   missing these  ^

Related Solutions

[SalesForce] SOQL help with subquery where clause

SELECT Id, Name, CreatedDate, (SELECT Name FROM Status_History__r ORDER BY CreatedDate DESC LIMIT 1)
FROM Service_Order__c WHERE id IN (SELECT Service_Order__c FROM Status_History__c WHERE Name = 'Order Completed')

The above should work I believe and worth trying

[SalesForce] Why does the SOQL parser give a primitive message like ‘Unknown error parsing query’

I would suggest using Force.com IDE plugin for Eclipse, which gives you more detailed error message about syntax error. Also you can try use other third-party applications which allow you to perform SOQL like workbench or Schema Viewer.

I would agree that error from Developer Console is not the error which we would like to see, probably you can either log a case to Salesforce or suggest your idea to Idea Exchange about this.

Best Answer

Related Solutions

[SalesForce] SOQL help with subquery where clause

[SalesForce] Why does the SOQL parser give a primitive message like ‘Unknown error parsing query’

Related Topic