Question
YuniQ
IN
Last activity: 8 Mar 2024 9:52 EST
where is the SLA information stored?
What database query can be used to determine which stage has the SLA set in Pega, and where is the SLA information stored?
***Edited by Moderator Marije to change type from Pega Academy to Product***
Accepted Solution
Updated: 25 Mar 2024 7:24 EDT
Cognizant
IN
@NagaRajan M in clipboard you can view your SLA name, SLA Deadline,SLA GOAL as the pyWorkPage has these properties stored whenever you create a case that has SLA configured.And similar for Stage name as well as you can find from
Megha007 's answer.Just Expand the pyWorkPage and you will be able to see .pxFlow embedded inside it however to query the db for an SLA I feel this is not available yet .As all the details you will be getting from pyWorkPage itself.Hope it helps.
Updated: 7 Mar 2024 10:43 EST
Pegasystems Inc.
CA
The SLA events are stored in pegadata.pr_sys_queue_sla.
class name: System-Queue-ServiceLevel
YuniQ
IN
Thanks for your replay. i need to know in the DataBase How can I retrieve the name of the stage where the SLA is set in the Pega database? I found a table called pr_assign, and it seems like the pxstagelabel column might hold that value. Could you confirm if this is the correct column for retrieving the stage name?
Thankyou!
NagaRajan
Updated: 8 Mar 2024 9:52 EST
Pegasystems Inc.
CA
1. Join SLA table (pegadata.pr_sys_queue_sla) and Assignment table using pxAssignmentHandle(sla) and pzInsKey(Assignment) --> to get the pzInsKey of Work Instance. 2. Join the Assignment table and Work table using pzInsKey(Work) and pxRefObjectKey(Assignment) -> to get the pxCurrentStageLabel
I hope this helps!
Maantic Technologies Pvt Ltd
US
Hi @NagaRajan M
Hope you are doing well.
The Stage-level SLAs will be stored here: pyWorkPage.pxFlow(pzInternalStageFlow).
Thank You!
Megha Maji
YuniQ
IN
@Megha007 Thanks for your replay. i need to know in the DataBase How can I retrieve the name of the stage where the SLA is set in the Pega database? I found a table called pr_assign, and it seems like the pxstagelabel column might hold that value. Could you confirm if this is the correct column for retrieving the stage name?
Thankyou!
NagaRajan
Accepted Solution
Updated: 25 Mar 2024 7:24 EDT
Cognizant
IN
@NagaRajan M in clipboard you can view your SLA name, SLA Deadline,SLA GOAL as the pyWorkPage has these properties stored whenever you create a case that has SLA configured.And similar for Stage name as well as you can find from
Megha007 's answer.Just Expand the pyWorkPage and you will be able to see .pxFlow embedded inside it however to query the db for an SLA I feel this is not available yet .As all the details you will be getting from pyWorkPage itself.Hope it helps.