
Object Types
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…

Object Manipulation
Create a new object, setting attribute values, folder location, and associating a content file: CREATE type OBJECT SET title = '', SET authors[0] = '', INSERT authors[0] = '',APPEND authors = '', LINK '/a/b' SETFILE 'C:testpathabc.doc' WITH CONTENT_FORMAT 'test_format' Modify a specific existing object, changing attribute values and folder location:…

Content Server
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…

Registered tables
Create Table in database: EXECUTE EXEC_SQL WITH QUERY='CREATE TABLE abc(a VARCHAR2(20),b INTEGER,c FLOAT)' Register specific columns from an external table and create indexes on some of the columns: REGISTER TABLE “abc” (“a” CHAR(20), “b” INT, “c” FLOAT,) WITH KEY “a”, “b” Return information from a registered table: SELECT “a”, “b”…

Other Syntax
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…

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

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