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

CRA database fields store data in milliseconds and are presented on a wallboard in HH:MM:SS format

Core Issue

These database table fields in the RtCSQsSummary and the RtICDStatistics database tables store the date in milliseconds:

  • avgTalkDuration

  • avgWaitDuration

  • longestTalkDuration

  • longestWaitDuration

  • oldestContact

Resolution

In order to include information described by these fields on a wallboard, use these fields, which store the same information but use the HH:MM:SS format:

  • Use convAvgTalkDuration instead of avgTalkDuration.

       
  • Use convAvgWaitDuration instead of avgWaitDuration.

       
  • Use convLongestTalkDuration instead of longestTalkDuration.

       
  • Use convLongestWaitDuration instead of longestWaitDuration.

       
  • Use convOldestContact instead of oldestContact.

Refer to these documents for more information on resolving Cisco Customer Response Applications (CRA) or Customer Response Solution (CRS):

Customer Response Solution (CRS) Version

CRS 3.x

437
Views
0
Helpful
0
Comments