Question
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***
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.
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.
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
Hi 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
Hi Team,
I got the solution, I used "pyTextValue" property in section it's working fine.
Thanks,
Ravi
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