Hello,
I faced this issue a while back. What I do, as soon the call comes in, I
Set(UID=${UNIQUEID}), then re-use UID allong the dialplan as
Set(CDR(UID)=${UID}).
My DB has a UID field, that I can group by
On 27 October 2012 10:26, Bharat Lalcheta bharatlalch...@gmail.com wrote:
Its depends
To: asterisk-users@lists.digium.com
Subject: [asterisk-users] How to tie orders taken to specific CDR records
Our phone operators work off of an Asterisk queue. They take calls from
customers and take orders with our back end systems. What I need to be able
to do is tie the orders taken
Looking at the uniqueid, I get multiple records for some of them. Am I
getting more than one CDR record per call in some cases?
SELECT uniqueid, COUNT(*) FROM asterisk_cdr
GROUP BY uniqueid
HAVING COUNT(*) 2
Mitch
On 10/26/2012 08:34 AM, Bharat Lalcheta wrote:
Every CDR has
Our phone operators work off of an Asterisk queue. They take calls from
customers and take orders with our back end systems. What I need to be
able to do is tie the orders taken to the specific CDR record that
reflects the call from which the order originated.
The typical/sample CDR table
.
-Original Message-
From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Mitch Claborn
Sent: Thursday, October 25, 2012 11:19 AM
To: asterisk-users@lists.digium.com
Subject: [asterisk-users] How to tie orders taken to specific CDR records
Our
...@lists.digium.com] On Behalf Of Mitch Claborn
Sent: Thursday, October 25, 2012 11:19 AM
To: asterisk-users@lists.digium.com
Subject: [asterisk-users] How to tie orders taken to specific CDR records
Our phone operators work off of an Asterisk queue. They take calls from
customers and take orders
On 10/25/2012 11:18 AM, Mitch Claborn wrote:
Our phone operators work off of an Asterisk queue. They take calls from
customers and take orders with our back end systems. What I need to be
able to do is tie the orders taken to the specific CDR record that
reflects the call from which the order
On Thu, Oct 25, 2012 at 12:18 PM, Mitch Claborn mitch...@claborn.net wrote:
Our phone operators work off of an Asterisk queue. They take calls from
customers and take orders with our back end systems. What I need to be able
to do is tie the orders taken to the specific CDR record that