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


----