How to set Has Breached SLA to true based on the business elapsed percentage.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-28-2024 07:39 AM
Hello Everyone,
I have a requirement where I need to set the Has Breached to true for with conditions for Problem SLA as below:
Conditions: SLA - Problem, Business elapsed Percentage - >95 then Has breached to True.
I have written a before update BR on Task_sla table with the above conditions and in the script
But its not working, can anyone help me in achieving this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-28-2024 07:46 AM
Hi @Supriya KM,
You can do it but not recommended for such custom logic in running SLA instanct, becuase 5% business duration still valid.
If you try to update Has Breach via external logic ( like BR ) , the core logic will replace that change.
Work around : You can introduce new SLA for this 95% and make that SLA Has Breach = true.
-Thanks,
AshishKM
Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-28-2024 07:57 AM
Hello Ashish,
Thanks for the reply.
But this is the custom field we have created not the OOB field of Has breach in the task table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-28-2024 11:00 PM
Hi @Supriya KM ,
Why make it breached at 95% instead of having it breached at the actual time that you have configured? What is the business reason here?
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/