About ReportingEngineers-CC

ReportingEngineers-CC · 08-18-2022

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...

ReportingEngineers-CC · 02-08-2022

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...

ReportingEngineers-CC · 08-05-2022

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.

ReportingEngineers-CC · 02-25-2022

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.

ReportingEngineers-CC · 02-09-2022

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...

ReportingEngineers-CC · 02-03-2022

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

ReportingEngineers-CC · 02-03-2022

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...

Member Since	‎02-02-2022 11:54 PM
Date Last Visited	‎09-22-2023 11:29 AM
Posts	37
Total Helpful Votes Received	35

User Statistics

User Activity

INFORMIX - UCCX - Select Output values of a Routine

UCCX Customized Query- Multiple Resource Table Entries of same Agent

Re: CUIC v12.0 - Customized report is not showing all records from dat

Re: UCCX 8 wallboard Query

Re: UCCX Customized Query- Multiple Resource Table Entries of same Age

Re: UCCX Custom Query - Syntax Error

Re: UCCX Custom Query - Syntax Error