[asterisk-users] How to tie orders taken to specific CDR records

[Tiago Geada]

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 <bharatlalcheta at gmail.com> wrote:

> Its depends on dialplan and the way you treat the call.
>
>
> On Fri, Oct 26, 2012 at 7:54 PM, Mitch Claborn <mitch_ml at claborn.net>wrote:
>
>> 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 uniqueid/callid generated and unique between all records.
>>> This callid generated when call arrives on system. And logged in CDR
>>> record as well. You can use it in your dialplan to bind with your order
>>> like
>>> exten => s,1,Set(ORDERID=${UNIQUEID})
>>>
>>
>> --
>> ______________________________**______________________________**_________
>> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>> New to Asterisk? Join us for a live introductory webinar every Thurs:
>>               http://www.asterisk.org/hello
>>
>> asterisk-users mailing list
>> To UNSUBSCRIBE or update options visit:
>>   http://lists.digium.com/**mailman/listinfo/asterisk-**users<http://lists.digium.com/mailman/listinfo/asterisk-users>
>>
>
>
>
> --
> Bharat Lalcheta
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>                http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20121028/bff1a504/attachment.htm>