Database table fields used by wallboard store data in milliseconds

From DocWiki

(Difference between revisions)
Jump to: navigation, search
m (1 revision)
m (Bot: Adding {{Template:Required Metadata}})
 
Line 1: Line 1:
 +
{{Template:Required Metadata}}
== Database table fields used by wallboard store data in milliseconds ==
== Database table fields used by wallboard store data in milliseconds ==

Latest revision as of 18:24, 18 December 2009

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