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