Devart Forums

Posted: **Tue 12 Apr 2016 03:57**

Hi,

I need to query the account table for a specific account type

with SOQL in the developer console I can execute the following query

Code: Select all

SELECT Id, 
       Name
FROM Account 
where RecordType.DeveloperName = 'Clinique'

but the same query fails with a SalesforceCommand...
with error: Unknown Column 'RecordType.DeveloperName'

Is it possible to do with a command?

Thanks

Posted: **Wed 13 Apr 2016 07:16**

Please try this way:

Code: Select all

SELECT a.Id, a.Name FROM Account a
INNER JOIN RecordType rt ON a.RecordTypeId = rt.Id
WHERE rt.DeveloperName = 'Clinique'

Devart Forums

RecordType of Salesforce Account

RecordType of Salesforce Account

Re: RecordType of Salesforce Account