- Check out these new queries from official docs! In addition, you may find these useful (modify as necessary):
-- Find the top 10 Unified Individual records
WITH UnifiedIndividualLinkCounts AS (
SELECT
UnifiedRecordId__c,
COUNT(*) AS NumberOfLinkedRecords
FROM
IndividualIdentityLink__dlm
GROUP BY
UnifiedRecordId__c
)
SELECT
uilc.NumberOfLinkedRecords,
ui.ssot__Id__c,
ui.ssot__PersonName__c,
ui.ssot__FirstName__c,
ui.ssot__LastName__c,
ui.Date_of_Birth__c
FROM
UnifiedIndividual__dlm AS ui
JOIN
UnifiedIndividualLinkCounts AS uilc
ON
ui.ssot__Id__c = uilc.UnifiedRecordId__c
ORDER BY
uilc.NumberOfLinkedRecords DESC
LIMIT 10; -- Find the associated Individual, CP Email, and Party ID records for a given Unified Individual ID
SELECT
i.ssot__FirstName__c,
i.ssot__LastName__c,
i.Date_of_Birth__c,
i.ssot__DataSourceObjectId__c,
pi.ssot__IdentificationNumber__c,
pi.ssot__Name__c,
pi.ssot__PartyIdentificationTypeId__c,
cpe.ssot__EmailAddress__c AS EmailAddress
FROM
IndividualIdentityLink__dlm AS iil
JOIN
ssot__Individual__dlm AS i ON iil.SourceRecordId__c = i.ssot__Id__c
LEFT JOIN
ssot__PartyIdentification__dlm AS pi ON i.ssot__Id__c = pi.ssot__PartyId__c
LEFT JOIN
ssot__ContactPointEmail__dlm AS cpe ON i.ssot__Id__c = cpe.ssot__PartyId__c
WHERE
iil.UnifiedRecordId__c = 'DESIRED_UNIFIED_INDIVIDUAL_ID';