Database table fields used by wallboard store data in milliseconds

From DocWiki

Revision as of 19:50, 12 August 2009 by Cchetty (Talk | contribs)
Jump to: navigation, search

Database table fields used by wallboard store data in milliseconds

Problem Summary Some database table fields used by a wallboard store data in milliseconds instead of in HH:MM:SS.
Error Message None.
Possible Cause The avgTalkDuration, avgWaitDuration, longestTalkDuration, longestWaitDuration, and oldestContact database table fields in the RtCSQsSummary and the RtICDStatistics database tables store date in milliseconds.
Recommended Action

If you want to include information described by these fields on your wallboard, use the following fields, which store the same information but use the HH:MM:SS format:

  • Instead of avgTalkDuration, use convAvgTalkDuration.
  • Instead of avgWaitDuration, use convAvgWaitDuration.
  • Instead of longestTalkDuration, use convLongestTalkDuration.
  • Instead of longestWaitDuration, use convLongestWaitDuration.
  • Instead of oldestContact, use convOldestContact.
Release Release 7.0(1)
Associated CDETS # None.

Rating: 1.0/5 (1 vote cast)

Personal tools