46
Yate users hangout place / Re: Routing a call, using a database ( register.conf / PHP ) Over 2 different Lines
« on: October 03, 2017, 01:41:11 AM »
The format of what your pgsql procedure is not right for routing. You return multiple rows with format:
param_name=param_value
This is not correct. You need to have column name = param_name and value is the one in a row. The correct format would be
param_name1 | param_name2 | param_name3 | ...
row1_value1 | row1_value2 | row1_value3 | ...
row2_value1 | row2_value2 ...
location=name_of_param that holds the actual location (Ex: param_name2)
The other columns will be added as parameters to the call.route message.
By default only the first row of result will matter, unless you activate fallback routing in register.conf
param_name=param_value
This is not correct. You need to have column name = param_name and value is the one in a row. The correct format would be
param_name1 | param_name2 | param_name3 | ...
row1_value1 | row1_value2 | row1_value3 | ...
row2_value1 | row2_value2 ...
location=name_of_param that holds the actual location (Ex: param_name2)
The other columns will be added as parameters to the call.route message.
By default only the first row of result will matter, unless you activate fallback routing in register.conf