Prakash_Singh

How to get details of who checked out the knowledge store document and when it were checked.

Discussion created by Prakash_Singh on Nov 20, 2014
Latest reply on Nov 20, 2014 by Prakash_Singh

Hi,

 

Can you please let me know how i get the person information, who checked the knowledge store document.

 

I have checked clb_dms_file as well as clb_dms_folder but i am not able to get who checked out the documents or weather it's checked out or not.

 

select clbf.id,clb.id f_id,clb.id||clbf.id uni,

srm2.full_name  Folder_updated_by,

clbf.last_updated_date Folder_updated_date,

 

clb.Name Doc_Name,

srm1.full_name Doc_updated_by,

clb.last_updated_date Doc_updated_date,

(clbf.Path_name || '/' || clbf.name)Doc_Path

from clb_dms_files clb

inner join CMN_SEC_ASSGND_OBJ_PERM perm on perm.OBJECT_INSTANCE_ID=clb.id

inner join cmn_sec_users cmn on cmn.id=perm.principal_id

inner join CLB_DMS_FOLDERS clbf on clbf.id=clb.parent_folder_id

inner join srm_resources srm1 on srm1.user_id=clb.last_updated_by

inner join srm_resources srm2 on srm2.user_id=clbf.last_updated_by

where path_name='/Root/DMS/KS/Test-Nov' and cmn.id=@WHERE:PARAM:USER_ID@

 

Please let me know your opinions.

 

Thank you.

Outcomes