cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

271
Views
10
Helpful
6
Replies
lanou
Enthusiast

UCCX Custom Query - Syntax Error

Dear members,

I'm trying the attached query against the UCCX Informix Database. It is giving "Syntax Error" without mentioning where the error is.

Anyone can advise where the issue could be?

Thanks in advance for any help.

 

6 REPLIES 6
Quigath
Enthusiast

There's a lot of SQL there.

Can you supply more info on what you're trying to do, and what else you've tried?

From your question it seems like you might have found this code somewhere and are trying to use it.

B.Hassan
Beginner

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 procedures and it ran perfectly well.

Hello,

Thank you for taking the time to respond.

I'm trying to create a custom report to have the below info in 1 report:

"AgentName-Extension-AgentLoginDetails-AgentLogoutDetails-TotalLoggedInTime-NotreadyTotalTime-ReadyTime-Calls Handled-Calls Presented-AvgTalkTime-AvgHoldTime"

I tried to use a procedure but couldnt find how it can return a list that's why I'm using a function now.

Could you please advise if a procedure can return a list in Informix.

Thank you so much.

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 

Is it possible that you share an example of a stored procedure returning a list? or a link that migh help.

Thank you for your help.

B.Hassan
Beginner

baseerulhassanblog.wordpress.com/2022/01/21/cisco-contact-center-cuic-custom-reporting/

Create
Recognize Your Peers
Content for Community-Ad