Heads Up :
The post you are writing will appear in a public forum. Please ensure all content is appropriate for public consumption. Review the employee guidelines for the community here.
Hello all,
I trying to read real time data from RtCSQsSummary and RtICDStatistics tables.
For testing purposes used basic sql querry, like,
SELECT * FROM RtICDStatistics;---------------------------SELECT * FROM RtCSQsSummary;
But it is not updatin...
Hello guys,
Trying to write sample Anonymous Block query.
But I can not set date parameters for when run the reports. because parameters dialog not available.
below sql codes.
*
SELECTr.resourceName AS Agent_Name,COUNT(ccd.contactid) AS Total...
Thank you guys.
Additionally, I had a issue while subtracting two datetime variable.
SUM(((ccd.endDateTime - ccd.startDateTime)::INTERVAL SECOND(9) TO SECOND::CHAR(10)::INT) AS Total_Talk_Time_inSec,
this double colons caused issue at parameters se...