Usecase: There are many users who have left the organization and the documents which are checked out by them and still locked. How can I find them all and unlock them.
Solution:
1. Find the list of documents which are checked out by a user who is inactive in the system. This can be achieved through the below DQL query.select * from dm_document where r_lock_owner in (select user_name from dm_user where user_state = 1)
2. From the extracted list now the documents has to be unlocked through API command.
unlock,c,<r_object_id of the document>
3. when the list is very big then you can use the excel to generate the API commands using concatenation function.
