it updates them with the values in channel vars.
On Oct 8, 2017, at 2:13 PM, Rick Jarvis <rick@magicmail.mooo.com> wrote:
I had resorted to updating the table directly through SQL as FS doesn't appear to dynamically update the table if I use uuid_setvar :/
On 8 Oct 2017, at 19:05, Vallimamod Abdullah <vma@vallimamod.org <mailto:vma@vallimamod.org>> wrote:
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@sipsolutions.fr <mailto:vma@sipsolutions.fr> tel: +33 6 62 60 68 97 .
On 8 Oct 2017, at 16:50, Rick Jarvis <rick@magicmail.mooo.com <mailto:rick@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+... <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!?