[Freeswitch-users] Issue with database updates

[Michael Jerris]

it updates them with the values in channel vars.

> On Oct 8, 2017, at 2:13 PM, Rick Jarvis <rick at 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 at vallimamod.org <mailto:vma at 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 at sipsolutions.fr <mailto: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 <mailto: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/20171009/45fd22e4/attachment.html>