We are using FSC in our org and I am trying to figure out how to do a child (FinServ__ContactContactRelation__c) to parent (FinServ__ReciprocalRole__r) query. I have a query for Parent to Child but that is not what I want because I am brining back all Roles regardless of of a customer. Parent to Child Example.
SELECT
FinServ__InverseRole__c,
(select id from FinServ__ContactReciprocalRole__r WHERE FinServ__Contact__c = '0037600000JGHcsAAH')
FROM FinServ__ReciprocalRole__c
But I want to do something like this, but system does not like it
SELECT
Id,
CreatedDate,
Name,
FinServ__Contact__c,
FinServ__RelatedContact__c,
FinServ__Role__c,
FinServ__InverseRelationship__c,
FinServ__ExternalId__c,
FinServ__StartDate__c,
FinServ__EndDate__c,
OwnerId,
FinServ__ReciprocalRole__c.FinServ__InverseRole__c
FROM FinServ__ContactContactRelation__c
WHERE FinServ__Contact__c = '0037600000JGHcsAAH'
It seems like I should be able to use dot notation for child to parent as referenced here - https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_relationships_query_using.htm#sforce_api_calls_soql_relationships_query_using
I don't know where to look in org to see where things might be supported.
thanks for any input.
Eric
SELECT Id,
Name,
[Other Fields on ContactContactRelation],
FinServ__ReciprocalRole__r.Id,
FinServ__ReciprocalRole__r.Name,
[Other Fields on ReciprocalRole]
FROM FinServ__ContactContactRelation__c
WHERE [Your conditions here]
