AVG: Return only the average value from all that qualify: SELECT AVG("b" + "c") FROM "abc" WHERE "a" = '10' COUNT: Return a count of a specific type objects in the repository owned by a particular user: SELECT COUNT(*) FROM type WHERE owner_name = 'tyler' COUNT(DISTINCT): Return a count of unique title values contained in all specific typed objects: SELECT COUNT(DISTINCT title) FROM type DISTINCT: Return only unique rows of information, suppressing duplicate rows: SELECT…

How many concurrent connections are allowed by the Content Server: SELECT concurrent_sessions FROM dm_server_config What is the default location for server log files: SELECT log_location FROM dm_server_config List the machine names where connection brokers reside: SELECT projection_targets FROM dm_server_config What is the oldest client version from which the repository will accept a connection (0=any version): SELECT check_client_version FROM dm_docbase_config

List all attributes of a specific type, indicating which are repeating-valued (1=repeating): SELECT attr_name, attr_repeating FROM dm_type WHERE name = 'type' Identify the supertype of a specific type: SELECT super_name FROM dm_type WHERE name = 'type' List all subtypes of a specific type: SELECT name FROM dm_type WHERE super_name = 'type' List the names of all types in the repository: SELECT name FROM dm_type Show any instances of a specific type in the repository: SELECT r_object_id, object_name…

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 * from type_name(all) SEARCH FIRST DOCUMENT CONTAINS 'word1' and 'word2' List all the documents which contain the exact phrase: SELECT * from type_name(all) SEARCH FIRST DOCUMENT…

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

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

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 their current state number: SELECT object_name, r_policy_id, r_current_state FROM dm_document WHERE owner_name = USER

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, supervisor_name FROM dm_tasks_queued WHERE DATEDIFF(month,plan_start_date,actual_start_date) >= 1 Return all tasks that were started more than one week ago: SELECT task_number, r_task_user FROM dm_tasks_queued WHERE DATEDIFF(week,actual_start_date,DATE(TODAY)) >= 1 Return all…