Hi Victor thank you for you answer.
If i have:
<profile name="pg_prefix2">
<param name="order_by" value="rate,quality,reliability"/>
<param name="export_fields"
value="nibble_account,nibble_rate,lowbal_amt,nobal_amt,lcr_carrierid_field,tarifa"/>
<param name="custom_sql" value="
SELECT l.digits AS lcr_digits,
c.id AS lcr_carrierid_field,
c.carrier_name AS lcr_carrier_name,
l.${lcr_rate_field} as lcr_rate_field,
cg.prefix AS lcr_gw_prefix, cg.suffix AS lcr_gw_suffix,
l.lead_strip AS lcr_lead_strip, l.trail_strip AS lcr_trail_strip,
l.prefix AS lcr_prefix, l.suffix AS lcr_suffix,
a.id AS nibble_account,
l.${lcr_rate_field} AS nibble_rate,
a.warn_limit AS lowbal_amt,
a.nobal_limit AS nobal_amt,
a.id_tarifa AS tarifa
FROM lcr l
JOIN carriers c ON l.carrier_id=c.id
JOIN carrier_gateway cg ON c.id=cg.carrier_id
JOIN auth_user a ON a.id = ${accountcode}
JOIN tarifas t ON t.id = a.id_tarifa
WHERE c.enabled = '1' AND cg.enabled = '1' AND l.enabled = '1'
AND
l.digits @> '${lcr_query_digits}'
AND CURRENT_TIMESTAMP BETWEEN date_start AND date_end
ORDER BY digits DESC, ${lcr_rate_field}, random();
"/>
</profile>
How i can set variable tarifa in my dialplan like
<action application="lcr" data="$1
pg_prefix2"/>
<action application="set" data="tarifa=${tarifa}"/>
<action application="bridge" data="${lcr_auto_route}"/>
Regards
On Saturday, November 16, 2013 2:58 PM, Victor Chukalovskiy <victor.chukalovskiy@gmail.com> wrote: