[Freeswitch-users] mod_lcr

[Nandy Dagondon]

it's the digits_prefix in the WHERE clause that's causing the error.

ur question re prefix+digits, it's explained in the Custom SQL portion in
the wiki.

-nandy


On Thu, Jun 10, 2010 at 2:56 PM, Madovsky <infos at madovsky.org> wrote:

>  ok so it needs also the alias l.digits in the condition I think.
> I'm a little confused about digits and prefix.
> if I check a number with the country code is it need to join
> prefix+digits ? how with this kinkd of sql request ?
>
> Thanks
>
> F
>
> ----- Original Message -----
> *From:* Nandy Dagondon <gcd at i.ph>
> *To:* freeswitch-users at lists.freeswitch.org
> *Sent:* Thursday, June 10, 2010 2:44 AM
> *Subject:* Re: [Freeswitch-users] mod_lcr
>
> i think it's a typo. i changed digits_prefix to digits. to be sure, pls
> check the CREATE TABLE entries.
> -nandy
>
>
> On Thu, Jun 10, 2010 at 2:16 PM, Madovsky <infos at madovsky.org> wrote:
>
>>  I'm experimenting with mod_lcr with postgresql (8.4.4)
>> there s an example of custom sql on wiki below :
>>
>>
>>     <profile name="use_prefix">
>>       <param name="custom_sql" value="
>> SELECT l.digits, c.carrier_name, l.${lcr_rate_field}, cg.prefix AS gw_prefix, cg.suffix AS gw_suffix,
>>        l.lead_strip, l.trail_strip, l.prefix, l.suffix, cg.codec, l.cid
>> FROM lcr l
>>      JOIN carriers c ON l.carrier_id=c.id
>>      JOIN carrier_gateway cg ON c.id=cg.carrier_id
>> WHERE c.enabled = '1' AND cg.enabled = '1' AND l.enabled = '1'
>>       AND digits_prefix @> '%q'
>>       AND CURRENT_TIMESTAMP BETWEEN date_start AND date_end
>> ORDER BY digits DESC, ${lcr_rate_field} asc, random();
>>       "/>
>>     </profile>
>>
>> however the query failed cause of digits_prefix field doesn't exist in the table.
>>
>> is it a typo ? or does it need a field concatenation of prefix and digits ?
>>
>> Thanks
>>
>>
>>
>> Franck
>>
>>
>> _______________________________________________
>> 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
>>
>>
>  ------------------------------
>
> _______________________________________________
> 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
>
>
> _______________________________________________
> 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/20100610/a2cbb07c/attachment-0001.html