How can I get document hash from documentum using DQL?

337 Views Asked by At

Using DQMan or Document Admistrator, what's DQL statement to get hash of document in DCTM?

Select ... ?

If it's not possible how can I get it?

(I know exactly which is the document, r_chronicle_id, r_object_id, etc...)

1

There are 1 best solutions below

1
On

AFAIK there is no field representing a document hash, but take a look in the dmr_content object table. It should be here if there is one (I haven't checked I several years). Alternatively you would have to get it with API - either there is a method or you should do it yourself. Take a look in the api guide.

Edit: just searched the object reference guide. Turns out that there is a field in dmr_content. It's called r_content_hash. Have a look at it to see if your docbase fulfills requirements to have this field populated. Maybe you're in luck ;-)