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