Hi list, from the WIKI page: group call:groupname[:order] How are the entries sorted ? How can I make sure the list returned by 'group call' is sorted in a certain order ? I want to make sure a certain extension is ringed first, but sometimes another extension is listed first. Thanks and best regards Stefan
Which wiki page is this? -MC On Wed, Nov 9, 2011 at 12:58 AM, Weigel, Stefan < Stefan.Weigel@allianz-warranty.com> wrote:
Hi list,****
** **
from the WIKI page:****
** **
group call:groupname[:order]****
** **
How are the entries sorted ? How can I make sure the list returned by ‘group call’ is sorted in a certain order ? I want to make sure a certain extension is ringed first, but sometimes another extension is listed first. ****
** **
** **
Thanks and best regards****
** **
Stefan****
** **
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
Hi Michael, http://wiki.freeswitch.org/wiki/Mod_db Best regards, Stefan Von: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] Im Auftrag von Michael Collins Gesendet: Donnerstag, 10. November 2011 19:24 An: FreeSWITCH Users Help Betreff: Re: [Freeswitch-users] call groups - sort order Which wiki page is this? -MC On Wed, Nov 9, 2011 at 12:58 AM, Weigel, Stefan <Stefan.Weigel@allianz-warranty.com<mailto:Stefan.Weigel@allianz-warranty.com>> wrote: Hi list, from the WIKI page: group call:groupname[:order] How are the entries sorted ? How can I make sure the list returned by 'group call' is sorted in a certain order ? I want to make sure a certain extension is ringed first, but sometimes another extension is listed first. Thanks and best regards Stefan FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org<mailto: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
Stefan, I looked in mod_db.c and if I understand what I'm reading there isn't an explicit sort when pulling this data out of the database table. Here's the line in question: sql = switch_mprintf("select url,'%q' from group_data where groupname='%q'", how, argv[1]); I would recommend that you log in to sqlite3 and issue this command manually and see what you get. I don't know enough about SQLite to be able to tell you if it enforces any kind of order when doing a select on a table when there's no ORDER BY clause. -MC On Thu, Nov 10, 2011 at 11:23 PM, Weigel, Stefan < Stefan.Weigel@allianz-warranty.com> wrote:
Hi Michael,****
** **
http://wiki.freeswitch.org/wiki/Mod_db****
** **
** **
Best regards,****
** **
Stefan****
** **
** **
*Von:* freeswitch-users-bounces@lists.freeswitch.org [mailto: freeswitch-users-bounces@lists.freeswitch.org] *Im Auftrag von *Michael Collins *Gesendet:* Donnerstag, 10. November 2011 19:24 *An:* FreeSWITCH Users Help *Betreff:* Re: [Freeswitch-users] call groups - sort order****
** **
Which wiki page is this?****
-MC****
On Wed, Nov 9, 2011 at 12:58 AM, Weigel, Stefan < Stefan.Weigel@allianz-warranty.com> wrote:****
Hi list,****
****
from the WIKI page:****
****
group call:groupname[:order]****
****
How are the entries sorted ? How can I make sure the list returned by ‘group call’ is sorted in a certain order ? I want to make sure a certain extension is ringed first, but sometimes another extension is listed first. ****
****
****
Thanks and best regards****
****
Stefan****
****
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
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.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
You can of course just add a order by to the statement in the source :) Am 11.11.2011 um 18:14 schrieb Michael Collins:
Stefan,
I looked in mod_db.c and if I understand what I'm reading there isn't an explicit sort when pulling this data out of the database table. Here's the line in question:
sql = switch_mprintf("select url,'%q' from group_data where groupname='%q'", how, argv[1]);
I would recommend that you log in to sqlite3 and issue this command manually and see what you get. I don't know enough about SQLite to be able to tell you if it enforces any kind of order when doing a select on a table when there's no ORDER BY clause.
-MC
On Thu, Nov 10, 2011 at 11:23 PM, Weigel, Stefan <Stefan.Weigel@allianz-warranty.com> wrote: Hi Michael,
http://wiki.freeswitch.org/wiki/Mod_db
Best regards,
Stefan
Von: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] Im Auftrag von Michael Collins Gesendet: Donnerstag, 10. November 2011 19:24 An: FreeSWITCH Users Help Betreff: Re: [Freeswitch-users] call groups - sort order
Which wiki page is this?
-MC
On Wed, Nov 9, 2011 at 12:58 AM, Weigel, Stefan <Stefan.Weigel@allianz-warranty.com> wrote:
Hi list,
from the WIKI page:
group call:groupname[:order]
How are the entries sorted ? How can I make sure the list returned by ‘group call’ is sorted in a certain order ? I want to make sure a certain extension is ringed first, but sometimes another extension is listed first.
Thanks and best regards
Stefan
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
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.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
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.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
Michal Bielicki Geschäftsführer / CEO Seventh Signal Ltd. & Co. KG Weigandufer 45, Büro 115, D-12059 Berlin Voice: +49 30 60988730 Amtsgericht Charlottenburg HRA 44413 B Ust.-ID: DE266981999 Geschäftsführer: Michal Bielicki Persönlich Haftende Gesellschafterin: Seventh Signal Ltd, 69 Great Hampton St. Birmingham, B18 6EW, GB, Company Nr.: 06889439 WWW.: http://www.seventhsignal.de ----
participants (3)
-
Michael Collins
-
Michal Bielicki
-
Weigel, Stefan