Viewing content via DQL

I am new to Documentum and have a DQL question ...

How via DQL can I get information about the content associated with a document?

Here is what I have done so far (version 6.5 SP2):

Installed Documentum Content Server and Documentum Administrator

Created a repository

Using Administrator I created a new type named "jdl_document" which is the standard "dm_document" with an additional string attribute named "tangent"

Using Administrator I was able to create two documents using DQL. The following is the DQL for the first document:

CREATE "jdl_document" OBJECT
SET "title" = 'Test Document 1'
SET "tangent" = 'Tangent Document 1'
SETFILE 'c:\Junk\TestDoc1.doc'
WITH CONTENT_FORMAT='msww'

Using a DQL 'select' statement I can view all of the properties of the above document.

How do I get information about the content? (For example, the path is "c:\Junk\TestDoc1.doc")

Thank you in advance.

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

DCTM_Guru

"...How do I get information about the content? (For example, the path is "c:\Junk\TestDoc1.doc")"

You can get relative file path to file store using the mfile_url function:

SELECT object_name,MFILE_URL('',1,'')
FROM dm_document WHERE r_object_id = '...'

All comments

XdctmX

Content files are stored as object of type dmr_content. dmr_content object stores the information about the format and location of a content file. It also contains the information that links the content to an object. parent_id attribute of the dmr_content has the r_object_id of the object.

Run DESCRIBE dmr_content to see all the attributes of the dmr_content.

You have to use DFC / API (Depending on the version) if you want to Checkout/Checkin/Edit the document. But you can get informations about the content using DQL.

DCTM_Guru

"...How do I get information about the content? (For example, the path is "c:\Junk\TestDoc1.doc")"

You can get relative file path to file store using the mfile_url function:

SELECT object_name,MFILE_URL('',1,'')
FROM dm_document WHERE r_object_id = '...'

mgrootsch

> Using a DQL 'select' statement I can view all of the properties of the above document.

I suppose you think that that is achieved with the following query, am I right?
select * from jdl_document

Be carefull because you would be wrong. DQL is not SQL and the * does not mean "all attributes". Some attributes like internal and repeating attributes are not shown.

You can find the r_object_id with DQL and then execute an API statement like this:
dump,c,<the r_object_id found>
This will show you all the attributes.

Your object will have an attribute i_contents_id. You can then do a dump of this object to get more info about the content.