If you need extra channel variables then your best bet would be ESL, where you can 'show calls' / 'show channels' and then uuid_getvar to get the extra variables.

On 30 July 2015 at 09:25, John Nash <john.nash778@gmail.com> wrote:

Thank you everyone. I also need to fetch some extra channel variables (Which are set in dial plans and some message headers) as columns, SQLLite stores only fixed number of columns right?

On Thu, Jul 30, 2015 at 1:48 PM, Giovanni Maruzzelli <gmaruzz@gmail.com> wrote:

Mod-rpc-xml has an embedded http server, you can post and get "show calls" to it, and it will return a nice formatted html table :)

sent from my mobile,
Giovanni Maruzzelli
cell: +39 347 266 56 18

On Jul 30, 2015 9:09 AM, "Sergey Safarov" <s.safarov@gmail.com> wrote:

You can call "show calls" via ESL or mod_erlang and parse output.

Sergey

On Thu, Jul 30, 2015 at 9:34 AM, John Nash <john.nash778@gmail.com> wrote:

Is there any way of storing "live" calls (Ongoing calls) in DB to a specific table? where we can fetch these records and display in web page?

I planned to store calls using some lua script hooks but cli command show calls already shows calls which we can use?

_________________________________________________________________________
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

_________________________________________________________________________
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

_________________________________________________________________________
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

_________________________________________________________________________
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

_________________________________________________________________________
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