Updating BLF Label when extension CallerID name changes

[dougs]

How do you get the BLF labels to update when you change the name of the CallerID on the extension?

 

[dougs]

I accomplished this by adding a cron job to run the following SQL update every minute:

update v_device_keys dk set device_key_label = ex.effective_caller_id_name from v_extensions ex where ex.domain_uuid = dk.domain_uuid AND ex.extension = dk.device_key_value

 

[Len]

Thx for sharing. Good pointer for similar changes

 

[dougs]

Yeah, I was able to get it to update all the device key labels when you change a person's effective caller ID through the php on the extension's page, but that only works when you've already got that extension assigned as a key on a device. I'm not very good at php and gave up trying to get it to work on the device's page and decided to just do it through SQL.