Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Community Member

CCX Data Model: Linking ContactCallDetail to Teams

I'm building a custom report and having a difficult time trying to identify abandoned calls by what Team should have taken the call. More specifically, I'm having difficulty getting from the ContactCallDetail table to the table "team". Any ideas?

1 REPLY
Community Member

You will have to join across

You will have to join across multiple tables. The detail would be in the CCX Database Schema Guide for your version. You would be joining from ContactCallDetail to ContactQueueDetail, (via session ID, sessionSeqNum, nodeID, profileID), and then from there to ContactServiceQueue, (targetID maps to recordID when targetType is 0, via profileID) in CCX 8.5.

38
Views
0
Helpful
1
Replies
CreatePlease to create content