[OpenSIPS-Users] AVP_DB_Querry transformation question

[Travis Manson-Drake]

That did it!

Thank you!

From: users-bounces at lists.opensips.org [mailto:users-bounces at lists.opensips.org] On Behalf Of jarrod at unixc.org
Sent: Monday, January 25, 2016 3:11 PM
To: OpenSIPS users mailling list <users at lists.opensips.org>
Subject: Re: [OpenSIPS-Users] AVP_DB_Querry transformation question

try $(fU{s.escape.common})

On Jan 25, 2016, at 4:09 PM, Travis Manson-Drake <travism at simplybits.com<mailto:travism at simplybits.com>> wrote:

Hello everyone,

I can’t seem to find any documentation on how to format my Query while using the {s.escape.common} transformation.

I tried setting it up as follows:


select MAC FROM `phone_registrations` where auth_userid = '$fU{s.escape.common}'))", "$avp(PBX)")

however the query just returns the value PV $fU with {s.escape.common} in the return, for example 7117test{s.escape.common}

where should I apply the transformation? Can someone give me an example?

Thank you for your time.

Travis Manson-Drake
Voice Systems Analyst


Simply Bits, LLC
T: 520.545.0311  F: 520.545.7252
E: email at simplybits.com<mailto:email at simplybits.com>
5225 N. Sabino Canyon Road
Tucson, AZ 85750
Support Hotline: 520.545.0333



_______________________________________________
Users mailing list
Users at lists.opensips.org<mailto:Users at lists.opensips.org>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20160125/06051532/attachment.htm>