(private) sorry...!! contact@ecmnotes.com
slide

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 *…

slide

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 = ''

slide

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

slide

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…

slide

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,…

slide

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…

slide

Groups and Roles

List all roles in the system: SELECT group_name FROM dm_group WHERE group_class = 'role'  List all users who are members of this group, including those who are members of groups contained in this group: SELECT i_all_users_names FROM dm_group WHERE group_name = '' List all groups a particular user can modify: SELECT group_NAME from…

slide

Users

Show when a user’s properties were last changed: SELECT r_modify_date FROM dm_user WHERE user_name = '' List all deactivated user accounts: SELECT user_name FROM dm_user WHERE user_state = 1 List the LDAP servers being used to authenticate users: SELECT user_login_domain FROM dm_user WHERE user_source = 'LDAP'  List documents currently checked out by a…

slide

Object security (ACL)

Display the folder security setting for this repository (0=disabled, 1=enabled): SELECT folder_security FROM dm_docbase_config  Show the default ACL mode for the Content Server: SELECT default_acl FROM dm_server_config List the objects associated with this permission set: SELECT object_name FROM dm_sysobject WHERE acl_name = '' and acl_domain = '' List the permission sets that…

slide

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,…