Using a contact's ID to select ContactWorld agent's ID
Using the contact's ID, which is stored in an existing data source, the SOQL subquery selects the IDs of the owners of the cases relating to that ID.
The main query returns the ID of the ContactWorld agent who owns the first case.
SOQL query | Data sources |
|---|---|
SELECT NVMContactWorld__NVM_Agent_Id__c
FROM User
WHERE Id IN
(
SELECT OwnerId
FROM Case
WHERE contactID = '$(Contact|ID)'
) LIMIT 1
| User|NVM Agent Id |