[Freeswitch-users] call groups - sort order

[Michal Bielicki]

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 at allianz-warranty.com> wrote:
> Hi Michael,
> 
>  
> 
> http://wiki.freeswitch.org/wiki/Mod_db
> 
>  
> 
>  
> 
> Best regards,
> 
>  
> 
> Stefan
> 
>  
> 
>  
> 
> Von: freeswitch-users-bounces at lists.freeswitch.org [mailto:freeswitch-users-bounces at 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 at 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 at 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 at freeswitch.org
> http://www.freeswitchsolutions.com
> 
> 
> 
> 
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
> 
> FreeSWITCH-users mailing list
> FreeSWITCH-users at 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 at freeswitch.org
> http://www.freeswitchsolutions.com
> 
> 
> 
> 
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
> 
> FreeSWITCH-users mailing list
> FreeSWITCH-users at 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



----

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20111112/9ca18cf7/attachment-0001.html