Retrive CallType after deletin it

Unanswered Question
Mar 18th, 2010

Dear Friend,

May I ask how to retrive calltype report or query database from HDS if I permantatly deleted the calltype from AW?

Appreciate your usual support,


Mohamed Gheta

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)

To ensure data integrity, deleting a call type cannot affect historical information.

However, if you have deleted the call type and permanently flushed it you cannot easily know what was the primary key (call type ID) of the call type you deleted. If you can look back at some old paper reports you may see the call type ID written somewhere (a number greater than 5000). If you can find it, you may be able to construct the SQL query required to get the Call Type Half Hour etc reports from the HDS.



mohamed-gheta Thu, 03/18/2010 - 08:14

Dear Geoff,

Thanks so much for your swift answer, really it is valuable idea, I will try to get old report and query to over SQL

Have a nice day,


Mohamed Gheta


This Discussion