[Freeswitch-users] mod_lcr

[Nandy Dagondon]

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