...
Div | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Using a contact's ID to select aNewVoiceMediaVonage Contact Center agent's IDUsing 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 NewVoiceMedia Vonage Contact Center agent who owns the first case.
Using a contact's name to get a count of open cases that the contact has reportedUsing 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.
Using an account's ID to get the average opportunity amountUsing 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.
Using a lead's ID to get the owner of the most recent activityUsing the lead's ID, which you have previously retrieved and stored in an existing data source, the SOQL query returns activity date, owner ID and call type for the most recent activity.
Using a contact's ID to get the owner of the most recent non-closed caseUsing the contact's ID, which you have previously retrieved and stored in an existing data source, the SOQL query returns created date, owner ID and status for the most recent non-closed case.
Using a contact's ID to get the owner of the non-closed opportunity with the greatest amount valueUsing the contact's ID, which you have previously retrieved and stored in an existing data source, the SOQL query returns opportunity ID, opportunity amount, owner ID, close date and stage for the most non-closed opportunity with the greatest amount value.
Using an account's ID to get the number of undelivered ordersUsing the account's ID, which you have previously retrieved and stored in an existing data source, the SOQL query returns the order ID, order status, and owner ID for the first 10 undelivered orders.
Using a zip code and order number to get an order's delivery dateUsing the order number and zip code associated with an order, which you have previously retrieved using IVR Collect Digit String applets, the SOQL query returns the delivery date for the order.
Using an account's ID to get the most recently closed opportunity (within the last 30 days)Using the account's ID, which you have previously retrieved and stored in an existing data source, the SOQL query returns the opportunity ID, amount, owner ID and close date for the opportunity most recently closed within the last 30 days.
Using a subquery to get the most recently created opportunity for a matched accountUsing the agent's CLID, the SOQL returns the account ID for the first matching account. The subquery returns the opportunity ID and name for the most recently created opportunity related to the matching account.
|
...