Job that will change the Case Stage in Breached SLA or SLA Critical Period

[Pascaru_Tudor]

Hi team,

I'm planning to write a Job that will change the Case Stage in "Breached SLA" or "SLA Critical Prerioud" depending on SLA status.
The problem that I'm facing is that I can't find any reliable data in this regard.

For example the flag from the image is always 2, in both cases. I mean for the alert with expired SLA and for other with unexpired SLA.

siemplify_system_db."AlertSlaActions" -> does not provide any useful info
siemplify_system_db."CaseSlas" -> it's an empty table

I see in the dashboard configuration a way to filter by SLA status, could you please advice me where the Dashboard's code takes this information?

I'm using Siemplify Version 5.6.2.96

Support ticket ID -> 10786

[Pascaru_Tudor]

View files in slack

[John_DePalma]

I am not using SLA in my environment, but from what I understand you need to configure the SLA parameters first

https://hostname/#/main/settings/sla

Is this configured on your end and still you get a 2?

[John_DePalma]

I see all of my cases have a 2, but I don't use sla at all so that is expected. If configured, I would expect to see something for the slaExpirationTime field, which is empty in your screenshot

https://www.manula.com/manuals/siemplify/user-guide/5.6.x/en/topic/sla

[Pascaru_Tudor]

Hi John,

you can test it by yourself very quickly, just enable SLA for your dev Environment and do some testes.

The idea is that this information exists somewhere for sure, because in the Dashboard menu you can filter by SLA, but it looks like I miss something...

[Tomtomfridman]

Hi @Pascaru_Tudor ,
Thank you for writing here. We consult with the technical team, and it seems that there may be a bug. We will continue checking it and let you know about that soon.

[Pascaru_Tudor]

Hi team,

it think the next field will be enough for my Use Case:

SiemplifyJob()._get_case_by_id( case_id ).get('sla_expiration_unix_time')

[Pascaru_Tudor]

it shows the time when the SLA will expire for that specific CaseId