Displaying 1 result from an estimated 1 matches for "oosthuzen".
Did you mean:
oosthuizen
2010 Aug 04
1
CDR: MySQL query
Hi,
Can someone help me formulate MySQL Query(s) which will help me extract the
following details for a given DID (date range can be excluded for
simplicity).
Date-Time
DNID (I am recording this is `userfield`)
CLID
time-1 (when call was received)
time-2 (when call was answered by agent)
time-3 (when call was hung-up)
My Call flow is as follows:
- Caller dials a DNID
- Call enters queue
- Call