Synopsis
Realtime Data Rewrite
Description
Use the RealTime config handler system to update a value
RealTimeUpdate(<family>|<colmatch>|<value>|<newcol>|<newval>)
The column <newcol> in ‘family’ matching column <colmatch>=<value> will be updated to <newval>
For example assume the following:
extconfig.conf
sipusers => mysql,asterisk,asterisk_sip
extensions.conf
exten => 11223344,n,RealTimeUpdate(sipusers|name|44332211|username|bob)
This will execute the following SQL on the asterisk_sip table in the asterisk database:
UPDATE asterisk_sip SET username = ‘bob’ WHERE name = ‘44332211’
Asterisk | Applications | Functions | Variables | Expressions | Asterisk FAQ