Thursday, 27 October 2016

Get login ticket

Usecase: The user has some issue with his account, how can a admin login to his account to reproduce the issue.

Solution:

The admin can use dm ticket to login to the user account to reproduce the issue.

API: getlogin,c,<user login name>
1. Run the above API to get the ticket 
2. Paste the ticket data into the password field. 

Request for re-indexing the document for search

Usecase: The document is not appearing in the search results.

Solution:

There can be two reasons for the document to not to show up in the results.
1. The document is not indexed- you can reindex the document using the below API:

queue,C,<Obj Id of document>,dm_fulltext_index_user,dm_force_ftindex

2. The user does not have the access to the document. Please check the permissions of the user in the docbase. 

Tuesday, 25 October 2016

Unlock all the documents which are checked out by a inactive user

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. 

API to Unlock the checked out documents

Use case : How can I cancel checkout(Unlock) the document  which is locked by another user.


Solution: The user can execute the below API command to unlock the document. 


unlock,c,<r_object_id>


The above is the api command to unlock the document which is checked out by another user, to execute the command the user must have minimum of Administrator access.