dm_document, dm_folder structures

Hello

I would like to know the structure of dm_document and dm_folder objects/tables. I cannot find it on the several documentum documents I found.

Where can I check this info?

Thanks

Regards

Find more posts tagged with

Comments

lastnitescurry

WHY WHY WHY? google it... this question has been asked a million times a year for the last 20 years

pjmorce

I google it but i did not found this is why I asked.

But I wrote a program in Java to have my answer. If it is useful for someone:

public static void printStructure(IDfSession session, String name) throws Exception {

if(session != null) {

if(name != null && name.trim().length()>0) {

String sQuery = "SELECT * FROM dm_folder WHERE object_name = '" + name + "'";

IDfQuery query = new DfQuery();

query.setDQL(sQuery);

IDfCollection collection = query.execute(session, IDfQuery.DF_READ_QUERY);

while(collection.next()) {

for (int i = 0; i < collection.getAttrCount(); i++) {

IDfAttr attr = collection.getAttr(i);

String attrName = attr.getName();

System.out.println(attrName);

}

lastnitescurry

that DQL has nothing to do with your question... all that will do will return a list of folders in the system... which is useless without some context.

if you want to see folder information check out

http://www.dctmcontent.com/Lists/DQL/Category%20View.aspx

pjmorce

Yes, the URL you sent is very useful. Thanks for your help.

Regards.