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…
Renditions
Display all objects that have renditions: SELECT r_object_id, object_name, a_content_type, r_object_type,r_lock_owner, r_link_cnt FROM dm_document WHERE r_object_id IN (SELECT parent_id FROM dmr_content WHERE rendition > 0) Display all of objects that have PDF renditions: SELECT r_object_id, object_name, a_content_type, r_object_type,r_lock_owner, r_link_cnt FROM dm_document WHERE r_object_id IN (SELECT parent_id FROM dmr_content WHERE full_format='pdf’ and rendition > 0) and owner_name = USER
Full-Text
Return all indexed documents that contain the word “”: SELECT object_name, owner_name, r_creation_date FROM type SEARCH DOCUMENT CONTAINS '' Return all indexed documents that contain “” or “” or both: SELECT object_name, owner_name, r_creation_date FROM type SEARCH DOCUMENT CONTAINS '' Return all indexed documents that contain the phrase “”: SELECT object_name,…