[Freeswitch-users] Mod LCR SQL sub-query for better routing

[Raymond Chandler]

On 12/12/2013 02:42 PM, Victor Chukalovskiy wrote:
> Hello,
>
> For those interested, I added a piece to mod lcr wiki. It makes sorting
> / routing logic better than default logic:
>
> http://wiki.freeswitch.org/wiki/Mod_lcr#Custom_SQL_with_sub-query_-_for_real-life_ratesheet_complexities
>
> Why it helps:
>
> Rates rates can often be given both on per-NPA or per-NPANXX level
> depending on the carrier and on the NPA. Moreover, some carriers may
> have NPANXX rate lower than the corresponding NPA rate, while others
> will have it inverse. Neither simple ORDER BY rate, prefix; nor ORDER BY
> prefix, rate; give the truly cheapest route. The LCR logic should be
> two-step process to accommodate this.
>
> Cheers,
> -Victor
Unless I misunderstand what you're saying, this is what the 
reorder_by_rate param does.

You'll always want to pick the longest digit match per carrier. Then you 
probably want to grab the cheapest overall rate of the matches you got back.

-Ray

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20131213/27914c7e/attachment.html