Virtual Documents
List all direct children of a specific virtual document (identified by object ID): SELECT object_name, subject, authors FROM dm_sysobject IN DOCUMENT ID('') List all direct children of a specific virtual document (identified by object ID and a version label): SELECT object_name, subject, authors FROM dm_sysobject IN DOCUMENT ID('') VERSION 1.1 List all children of…
Workflows
List all workflows supervised by the current user: SELECT process_id, object_name FROM dm_workflow WHERE supervisor_name = USER List all workflows supervised by any users within a specific list of users: SELECT r_object_id, supervisor_name FROM dm_workflow WHERE supervisor_name IN ('', '', '') Return all tasks that were started a month or more late: SELECT task_number,…
Lifecycles
What programming language is being used for the entry criteria and actions in a specific lifecycle (T=Java, F=DocBasic): SELECT java_methods FROM dm_policy WHERE object_name = '' List all validated and installed lifecycles in the repository: SELECT object_name FROM dm_policy WHERE r_definition_state = 2 List documents that are attached to a lifecycle, and display…
Aliases
List all alias sets and their aliases: SELECT object_name, alias_name, alias_value, alias_category FROM dm_alias_set List all permission set templates in the system: SELECT object_name FROM dm_acl WHERE acl_class = 1
DocApps
Display the object IDs of all objects contained in a specific DocApp: SELECT application_object_id FROM dm_application WHERE object_name = ‘' What is the version label of a specific DocApp: SELECT app_version FROM dm_application WHERE object_name = ''
Searching
List all searchable attributes: SELECT attr_name, type_name FROM dmi_dd_attr_info WHERE is_searchable = 1 ORDER BY type_name List all searchable dm_document attributes: SELECT attr_name FROM dmi_dd_attr_info WHERE is_searchable = 1 and type_name = 'dm_document' Display information about the full-text index: SELECT * FROM dm_fulltext_index List all the documents which contain the set of words: SELECT *…
Creating DFS Service Using Documentum Composer
Introduction To DFS Project When you create a Documentum Project in Composer, it has DFS Service enabled build path which makes it DFS project as well. If you right click one of your Documentum projects and bring up its properties, then select the Java Build Path, and under the Libraries…
Creating a DFS Consumer
Just as a quick aside if you do need to create a consumer, select the “DFS Services Library” entry and then select Edit, you should see something like this:- As you can see there are in fact 4 flavours of DFS services library. The first, and the default, is concerned…
Documents
List all documents owned by a specific user: SELECT object_name FROM dm_document WHERE owner_name = '' List all documents that contain specific keywords: SELECT object_name FROM dm_document WHERE ANY keywords = '' and ANY keywords = '' List all documents that have been checked out since yesterday, and who checked them out: SELECT…
Objects and Content
Retrieve information about a specific content file: SELECT r_object_id, parent_id, page, rendition,content_size, set_time, set_client, set_file FROM dmr_content WHERE ANY parent_id = '' Which objects depend on a specific content file: SELECT r_object_id, object_name, a_content_type,r_object_type, r_lock_owner, r_link_cnt FROM dm_sysobject WHERE i_contents_id = '' How many content files are associated with a specific object: SELECT…