o have a request that a customer wants to find out if a call has been RONA’d. Once the call has been requeued they would like to populate the name of the Agent that RONA’d the call on Finesse for the next agent receiving the call.
In order to achieve this, I wrote a query against the t_Termination_Call_Detail on the logger to get the AgentSkillTargetID by using the RouterCallKey and RouterCallKeyDay and also the disposition 19 and then use the
AgentSkillTargetID to query the t_Agent table on the logger to get the agents name
The problem with this is that the information is not populating fast enough on the TCD table before the call requeues hence the SQL query shows 0 rows processed.
I am trying to find out if there is a easier way to do this or if there is a Table within the DB that would have the information instantly.
