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.
I am trying to select output columns of a Function into a Table. Routine is executing fine as standalone but when I select its results into a Table, I get an error. I am executing the following:select node_id C1 , resourcename C2 , callshandled C3 F...
I am developing sql script to get CSR basic information and Login Logout details of CSR w.r.t Date. I am joining Resource table and AgentStateDetail on basis of ResourceID. Stats are coming fine. But agents whose "resourceid" changes frequently (new...
View query after execution and check the parameters passed e.g. datetime. Make SP of you query, it will always work perfect. Cuic prefers SP as it gives full control over every required output.
hruser for historical stats and wallboarduser for real time stats. Resource, ACD, AgentStateDetail, ContactCallDetail - these are the tables from where you can consolidate almost all kind of statistics regarding Call, Agent, Skill Group.
SOLUTION : Instead of resourceid use column resourceloginname for Joining / consolidating multiple queries with agent bases statistics.And dnt use the condition resource active = 't' in custom queries when fetching historical stats.Doing above change...
yes it does, iterateable objects can be returned. for that you will need to work on SP output parameter.This is more related to SQL grip on IBM architecture than CUIC related.best of luck
As per my experience, CUIC query syntax sometimes does not compile specific SQL function like at times i had problem with CAST function or RANK function, though the query execution was fine in IBM informix engines.I solved it by making custom procedu...
