Question7Replies65Views RaviY230 Member since 2018 22 posts HCL Technologies Ltd Posted: 9 months agoLast activity: 9 months ago Solved How can i get Locked CasesHi Team,In bulk actions i am getting cases based on filter conditions.That results i am displaying with grid layout.Now my requirement is i need to add on other column as Locked, under Locked column i have to show that case is locked or not.If case is locked we need to display "Locked" other wise we need to display Empty value " "Thanks,Ravi***Moderator Edit-Vidyaranjan: Updated Platform Capability*** Case Management ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Posted: 9 months agoBhavya_Incessant Incessant Technologies replied to RaviY230Hi You can do a join with the lock table to get the matching record. Then in you RD use the Case when function in the Column Source. If the value exist in locks table return Locked or else NULL. Hope this helps. Regards Bhavya Posted: 9 months agoRaviY230 HCL Technologies Ltd replied to Bhavya_IncessantHi Bhavya, How can i store that value into (Converting to grid) section from Report definition. And also value exit ( how can i check / which property i have to use to check). Can you please explain me step by step. Posted: 9 months agoMarcLasserre_GCS PEGA replied to RaviY230Hello, Well I guess the case could be locked from a second to another so what is the point of displaying such information? As soon as you will display it the content might be completely incorrect because lock has been released or taken. Posted: 9 months agoGopinath.A S & P LTD replied to RaviY230Hi RaviY230, Please join System-Locks class with your class instance to get whether the case is locked or not. Use lock-handle as a join this will provide you locked cases information. DB table name : pr_sys_locks Thanks, Gopi Posted: 9 months agoRaviY230 HCL Technologies Ltd replied to Gopinath.AHi Gopi, It's working fine in Report definition. But in UI it's not displaying (which property i have to give in section grid layout). Accepted Solution Posted: 9 months agoRaviY230 HCL Technologies Ltd replied to RaviY230Hi Team, I got the solution, I used "pyTextValue" property in section it's working fine. Thanks, Ravi Posted: 9 months agoLochan_DV MOD replied to RaviY230Thanks for the update. We have marked this post as Answered.