Skip to content

Instantly share code, notes, and snippets.

@fergus

fergus/WrapUpCodesOnQueue.sql

Created October 31, 2013 21:50
Show Gist options
  • Save fergus/7257811 to your computer and use it in GitHub Desktop.
Save fergus/7257811 to your computer and use it in GitHub Desktop.
Download ZIP
Interactive Intelligence (ININ) Customer Interaction Centre (CIC) 3.0 MS SQL Query for returning the wrap-up code associated with a specific Workgroup.
Raw
WrapUpCodesOnQueue.sql
-- Interactive Intelligence (ININ) Customer Interaction Centre (CIC) 3.0 MS SQL Query for returning the wrap-up code counts associated with a specific Workgroup.
SELECT WrapUpCode, count(WrapUpCode) as WrapupCount
FROM dbo.calldetail
WHERE
InitiatedDate > '2013-09-01' AND InitiatedDate < '2013-10-01'
AND InteractionType = 0 -- Phone Calls Only
AND CallEventLog like '%Entered Workgroup Queue - Call Centre Secured Loans%'
GROUP BY WrapUpCode
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment