March 6, 2023 at 11:15 pm
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
March 8, 2023 at 12:10 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy