VERIFIED SOLUTION i

EngageOne: How to know dependencies associated with a template


 

There could be a scenario where objects or documents associated with the template needs to be retrieved. There are queries (select) which can be executed on EngageOne repository to know the results. For example :
  • Query, when executed, gives the list of templates with creator name and access rights​
select 
   dr.FR_Name as 'TemplateName', 
   dr.Create_User_ID as 'CreatedBy', 
   fa.Resource_ID as 'Access' 
from 
   OCM_TEMPLATE ot
   join Doc_Resources dr on ot.RESOURCE_ID = dr.Doc_Resource_ID
   join File_ACL fa on fa.Doc_Resource_ID = dr.Doc_Resource_ID
  • Query, when executed, gives Document Classes connected to templates
select 
   Name 
from 
   Doc_Types 
where 
   Doc_Types_ID in
      (select DOC_Types_ID from Doc_Res_Types where Doc_Resource_ID in
      (select Doc_Resource_ID from Doc_Resources where FR_Name = '<TEMPLATE_NAME>'));
 
UPDATED:  March 24, 2017