0
208

Written by

Cathy Sun
Follow
Question Cathy Sun · Nov 9, 2021

How to get max waiting time grouped by skillset

#Caché

Hi, I am new to InterSystems database. I am developing an application to display real time skillset statistic data, including max waiting time per skillset. I have access to the database through ODBC, using InterSystems ODBC driver. But I don't know from which table or view to get real time data of maximum waiting time per skillset. I appreciate any advices.

Product version: IRIS 2020.2
Discussion (3)0
Log in or sign up to continue

Comments

Vic Sun · Nov 9, 2021

Cathy,

What do you mean by skillset data? Do you have an idea of what tables you are working with (other than the waiting time)?

0
Cathy Sun  Nov 9, 2021 to Vic Sun

Hello Vic,

Thanks for the quick response. I am working AVAYA Intersystem cache database. There are a bunch of views that I am working with, such as eCallByCallStatYYYYMMDD, eCSRStat.. I don't know how to get max waiting time based on skillset.

0
Vic Sun  Nov 9, 2021 to Cathy Sun

Ah - I think you might get more help with this from Avaya directly, as probably most people on this forum don't know how their application is set up.

0