[Freeswitch-users] call groups - sort order

Michael Collins msc at freeswitch.org
Fri Nov 11 20:14:22 MSK 2011


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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20111111/69137003/attachment.html 


Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list