Documentum DQL高级使用指南
目录
一、 Documentum相关对象 3
二、 主要对象属性 9
1. dmi_workitem 9
2. dmi_queue_item 10
3. dm_workflow 11
4. dm_process 12
5. dmi_package 15
6. DMC_process_parameter 16
7. DMC_WORKQUEUE 18
8. DM_ALIAS_SET 18
9. DM_APPLICATION 19
10. DM_APP_REF 21
11. DM_COMPONENT 24
12. DM_DECISION 26
13. DM_DOCSET 28
14. DM_FOLDER 30
15. DM_USER 33
16. DM_GROUP 34
17. DM_METHOD 35
18. DM_QUERY 37
19. DM_Router 39
20. DM_STATE_TYPE 42
21. DM_STORE 43
22. DM_TASKS_ALL 43
23. DM_TASKS_DEQUEUED 44
24. DM_TASKS_QUEUED 44
25. DM_ACL 44
26. DM_ACTIVITY 45
27. DM_DOMAIN 48
28. DM_DOCUMENT 49
三、 常用的DQL例子 51
1. DQL to create ur 51
怎么鉴别紫砂壶2. DQL to execute stored procedure (works for all supported DBMSes) 51
3. Running DQL in batch mode 51
4. DQL to Get all Files under a Particular Cabinet 52
5. DQL to get total number of documents and folders under a cabinet 52
6. DQL to find whether a document is a part of virtual document 52
7. Repeating attributes 53
8. DQL to find object type of a document 53
9. DQL for index 53
10. DQL to e ssions 54
11. Enable FTDQL 54
惟爱你
12. DQL to get current date, time 55
13. DQL to list all available templates in Webpublisher 55
14. DQL to list objects having duplicate names 55
15. Clear INBOX 55
16. DQL to retrieve all required attributes of a particular type 55
17. DQL to list workflow attachments 56
18. attention 56
宅相19. dctm_indexes_by_table.sql 56
20. index created 56
21. tracing a simple DQL query 57
22. DQL Hints 57
听歌写作业好不好23. The accessibility 58
24. DQL to list docbrokers 59
25. DQL to list workflow information 59
26. Query to find active workflows, supervisors of the workflows 59
27. To find ACLs related to dm_sysobject: 59
28. List of object types and corresponding identifiers. Helpful when reading the code. 60
29. Job scheduler Query 62
30. dmclean 62
31. To deal with apostrophes in DQL, escape with apsotrophe. 62
32. view completed workflows 63
33. comments of the workflow 63
34. DQL to find all the folders in a Cabinet, where the folders are contentless 64
35. DQL for finding all checked out documents in a docba 64
36. DQL to list the urs who has access to particular folder path 64
37. Query to find out what ur signed off on what document 64
38. the way to know about the period of a object 65
39. listing all contents that are in WIP state only. 65
40. Query to get all expired documents in previous month 65
41. Query to find the file system path location of a document 65
42. 怎样通过代码取得DQL执行后产生的SQL 66
一、 Documentum相关对象
对象ID 对象名称 父对象名称 属性个数
0301943080000005 dmi_ssion 9
0301943080000006 dmi_transactionlog 5
0301943080000100 dmi_recovery 7
0301943080000102 dm_docbaid_map 6
0301943080000107 dm_asmbly 12
0301943080000121 dmi_dd_type_info dmi_dd_common_info 84
0301943080000123 dm_relation_type 15
0301943080000124 dm_foreign_key dm_relation_type 17
0301943080000125 dmi_registry 18
0301943080000137 dm_extern_store dm_store 31
0301943080000138 dm_extern_file dm_extern_store 35
0301943080000139 dm_extern_url dm_extern_store 31
油松030194308000013a dm_extern_free dm_extern_store 31
030194308000013b dmr_content 55
030194308000013c dmi_subcontent 6
030194308000013d dm_outputdevice dm_sysobject 93
030194308000013e dm_method dm_sysobject 101
030194308000013f dm_router dm_sysobject 127
0301943080000140 dm_federation dm_sysobject 93
0301943080000141 dm_alias_t 10
最暖心的表白情话0301943080000142 dm_ca_store dm_store 30
白萝卜简笔画0301943080000143 dm_format 23
0301943080000144 dm_fulltext_index 11
0301943080000145 dm_dump_record 18
0301943080000146 dmi_dump_object_record 6
0301943080000147 dm_load_record 13
0301943080000148 dmi_load_object_record 12
0301943080000149 dmi_queue_item 44
030194308000014a dm_reference 27
030194308000014b dm_client_registration dm_sysobject 90
030194308000014c dm_client_rights dm_sysobject 93
030194308000014d dm_activity dm_sysobject 147
030194308000014e dm_process dm_sysobject 121
030194308000014f dmi_package 19
0301943080000150 dmi_workitem 32
0301943080000151 dm_workflow 36
0301943080000152 dm_audittrail 44
关东军
0301943080000153 dmi_audittrail_attrs 5
0301943080000154 dm_audittrail_acl dm_audittrail 55
0301943080000155 dm_audittrail_group dm_audittrail 58
0301943080000156 dm_query dm_sysobject 86
0301943080000157 dm_script dm_sysobject 86
0301943080000158 dm_smart_list dm_sysobject 90
