CEL DB column alias


I would like to store the CEL record in a mysql database. The odbc-mysql connection work well, but i can’t figure out how can I store the CALLERID variables.

For example:
Master.csv => …,${CSV_QUOTE(${CALLERID(name)})},…

connection = odbc-mysql
table = cel
alias => ??? => c_name

What have to write into the alias’s “CEL field”?


You don’t need to use alias just to save a value into an RDBMS.

Entry in func_odbc.conf:

[Save_SomeValue] dsn=your_mysql_dsn prefix=CEL writesql=UPDATE some_table SET some_column=${SQL_ESC(${ARG}1)};

Then invoke in the dialplan as follows: