[Freeswitch-users] Have same UUID in all call legs

Ognjen Seslija oseslija at gmail.com
Wed Jul 6 01:09:27 MSD 2016


SELECT
a.start_stamp,a.accountcode,a.caller_id_number,a.destination_number,a.hangup_cause,a.duration,a.sip_hangup_disposition
as aleg_shd,b.sip_hangup_disposition as bleg_shd FROM pstn_cdr a INNER JOIN
pstn_cdr b ON a.uuid=b.originating_leg_uuid


On Tue, Jul 5, 2016 at 10:56 PM, Victor Chukalovskiy <
victor.chukalovskiy at gmail.com> wrote:

> Good day, the scenario is that I have one a-leg and numerous b-legs for
> each call in my CDR. I need a simple way of selecting all leg for the
> same call at once
>
> Previously I've relied on things like ${bleg_uuid}, ${last_bridge_to}
> etc. But it in the end it involves a 2-step process or inner join to put
> a- and b- legs together.
>
> What would really help is if there is a way to have an extra variabvle
> which will have the same value for every leg of the same call. Can
> someone tell me if such var already exists, or if I need to generate it
> myself and export to both a- and b- legs?
>
> Thank you,
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20160705/c2cef84b/attachment.html 


Join us at ClueCon 2016 Aug 8-12, 2016
More information about the FreeSWITCH-users mailing list