Answered calls

[Noufal]

Dears

Where i can find answered calls in Icon and GIM DB.

do you have any MS SQL query for this ?

[hsujdik]

Which information do you need?

The most raw query on GIM DB would be something like this:

select * from interaction_resource_fact irf
inner join technical_descriptor td on td.technical_descriptor_key = irf.technical_descriptor_key
where td.technical_result_code not in ('ABANDONED','CUSTOMERABANDONED');

But for a better result you must detail a bit more what you need

[eduardosaito]

IRF would be detailed calls (each line 1 interaction)

But if you only wants the numbers, there are several tables you could get it like the ag2_queue ones.

Agree with hsujdik, you have to put more details about it.