umentum DQL高级使用指南.docx

Documentum DQL高级使用指南目录一、Documentum相关对象3二、主要对象属性91.dmi_workitem92.dmi_queue_item103.dm_workflow114.dm_process125.dmi_package156.DMC_process_parameter167.DMC_WORKQUEUE188.DM_ALIAS_SET189.DM_APPLICATION1910.DM_APP_REF2111.DM_COMPONENT2412.DM_DECISION2613.DM_DOCSET2814.DM_FOLDER3015.DM_USER3316.DM_GROUP3417.DM_METHOD3518.DM_QUERY3719.DM_Router3920.DM_STATE_TYPE4221.DM_STORE4322.DM_TASKS_ALL4323.DM_TASKS_DEQUEUED4424.DM_TASKS_QUEUED4425.DM_ACL4426.DM_ACTIVITY4527.DM_DOMAIN4828.DM_DOCUMENT49三、常用的DQL例子511.DQL to create user512.DQL to execute stored procedure (works for all supported DBMSes)513.Running DQL in batch mode514.DQL to Get all Files under a Particular Cabinet525.DQL to get total number of documents and folders under a cabinet526.DQL to find whether a document is a part of virtual document527.Repeating attributes538.DQL to find object type of a document539.DQL for index5310.DQL to see sessions5411.Enable FTDQL5412.DQL to get current date, time5513.DQL to list all available templates in Webpublisher5514.DQL to list objects having duplicate names5515.Clear INBOX5516.DQL to retrieve all required attributes of a particular type5517.DQL to list workflow attachments5618.attention5619.dctm_indexes_by_table.sql5620.index created5621.tracing a simple DQL query5722.DQL Hints5723.The accessibility5824.DQL to list docbrokers5925.DQL to list workflow information5926.Query to find active workflows, supervisors of the workflows5927.To find ACLs related to dm_sysobject:5928.List of object types and corresponding identifiers. Helpful when reading the code.6029.Job scheduler Query6230.dmclean6231.To deal with apostrophes in DQL, escape with apsotrophe.6232.view completed ments of the workflow6334.DQL to find all the folders in a Cabinet, where the folders are contentless6435.DQL for finding all checked out documents in a docbase6436.DQL to list the users who has access to particular folder path6437.Query to find out what user signed off on what document6438.the way to know about the period of a object6539.listing all contents that are in WIP state only.6540.Query to get all expired documents in previous month6541.Query to find the file system path location of a document6542.怎样通过代码取得DQL执行后产生的SQL66一、 Documentum相关对象对象ID 对象名称 父对象名称 属性个数0301943080000005 dmi_session 90301943080000006 dmi_transactionlog 50301943080000100 dmi_recovery 70301943080000102 dm_docbaseid_map 60301943080000107 dm_assembly 120301943080000121 dmi_dd_type_info dmi_dd_common_info 840301943080000123 dm_relation_type 150301943080000124 dm_foreign_key dm_relation_type 170301943080000125 dmi_registry 180301943080000137 dm_extern_store dm_store 310301943080000138 dm_extern_file dm_extern_store 350301943080000139 dm_extern_url dm_extern_store 31030194308000013a dm_extern_free dm_extern_store 31030194308000013b dmr_content 55030194308000013c dmi_subcontent 6030194308000013d dm_outputdevice dm_sysobject 93030194308000013e dm_method dm_sysobject 101030194308000013f dm_router dm_sysobject 1270301943080000140 dm_federation dm_sysobject 930301943080000141 dm_alias_set 100301943080000142 dm_ca_store dm_store 300301943080000143 dm_format 230301943080000144 dm_fulltext_index 110301943080000145 dm_dump_record 180301943080000146 dmi_dump_object_record 60301943080000147 dm_load_record 130301943080000148 dmi_load_object_record 120301943080000149 dmi_queue_item 44030194308000014a dm_reference 27030194308000014b dm_client_registration dm_sysobject 90030194308000014c dm_client_rights dm_sysobject 93030194308000014d dm_activity dm_sysobject 147030194308000014e dm_process dm_sysobject 121030194308000014f dmi_package 190301943080000150 dmi_workitem 320301943080000151 dm_workflow 360301943080000152 dm_audittrail 440301943080000153 dmi_audittrail_attrs 50301943080000154 dm_audittrail_acl dm_audittrail 550301943080000155 dm_audittrail_group dm_audittrail 580301943080000156 dm_query dm_sysobject 860301943080000157 dm_script dm_sysobject 860301943080000158 dm_smart_list dm_sysobject 900301943080000159 dm_procedure dm_sysobject 87030194308000015a dm_job dm_sysobject 111030194308000015b dm_cache_config dm_sysobject 93030194308000015c dmi_change_record 10030194308000015d dm_public_key_certificate dm_sysobject 90030194308000015e dm_cryptographic_key dm_sysobject 90030194308000017b dm_format_preferences dm_document 86030194308000017d dmc_validation_module dmc_module 103030194308000017e dmc_validation_relation dm_relation 14030194308000015f dm_state_extension dm_relation 130301943080000161 dm_state_type 40301943080000163 dm_job_request dm_sysobject 920301943080000165 dm_component dm_sysobject 900301943080000167 dm_app_ref dm_sysobject 870301943080000169 dm_message_container dm_document 94030194308000016b dm_attachments_folder dm_folder 88030194308000016d dm_message_user_data 6030194308000016f dm_message_route_user_data 60301943080000171 dmc_module dm_folder 1000301943080000173 dmc_java_library dm_folder 890301943080000175 dmc_aspect_relation 50301943080000176 dm_media_profile dm_sysobject 900301943080000178 dm_sysprocess_config dm_sysobject 101030194308000017f dm_migrate_rule dm_job 1490301943080000182 dm_webc_target dm_sysobject 1090301943080000183 dmc_workqueue_category dm_folder 880301943080000185 dmc_workqueue_policy 130301943080000187 dmc_workqueue_user_profile 70301943080000189 dmc_completed_workflow 18030194308000018b dmc_transition_condition 17030194308000018d dmc_wf_package_schema dm_relation 13030194308000018f dmc_module_config 70301943080000191 dmc_tcf_activity dm_document 880301943080000193 dmc_routecase_condition 200301943080000195 dmc_wq_user_skill 70301943080000197 dmc_process_correlation_set dm_relation 140301943080000199 dmc_wfsd_element dmc_wfsd_element_parent 97030194308000019b dmc_wfsd_element_string dmc_wfsd_element 98030194308000019d dmc_wfsd_element_boolean dmc_wfsd_element 98030194308000019f dmc_wfsdrp_parent 1203019430800001a1 dmc_wfsdrp_string dmc_wfsdrp_parent 1303019430800001a3 dmc_wfsdrp_boolean dmc_wfsdrp_parent 1303019430800001a5 dmc_wfsd_type_info dm_sysobject 10303019430800001a6 dmc_process_parameter dm_sysobject 9603019430800001a8 dmc_wpr_parent 1303019430800001ab dm_ftindex_agent_config dm_sysobject 10503019430800001ad dm_ssa_policy dm_sysobject 8703019430800001af dm_xml_config dm_document 8703019430800001b1 dm_xml_zone dm_document 8803019430800001b3 dm_xml_application dm_folder 9303019430800001b4 dm_business_pro dm_sysobject 9003019430800001b6 dm_category_class dm_sysobject 9603019430800001b8 dm_taxonomy dm_category 10403019430800001ba dm_docset dm_document 9103019430800001bc dm_ci_config dm_sysobject 10503019430800001bd dm_sync_list_relation dm_relation 1303019430800001be dm_acs_config dm_sysobject 10503019430800001c0 dm_dms_config dm_sysobject 9103019430800001c2 dm_validation_descriptor dm_sysobject 8803019430800001c4 dmi_03019430800001c4 403019430800001c5 dmi_03019430800001c5 403019430800001ac dm_ldap_config dm_sysobject 12003019430800001ae dm_relation_ssa_policy dm_relation 1403019430800001b0 dm_xml_style_sheet dm_document 8703019430800001b2 dm_xml_custom_code dm_document 8903019430800001b5 dm_decision dm_sysobject 9203019430800001b7 dm_category dm_folder 10303019430800001b9 dm_category_assign dm_relation 2103019430800001bb dm_docset_run dm_document 9703019430800001bf dm_bocs_config dm_sysobject 9703019430800001c1 dm_network_location_map dm_sysobject 9203019430800001c3 dm_cont_transfer_config dm_sysobject 9003019430800001c6 dmi_03019430800001c6 303019430800001c7 dmi_03019430800001c7 303019430800001c8 dmi_03019430800001c8 203019430800001c9 dmi_03019430800001c9 303019430800001ca dmi_03019430800001ca 803019430800001cb dmi_03019430800001cb 403019430800001cc dmi_03019430800001cc 703019430800001cd dmc_class dm_sysobject 9003019430800001ce dmc_constraint_set dm_sysobject 8903019430800001cf dmc_dar dm_sysobject 8903019430800001d0 dmc_metamodel dm_sysobject 8603019430800001d1 dmc_relationship_def dm_sysobject 10103019430800001d3 dmc_config_scope_relation dm_relation 1403019430800001d4 dmc_preset_info dm_relation 1603019430800001d5 dmc_preset_package dm_document 9003019430800001d6 dm_xfm_schema dm_document 8903019430800001d8 dm_xfm_form dm_document 9203019430800001da dm_xfm_resource dm_document 8703019430800001dc dmc_bps_inbound_instance 403019430800001de bpm_cutoff 403019430800001e0 dmc_calendar_event dm_sysobject 10303019430800001e1 ceb_config dm_document 8603019430800001e2 ceb_user_profile ceb_config 9803019430800001e3 ceb_user_pro_account ceb_user_profile 10003019430800001e4 ceb_folder dm_folder 8803019430800001e5 ceb_app_role_folder ceb_folder 9403019430800001e6 ceb_sunc_folder ceb_app_role_folder 9403019430800001e7 ceb_account_folder ceb_app_role_folder 9403019430800001e8 ceb_resource ceb_config 8803019430800001e9 ceb_account_info ceb_resource 8803019430800001ea ceb_org ceb_config 9703019430800001eb ceb_user_pro_general ceb_user_profile 9903019430800001f0 ceb_hist_folder ceb_app_role_folder 9403019430800001f1 ceb_user_pro_hist ceb_user_profile 9803019430800001f5 ceb_hist_info ceb_resource 8803019430800001f8 ceb_markup dm_document 8803019430800001f9 ceb_cb_image ceb_business 9603019430800001fa ceb_report ceb_business 9103019430800001fb ceb_minter ceb_business 8903019430800001fc ceb_suncard ceb_business 8903019430800001fd ceb_history ceb_business 920301943080000160 dm_job_sequence dm_sysobject 920301943080000162 dm_locator dm_sysobject 870301943080000164 dm_qual_comp dm_sysobject 930301943080000166 dm_application dm_sysobject 1000301943080000168 dm_java dm_document 89030194308000016a dm_message_archive dm_message_container 113030194308000016c dm_message_address 11030194308000016e dm_message_attachment 70301943080000170 dm_email_message dm_document 930301943080000172 dmc_jar dm_document 880301943080000174 dmc_aspect_type dmc_module 1080301943080000177 dm_retainer dm_sysobject 980301943080000179 dm_jms_config dm_sysprocess_config 101030194308000017a dm_esign_template dm_document 91030194308000017c dm_menu_system dm_document 860301943080000180 dm_shmeconfig 40301943080000181 dm_webc_config dm_sysobject 1110301943080000184 dmc_workqueue 60301943080000186 dmc_workqueue_doc_profile 60301943080000188 dmi_wf_attachment 8030194308000018a dmc_completed_workitem 23030194308000018c dmc_composite_predicate 4030194308000018e dmi_wf_timer 140301943080000190 dmc_tcf_activity_template dm_document 880301943080000192 dmc_wf_package_skill dm_relation 140301943080000194 dmc_wq_skill_info 110301943080000196 dmc_wq_task_skill 70301943080000198 dmc_wfsd_element_parent dm_sysobject 89030194308000019a dmc_wfsd_element_integer dmc_wfsd_element 98030194308000019c dmc_wfsd_element_double dmc_wfsd_element 98030194308000019e dmc_wfsd_element_date dmc_wfsd_element 9803019430800001a0 dmc_wfsdrp_integer dmc_wfsdrp_parent 1303019430800001a2 dmc_wfsdrp_double dmc_wfsdrp_parent 1303019430800001a4 dmc_wfsdrp_date dmc_wfsdrp_parent 13030194308