cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
628
Views
0
Helpful
1
Replies

nvl

victor.ortizDD
Level 1
Level 1

Hello community,

I have a question regarding the Informix nvl() function which seems to react strangely on a cuic Server Version11.5(1) build 1 (11_5_1_10000_86) when creating a simple query, as example:

 

2017-11-15 08_10_57-Cisco Unified Intelligence Center_query.pngselect

NVL( MAX(CASE WHEN APPLICATIONNAME='VKS' THEN QUEUETIME ELSE null END ),0 ) AS VKS35_MWZ

 

FROM CONTACTCALLDETAIL  LEFT JOIN CONTACTQUEUEDETAIL

 

ON CONTACTCALLDETAIL.SESSIONID=CONTACTQUEUEDETAIL.SESSIONID 

The query works fine when running on the cuic after pushing the button create fields. the Name of the field is not taking the alias name as defined.

2017-11-15 08_11_44-Cisco Unified Intelligence Center_fields.png

Is that a limitation of the product ?

For this case i just have one field but final query has a lot of nvl functions which make really difficult to identify which one is the correct field to adapt in Terms of Name.

Many great thanks for your help.

Victor Ortiz

 

 

1 Reply 1

victor.ortizDD
Level 1
Level 1

Hello,

Is there someone who could help me on that issue, please ?

I am really blocked.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: