Asterisk cmd RealTimeUpdate

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

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

Created by: kjcsb, Last modification: Fri 05 of Nov, 2010 (22:45 UTC) by admin
Please update this page with new information, just login and click on the "Edit" or "Discussion" tab. Get a free login here: Register Thanks! - Find us on Google+