Upgrade 3CX to v18 and get it hosted free!

Asterisk cmd RealTimeUpdate

Author image

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


Article Reviews

Write a Review

Your email address will not be published. Required fields are marked *

Required Field. Minimum 5 characters.

Required Field. Minimum 5 characters, maximum 50.

Required field.There is an error with this field.

Required Field.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

There are no reviews for this article. Be the first one to write a review.
Get 3CX - Absolutely Free!
Link up your team and customers Phone System Live Chat Video Conferencing

Hosted or Self-managed. Up to 10 users free forever. No credit card. Try risk free.

3CX
A 3CX Account with that email already exists. You will be redirected to the Customer Portal to sign in or reset your password if you've forgotten it.