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 ----