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