Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Outbound Reportq on February 22, 2007, 07:37:01 AM

Title: How to retrieve records for a particular ANI from CCon?
Post by: Outbound Reportq on February 22, 2007, 07:37:01 AM

Hi,

please do not flame me for asking too many questions and not answering any.  :-\

Can someone tell me please the way to retrieve all the relevant records from ccon based on ANI? I look at Ccon table structure and cannot tell where ANI is less alone how to get it from there.

Thank you so much.

OR

Title: Re: How to retrieve records for a particular ANI from CCon?
Post by: victor on February 23, 2007, 05:17:01 AM

This should be simple:


you are looking for FIRST_PHONE field in GCDR.  This is your ANI :)

SELECT FIRST_PHONE FROM GCDR where FIRST_PHONE = 'NUMBER HERE' will return all the records you need.

For detailed info, you then just need to SELECT SCDR table  ;D

Tell me if you need help!

Best regards,
Vic