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

CUIC - Abandoned Report Query

ln33147
Level 4
Level 4

Dears,

I am trying to create a report (Unique Abandoned Report) that shows only the abandoned calls where the callers didn't call again in the same day and got their calls answered. 

Abandoned Calls Query:

select ANI from Route_Call_Detail where DateTime >= '2018-09-17 00:00' and DateTime <= '2018-09-17 23:00' and RouterQueueTime > 0 and RouterErrorCode = '448'

 

Answered Calls Query:

select ANI from Termination_Call_Detail where DateTime >= '2018-09-17 00:00' and DateTime <= '2018-09-17 23:00' and TalkTime > 0

 

Unique Abandoned Query:

select ANI from Route_Call_Detail where DateTime >= '2018-09-17 00:00' and DateTime <= '2018-09-17 23:00' and RouterQueueTime > 0 and RouterErrorCode = '448' and ANI not in (select ANI from Termination_Call_Detail where DateTime >= '2018-09-17 00:00' and DateTime <= '2018-09-17 23:00' and TalkTime > 0)

 

The Unique Abandoned Query returns nothing. What am I missing? I appreciate your feedback.

Thank you in advance.

Lara

0 Replies 0