Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

7
Replies
922
Views
RaviY230 Member since 2018 47 posts
HCL Technologies Ltd
Posted: Dec 16, 2019
Last activity: Dec 18, 2019
Closed
Solved

How can i get Locked Cases

Hi 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***

To see attachments, please log in.
Case Management

Posted: 5 years ago

Hi

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

To see attachments, please log in.
Posted: 5 years ago

Hi 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.

 

 

To see attachments, please log in.
Posted: 5 years ago

Hello, 

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.

To see attachments, please log in.
Posted: 5 years ago

Hi @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

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice