<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Hi Richards,<br>
<br>
No, the module does not allow such extensions, but considering
that the module simply hides a DB query, you can perform your
enhanced query directly from script using avp_db_query().<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 05.05.2016 16:54, Richard Robson
wrote:<br>
</div>
<blockquote
cite="mid:ead1c543-0bd8-775f-4ee6-ecdf413d3e41@greenlightcrm.com"
type="cite">
<meta http-equiv="content-type" content="text/html;
charset=windows-1252">
<p>Is it possible to add an extra field to the DB and have it
read?</p>
<p><br>
</p>
<p>The example is as follows. I'd Like an account number written
to the ACC table for inbound calls on a proxy. The number would
be called and presented to the proxy and via the dbaliases
table, diverted to the correct destination ( a customers PBX).
These will be recorded via the ACC Module. Would it be possible
to read a custom field from the dbalias table and add this to
the ACC via an AVP. I have the account number written as a
custom field in the ACC for the outbound calls from
authentication and sip headers via an AVP so that is not the
problem. The problem is tying the inbound number to the relevant
account and have that written the the AVP and thence onto the
ACC table.</p>
<p><br>
</p>
<p>I hope this makes sense.<br>
</p>
<p><br>
</p>
Regards,<br>
<pre class="moz-signature" cols="72">--
Richard Robson
Greenlight Support
01382 843843
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:support@greenlightcrm.com">support@greenlightcrm.com</a></pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>