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@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@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@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org