Sign Up ›
  • Homelike Development
  • NEWBIE
  • 10 Points
  • Member since 2020
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies
SOLVED
4 replies

Best way of querying account history (and related accounts)

I would like to query the account history where I am excluding certain account record types.

I am developing the query in Workbench and am currently using the Workbench SOQL query tab.

As a first step I tried to get the Account.RecordTypeId, but neither of the following worked (after allowing for querying parent-child relationships in settings):
  
SELECT AccountId.RecordTypeId FROM AccountHistory LIMIT 10
Fails with: "Didn't understand relationship 'AccountId' in field path."
  
SELECT AccountId__r.RecordTypeId FROM AccountHistory LIMIT 10
Fails with: "Didn't understand relationship 'AccountId__r' in field path."
  
SELECT AccountId.RecordTypeId__r FROM AccountHistory LIMIT 10
Fails with: "Didn't understand relationship 'AccountId' in field path."

Ultimately I am using the query to get data via the python package Simple Salesforce. Alternative approaches are also welcome.






 
SOLVED
4 replies

Best way of querying account history (and related accounts)

I would like to query the account history where I am excluding certain account record types.

I am developing the query in Workbench and am currently using the Workbench SOQL query tab.

As a first step I tried to get the Account.RecordTypeId, but neither of the following worked (after allowing for querying parent-child relationships in settings):
  
SELECT AccountId.RecordTypeId FROM AccountHistory LIMIT 10
Fails with: "Didn't understand relationship 'AccountId' in field path."
  
SELECT AccountId__r.RecordTypeId FROM AccountHistory LIMIT 10
Fails with: "Didn't understand relationship 'AccountId__r' in field path."
  
SELECT AccountId.RecordTypeId__r FROM AccountHistory LIMIT 10
Fails with: "Didn't understand relationship 'AccountId' in field path."

Ultimately I am using the query to get data via the python package Simple Salesforce. Alternative approaches are also welcome.