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@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@i.ph> *To:* freeswitch-users@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@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@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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org