" /> How to retrieve records for a particular ANI from CCon? - Genesys CTI User Forum
« previous next »
Pages: [1]   Go Down

Author Topic: How to retrieve records for a particular ANI from CCon?  (Read 2884 times)

Outbound Reportq

  • Guest
How to retrieve records for a particular ANI from CCon?
« on: February 22, 2007, 07:37:01 AM »
Advertisement
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
Logged
Marked as best answer by on Today at 11:33:46 AM

Offline victor

  • Administrator
  • Hero Member
  • *****
  • Posts: 1419
  • Karma: 18
Re: How to retrieve records for a particular ANI from CCon?
« Reply #1 on: February 23, 2007, 05:17:01 AM »
  • Undo Best Answer
    • 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
    Logged
    Pages: [1]   Go Up
    « previous next »