1. List attributes of a Custom Type
SELECT distinct attr_name, type_name FROM dmi_dd_attr_info WHERE attr_name not in (SELECT attr_name FROM dmi_dd_attr_info WHERE type_name=’dm_document’) and type_name = ‘yourcustom_type’
2. Select form templates
select * from dm_xfm_form
select r_object_id, object_name,template_type,a_content_type from dm_xfm_form where object_name like ‘H%’
select object_name from dm_xfm_instance where r_object_id in(select r_object_id from dm_xfm_instance_s where is_default=’1′)
3. Select taskspace application names
select * from dmc_taskspace_app
4. Select workqueues
select wq_name from dmc_workqueue where wq_name like ‘hr%’
5. To delete all versions of a dm_process
dql> select r_object_id, r_object_id, object_name, r_version_label from dm_process (all) where object_name = ‘<the process name>’
API>uninstall,c,4bde75d1800118d4
API>destroy,c,4bde75d1800118d4
6. Create a user
create dm_user object
set user_name = ’employee_rv1′
set user_login_name = ’employee_rv1′
set user_address = ’employee_rv1@localhost.com’
set user_source = ‘inline password’
set user_password = ‘demo’
set default_folder = ‘/Temp’
set user_privileges = 0
set client_capability = 2
7. Create a Role
Create dm_group OBJECT
set group_name = ‘hr_employee_role’
set group_class = ‘role’
set group_address=’hr_employee_role@localhost.com’
8. Add User to a Role
Alter group ‘hr_employee_role’ add ‘manager_rv1′,’employee_rv1′
9. Find all roles assigned to a user
select * from dm_group where any i_all_users_names='<user name>’ and group_class=’role’
10. Find all users assigned a specific role
select i_all_users_names from dm_group where group_class=’role’ and group_name = ‘hr_employee_role’
11. Find the folder path of an object
SELECT s.object_name, fr.r_folder_path
FROM dm_sysobject s,dm_sysobject_r sr, dm_folder_r fr
WHERE s.i_is_deleted = 0 AND sr.i_position = -1
AND sr.r_object_id = s.r_object_id
AND fr.r_object_id = sr.i_folder_id
AND fr.i_position = -1
AND FOLDER(‘/Cabinetname’, DESCEND)
ORDER BY fr.r_folder_path,s.object_name
12. Create a dm_folder OBJECT
Create dm_folder OBJECT set object_name = ‘AcceptableDocumentTypes’
link ‘/Picklists’
13. Create a Custom Type
CREATE TYPE “acceptabledoctype” (“doccontentType” string(32)) WITH SUPERTYPE “dm_document”
14. Alter a Custom Type
ALTER TYPE nhspatient MODIFY nhs_dob (SET format_pattern = NULL, SET format_pattern_tag = NULL, SET label_text = ‘Date Of Birth’) PUBLISH;
15. How to run scripts in idql
On command prompt> idql32 <repository name>-uAdministrator -pdemo -rc:\xx.txt
16. List all configured audit events
select r.registered_id, r.event,r.user_namefrom dmi_registry r
where r.is_audittrail =1
17. Across-the-board audit configuration
select ‘ALL’,r.event,r.user_namefrom dmi_registry rwhere r.is_audittrail = 1
and r.registered_id = ‘0000000000000000’
18. Audit configuration for types
select t.name,r.event,r.user_namefrom dmi_registry r, dm_type t
where r.is_audittrail = 1and t.r_object_id = r.registered_id
19. Audit configuration for Sysobjects
select t.object_name,r.event,r.user_namefrom dmi_registry r, dm_sysobject t
where r.is_audittrail = 1and t.r_object_id = r.registered_id
20. Audit configuration for users
select t.user_name,r.event,r.user_namefrom dmi_registry r, dm_user t
where r.is_audittrail = 1and t.r_object_id = r.registered_id
21. Cleanup
UPDATE dm_document OBJECTS
SET r_lock_owner =”
SET r_lock_machine =”,
SET r_lock_date = date(‘nulldate’)
WHERE CABINET (‘/Patient’, descend)
AND r_lock_owner IS NOT NULLSTRING;
go;
DELETE dm_document(ALL) OBJECTS WHERE FOLDER(‘/Patient’,DESCEND)
go;
22. Kill a Job
DQL>select r_object_id from dm_job where object_name = ‘YOUR_JOB_NAME’
API>unlock,c,JOB_OBJECT_ID
DQL>update dm_job object set is_inactive = 1 where r_object_id = ‘JOB_OBJECT_ID’
You can change it from the API.These are the steps to update the Next invocation :
Get the job id using DQL:select r_object_id , object_name from dm_job where object_name= ‘The_job_name’
Connect to Iapi
API>dump,c,r_object_id of your Job
API>fetch,c,r_object_id of your Job
API> set,c,l,a_next_invocation
SET> 11/25/2007 04:00:00
API>dump,c,l
23. Run a Job Manually
execute do_method WITH method = ‘dm_nightlyextract’,
arguments = ‘-docbase_name edmrep -user_name Administrator -password demo -domain dce2008’
24. delete dm_cabinet object
delete dm_cabinet object where object_name= ‘Patient’
25. drop type
drop type patient object_name= ‘Patient’
26.