Page Comparison

...

The main query returns the ID of the Vonage Contact Center agent who owns the first case.

SELECT NVMContactWorld__NVM_Agent_Id__c
FROM User
WHERE Id IN
(
    SELECT OwnerId
    FROM Case          
    WHERE contactID = '$(Contact|ID)'
) LIMIT 1

...

Using the contact's id, which you have previously retrieved and stored in an existing data source, the SOQL query returns the number of unique open cases.

SELECT COUNT_DISTINCT(CaseNumber)
FROM Case
WHERE
	Contact.Id = '$(Contact|Id)' AND
	Status != 'Closed'

...

Using the account name, which you have previously retrieved and stored in an existing data source, the SOQL query returns the average time to resolve a case for the account in the last quarter.

SELECT AVG(Amount)
FROM Opportunity
WHERE
	Account.Id='$(Account|Id)'

Using a lead's ID to get the owner of the most recent activity

...

Using the agent's CLID, the SOQL returns the account ID for the first matching account. The subquery returns the opportunity opportunity ID and name for the most recently created opportunity related to the matching account.

SELECT Id,(Select Name, id FROM Opportunities order by CreatedDate desc Limit 1) 
FROM Account 
WHERE Phone ='$(CLID)' 
Limit 1

Using the entered number to locate a case or other record (using contains)

The SOQL returns the case ID of the first case located with a reference number that contains the entered number.

SELECT ID
FROM Case
WHERE Reference_Number__c like '%$(EnteredNumber)%'
LIMIT 1