<font color="#000066"><font><font face="tahoma,sans-serif">Hello,</font></font></font><div><font color="#000066"><font><font face="tahoma,sans-serif"><br></font></font></font></div><div><font color="#000066"><font><font face="tahoma,sans-serif">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}).</font></font></font></div>
<div><font color="#000066"><font><font face="tahoma,sans-serif"><br></font></font></font></div><div><font color="#000066"><font><font face="tahoma,sans-serif">My DB has a UID field, that I can group by<br></font></font></font><br>
<div class="gmail_quote">On 27 October 2012 10:26, Bharat Lalcheta <span dir="ltr"><<a href="mailto:bharatlalcheta@gmail.com" target="_blank">bharatlalcheta@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Its depends on dialplan and the way you treat the call.<div class="HOEnZb"><div class="h5"><br><br><div class="gmail_quote">On Fri, Oct 26, 2012 at 7:54 PM, Mitch Claborn <span dir="ltr"><<a href="mailto:mitch_ml@claborn.net" target="_blank">mitch_ml@claborn.net</a>></span> wrote:<br>
<blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote">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?<br>
<br>
SELECT uniqueid, COUNT(*) FROM asterisk_cdr<br>
GROUP BY uniqueid<br>
HAVING COUNT(*) > 2<span><font color="#888888"><br>
<br>
<br>
Mitch</font></span><div><br>
<br>
On 10/26/2012 08:34 AM, Bharat Lalcheta wrote:<br>
<blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote">
<br>
Every CDR has uniqueid/callid generated and unique between all records.<br>
This callid generated when call arrives on system. And logged in CDR<br>
record as well. You can use it in your dialplan to bind with your order like<br>
exten => s,1,Set(ORDERID=${UNIQUEID})<br>
</blockquote>
<br></div><div><div>
--<br>
______________________________<u></u>______________________________<u></u>_________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/<u></u>mailman/listinfo/asterisk-<u></u>users</a><br>
</div></div></blockquote></div><br><br clear="all"><br></div></div><span class="HOEnZb"><font color="#888888">-- <br>Bharat Lalcheta<br>
</font></span><br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br></div>