Trigger on update when changed only desired XML tag.

• lada1984

  SSC Enthusiast

  Points: 112

  More actions

  March 6, 2023 at 11:15 pm

  #4157467

  Hello!

  I have a task to configure for the Skype for business database logging of user status changes (Available/Away/Offline/etc).

  i found source for this data in XML field with content like:

  <state xsi:type="aggregateState" lastActive="2023-03-06T11:40:14" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/2006/09/sip/state"><availability>15500</availability><delimiter xmlns="http://schemas.microsoft.com

  can you help me with trigger, that will log to history table status change only if was changed XML substring like: <availability>15500</availability> -> <availability>19000</availability> or <availability>15500</availability> -> <availability>13000</availability>

  but not:

  <state xsi:type="aggregateState" lastActive="2023-03-06T11:40:14" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/2006/09/sip/state"><availability>15500</availability><delimiter xmlns="http://schemas.microsoft.com

  ->

  <state xsi:type="aggregateState" lastActive="2023-03-07T11:40:14" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/2006/09/sip/state"><availability>15500</availability><delimiter xmlns="http://schemas.microsoft.com

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  March 8, 2023 at 12:10 am

  #4157977

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• March 13, 2023 at 7:42 am

  This was removed by the editor as SPAM

• October 10, 2023 at 3:31 pm

  This was removed by the editor as SPAM