mmxmaverix
Technical User
Hello Avaya experts,
I have a problem with custom reports, specifically with real-time db queries. I'm not sure where's the problem, because my custom historical queries are perfectly working.
Using CMS 17.x, with latest CMS supervisor
For example - I have this simple agent (cagent table) query with just one db item:
copy/paste query check -> agent_query4=select ANSRINGTIMEfrom cagent where ACD=1 and LOGID="1" **ERROR**
// select : ANSRINGTIME FROM cagent
// where : ACD= $acd and LOGID = [Agent:]
I'm not sure where is the problem because there is no specific error message included.
So I've tried to copy existing agent report and I've tried to edit the query - the same problem with premade/copied queries...
eg: agent_query2=select cagent.LOGID,cagent.EXTENSION,cagent.TOPSKILL,cagent.PREFERENCE,cagent.MOVEPENDING,cagent.AWORKMODE,cagent.DIRECTION,cagent.AGTIME,cagent.WORKSKILL,cagent.AUXREASON,cagent.DA_SKILLfrom cagent where ACD=1 and LOGID="1" **ERROR**
I have a problem with custom reports, specifically with real-time db queries. I'm not sure where's the problem, because my custom historical queries are perfectly working.
Using CMS 17.x, with latest CMS supervisor
For example - I have this simple agent (cagent table) query with just one db item:
copy/paste query check -> agent_query4=select ANSRINGTIMEfrom cagent where ACD=1 and LOGID="1" **ERROR**
// select : ANSRINGTIME FROM cagent
// where : ACD= $acd and LOGID = [Agent:]
I'm not sure where is the problem because there is no specific error message included.
So I've tried to copy existing agent report and I've tried to edit the query - the same problem with premade/copied queries...
eg: agent_query2=select cagent.LOGID,cagent.EXTENSION,cagent.TOPSKILL,cagent.PREFERENCE,cagent.MOVEPENDING,cagent.AWORKMODE,cagent.DIRECTION,cagent.AGTIME,cagent.WORKSKILL,cagent.AUXREASON,cagent.DA_SKILLfrom cagent where ACD=1 and LOGID="1" **ERROR**