Hello,
Thanks for any input and here is my problem regarding documentum:
Need:
I need to extract some documents and their metadata (additional fields which was configurated to be mandatory to describe better the document) for another party software that will do some logistic with the provided data.
Platform:
I am using Microsoft Visual Studio 2005 (C#);
Library:
Documentum.Interop.DFC (Version: 5.3.0.117);
So far obtained:
By using DQL I was able to retrieve the folder structure of my point location, so that the user may choose the document(s) that will provide data to another party software. More, I can download using also the same library the document for processing.
Further need:
In order to provide full information I must retrieve also their metadata (attributes, properties how you want to define it) that was provided into the mandatory fields at the time of recording the document into the documentum system.
I was able to see that using dql to interogate the selected document will retrieve system properties of the document as (object_name, r_object_id etc), needfull information but not the fields I wanted. Using the sql query directly into the database I can see my mandatory fields at the end of the repository table, in my case "rlc_ctr_document_sp". So, if I will use the sql connection and interogate the database I can retrieve the wanted data. But it doesn't seems elegant to use dql to retrieve 80% from what I want to establish an sql connection just to take rest of the percentage to complete my task.
Finnaly the question:
How can I use dql interogation to obtain my data?
I hope I didn't get you all bored with my explanation and one more time, thank you for your input.
