Re: [OpenSIPS-Users] adding extra fields to Alias_DB

2016-05-05 Thread Bogdan-Andrei Iancu 

Hi Richards,

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().


Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 05.05.2016 16:54, Richard Robson wrote:


Is it possible to add an extra field to the DB and have it read?


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.



I hope this makes sense.


Regards,
--
Richard Robson
Greenlight Support
01382 843843
supp...@greenlightcrm.com


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] adding extra fields to Alias_DB

2016-05-05 Thread Richard Robson 

  
  
Is it possible to add an extra field to the DB and have it read?


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.


I hope this makes sense.



Regards,
-- 
Richard Robson
Greenlight Support
01382 843843
supp...@greenlightcrm.com
  


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users