<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
@font-face
{font-family:"Segoe UI Semibold";
panose-1:2 11 7 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">That did it!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Thank you!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> users-bounces@lists.opensips.org [mailto:users-bounces@lists.opensips.org]
<b>On Behalf Of </b>jarrod@unixc.org<br>
<b>Sent:</b> Monday, January 25, 2016 3:11 PM<br>
<b>To:</b> OpenSIPS users mailling list <users@lists.opensips.org><br>
<b>Subject:</b> Re: [OpenSIPS-Users] AVP_DB_Querry transformation question<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">try $(fU{s.escape.common})<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">On Jan 25, 2016, at 4:09 PM, Travis Manson-Drake <<a href="mailto:travism@simplybits.com">travism@simplybits.com</a>> wrote:<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Hello everyone,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">I can’t seem to find any documentation on how to format my Query while using the {s.escape.common} transformation.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">I tried setting it up as follows:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">select MAC FROM `phone_registrations` where auth_userid = '$fU{s.escape.common}'))", "$avp(PBX)")<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">however the query just returns the value PV $fU with {s.escape.common} in the return, for example 7117test{s.escape.common}<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">where should I apply the transformation? Can someone give me an example?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Thank you for your time.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></p>
</div>
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" width="312" style="width:3.25in">
<tbody>
<tr>
<td width="308" valign="top" style="width:231.0pt;padding:0in 0in 0in 0in">
<div>
<p class="MsoNormal" style="mso-line-height-alt:11.55pt"><span style="font-size:13.0pt;font-family:"Segoe UI",sans-serif;color:#1884C6;letter-spacing:-.75pt">Travis Manson-Drake<br>
</span><span style="font-size:13.0pt;font-family:"Segoe UI",sans-serif;color:#F79321;letter-spacing:-.75pt">Voice Systems Analyst</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p></o:p></span></p>
</div>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;display:none"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="1" cellspacing="3" cellpadding="0" width="312" style="width:3.25in;border:none;border-top:solid windowtext 2.25pt">
<tbody>
<tr style="height:1.35pt">
<td width="308" style="width:231.0pt;border:none;padding:.75pt .75pt .75pt .75pt;height:1.35pt">
<div>
<p class="MsoNormal" style="mso-line-height-alt:11.55pt"><span style="font-size:13.0pt;font-family:"Segoe UI",sans-serif;color:#1884C6;letter-spacing:-.75pt">Simply Bits, LLC<br>
</span><span style="font-size:10.0pt;font-family:"Segoe UI",sans-serif;letter-spacing:1.0pt">T:<span class="apple-converted-space"><span style="color:#1F497D"> </span></span><span style="color:#1B84C7">520.545.0311 <span class="apple-converted-space"> </span></span><span style="color:#2D2D2D">F:</span><span class="apple-converted-space"><span style="color:#1F497D"> </span></span><span style="color:#1B84C7">520.545.7252<br>
</span>E:<span class="apple-converted-space"><span style="color:#1F497D"> </span></span></span><a href="mailto:email@simplybits.com"><span style="font-size:10.0pt;font-family:"Segoe UI",sans-serif;color:#0563C1;letter-spacing:1.0pt">email@simplybits.com</span></a><span style="font-size:10.0pt;font-family:"Segoe UI",sans-serif;color:#1B84C7;letter-spacing:1.0pt"> <br>
</span><span style="font-size:10.0pt;font-family:"Segoe UI",sans-serif">5225 N. Sabino Canyon Road<br>
Tucson, AZ 85750<br>
</span><span style="font-size:10.0pt;font-family:"Segoe UI Semibold",sans-serif">Support Hotline: 520.545.0333</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p></o:p></span></p>
</div>
</td>
</tr>
</tbody>
</table>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif">_______________________________________________<br>
Users mailing list<br>
</span><a href="mailto:Users@lists.opensips.org"><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:#954F72">Users@lists.opensips.org</span></a><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif"><br>
</span><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:#954F72">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</span></a><o:p></o:p></p>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>