Search and Download PDF-Rendition

Sonic

Hi,

i'm writing a Windows Application with DFC and want to automatically download the pdf-rendition of a document.

Following Structure in Documentum:

Winword (top level document)

Winword Rendition

PDF Rendition

If i send a DQL-Query all works correct and i get the top-level document, but if i try to get

a PDF Rendition of this document with following DQL-Query:

SELECT doc_number FROM fanp_general_tech_doc where r_object_id in (SELECT parent_id from dmr_content where full_format = 'pdf') and
doc_number like...

i always get the top-level document.

Does anybody has an idea how to get the PDF-Rendition??

Thanks for all answers!

Find more posts tagged with

Comments

aflowers001

A simple way is to use the DFC calls in preference to DQL.

Take a look at http://developer.emc.com/developer/snippets/ExportDocumentRendition.htm.

You can also use the Code Search to look for rendition related snippets.

Chris_Campbell

Another thing is that your DQL is missing something:

Sonic wrote:If i send a DQL-Query all works correct and i get the top-level document, but if i try to geta PDF Rendition of this document with following DQL-Query:SELECT doc_number FROM fanp_general_tech_doc where r_object_id in (SELECT parent_id from dmr_content where full_format = 'pdf') and
doc_number like...i always get the top-level document.

You need to incorporate the relation and get the child_id to get the actual pdf rendition. So your DQL would need to incorporate:

SELECT child_id from dm_relation_s where parent_id = '%var_object_id%' and relation_name = '%whatever_you_called_your_relation%' and child_label = 'CURRENT'

That child_id is going to be the r_object_id of the rendition that you really want.

Sonic

Hello,

i send your query and have an error because the tabe dm_relation_s is not found...

modifing this query as:

SELECT * from dm_relation where parent_id = '...'

i became one result with object_id, relation_name, child_id...

but it is the wrong realtionship (relation_name it is QM_Relation and not pdf-relationship)

it is standard documentum name for relationship for pdf-renditions i don't know...need documentum ERD, entity relationship diagram:o)

maybe u can tell me how the relationship name is and in which table(s) it is stored.

Chris_Campbell

Whoops... sorry about that. I used the logical table name. Just use dm_relation (without the _s) and that should work. If you need a ERD, I'll attach one here.

Sonic

Chris, thx very much for the ERDs

My problem is definitely that i don't know the Relation name between the winword document and the pdf rendition.

It is normally created in documentum per drag&drop, not with workflow and must be documentum standard.

If i ask the dm_relation table with: SELECT child_id from dm_relation where parent_id = '...'

and the parent_id is the r_object_id from the winword document i get the child_id which is not

the desired r_object_id for this desired Relation (it is the QM_Relation).

aflowers001

Just checking, does it work if you do the direct DFC call asking for the PDF?

Sonic

how must the DQL query be formed to get the pdf document rendition??

aflowers001

Hi,

Are you asking how to form the DQL as per the answers by Chris? If so you need to follow the pattern detailed by Chris and work out the relation name it should hopefully work.

To work out your relation name try SELECT DISTINCT relation_name from dm_relation WHERE parent_id = '%var_object_id%'

gcamou

Hi Sonic, Andrew Flowers and Chris Campbel....

I am programming in C# .Net, and I need to download a pdf file which has already been processed through the CTS ...

the problem is that not find to do, and I've read that you do so with DFC, but not where to download these libraries,

help me please...

aflowers001

To get C# DFC libraries you weill need to get the standalone DFC installer, install it and say Yes when prompted for the PIA installer.

Then you will need to go run the PIA instaler separately as the DFC installer doesn't do it automatically. This is all covered in the DFC installation guide.

Once the PIA has been installed you will be able to reference the DFC .NET PIA libraries.

gcamou

thank you very much andy flowers...

you know how to do this with the CTS?

aflowers001

Hi,

Not sure what you mean by 'you know how to do this with the CTS?'.

Are you after instructions for downloading and installing DFC or something else?

gcamou

Hi Andy...

sorry, my english not is very good

my question is...

how can download file "PDF-Rendition" using CTS...

I leave you my links, for have a better appreciation

https://community.emc.com/message/4217#4217

https://community.emc.com/message/4373#4373

https://community.emc.com/message/4462#4462

thanks you