03-18-2010 01:08 AM - edited 03-14-2019 05:26 AM
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,
Regards,
Mohamed Gheta
03-18-2010 06:23 AM
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.
Regards,
Geoff
03-18-2010 08:14 AM
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,
Regards,
Mohamed Gheta
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide