You need to sign in to do that
Don't have an account?
S M
SOQL Query Help from OpportunityTeamMember
Account have Opportunities. Opportunities have OpportunityTeamMembers
Accounts also have Territory(Custom Object API Name = Territory_Lookup__c). Territory Object has a field called Geo.
I need to write a SOQL query from OpportunityTeamMembers to lookup the Account -> Its Territory and the Geo on the Territory
Select Id, TaxEntity__c, OpportunityId.AccountId.Territory_Lookup__r.Geo__c From OpportunityTeamMmeber
The component - OpportunityId.AccountId.Territory_Lookup__r.Geo__c is incorrect. Can you please suggest how to get this
Accounts also have Territory(Custom Object API Name = Territory_Lookup__c). Territory Object has a field called Geo.
I need to write a SOQL query from OpportunityTeamMembers to lookup the Account -> Its Territory and the Geo on the Territory
Select Id, TaxEntity__c, OpportunityId.AccountId.Territory_Lookup__r.Geo__c From OpportunityTeamMmeber
The component - OpportunityId.AccountId.Territory_Lookup__r.Geo__c is incorrect. Can you please suggest how to get this
You have to write 2 seperate query to get the account id and Geo
Thanks
Shaijan Thomas