Does anybody knows how to write a successful SQL query to update a field in the DeviceNumPlanMap table, for example the external phone mask. it needs to be derived from the DN from numplan table and the device name from the device table.
I tried this without success:
update deviceNumPlanMap set E164Mask='9001112222' where DeviceNumPlanMap.fknumplan = numplan.pkid and DeviceNumPlanMap.fkdevice = device.pkid and numplan.dnorpattern='1000' and device.name='SEP001E4A925A13'
update deviceNumPlanMap set E164Mask='9001112222' where fknumplan = (select pkid from numplan where dnorpattern = '1000') AND fkdevice = (select pkid from device where name = 'SEP001E4A925A13')
update deviceNumPlanMap set E164Mask='9001112222' from devicenumplanmap dnmp inner join device dev on dev.pkid = dnmp.fkdevice and dev.name = 'SEP001E4A925A13' inner join numplan np on dnmp.fknumplan = np.pkid and np.dnorpattern = '1001'
I'm not able to access my old voice mail messages all of a sudden. The recording says something like 'the message is currently not available'. This has never happened before in all the years I have been using this system. I have t...