[Freeswitch-users] Issue with database updates

[Vallimamod Abdullah]

Hi,

I am not sure how you are updating these columns but if you are doing it directly through sql, I don't think it's the correct way.
To set or update a value on a "presence data" column, you have to define or update a channel variable with the same name as the column. If there is no variable defined, the corresponding column will be set to NULL on the state change.

Hope this helps.

Best Regards,
-- 
Vallimamod Abdullah
SIP Solutions
vma at sipsolutions.fr
tel: +33 6 62 60 68 97
.

> On 8 Oct 2017, at 16:50, Rick Jarvis <rick at magicmail.mooo.com> wrote:
> 
> Is there any reason why FS iterates through all the fields in the channels table, when it updates a field? I’ve created some custom columns (as per https://freeswitch.org/confluence/display/FREESWITCH/Variable+presence+data+cols <https://freeswitch.org/confluence/display/FREESWITCH/Variable+presence+data+cols>) but the values I’m writing to my new columns are being overwritten when FS changes the channel state - it appears from the logs that this is due to FS reading the values from the table, and then setting every column (including my custom fields) when it then updates … to me this is counter-intuitive as far as SQL goes!?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20171008/e472eacb/attachment.html>