Stack Overflow
Stack Overflow

Questions tagged [documentum-dql]

Documentum Query Language is query language used on OpenText ECM platform Documentum.

Documentum Query Language is query language used on OpenText ECM platform Documentum. It is a superset of ANSI-standard SQL (Structured Query Language) DQL statements operate on objects and sometimes on tables/rows.

Homepage: https://documentumdcm.wordpress.com/dql-queries/

29 questions
0
votes
1 answer

How can I get document hash from documentum using DQL?

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...)
Falco
  • 1,458
  • 3
  • 19
  • 47
0
votes
0 answers

Search multiple table columns for the same value

I would like to replicate what our database search engine calls a 'multi-field search' in DQL (which is pretty much SQL as I understand). I'm not sure if this is possible, but the syntax would look something like... SELECT title, container_no,…
HotSauceCoconuts
  • 301
  • 5
  • 19
0
votes
1 answer

Is it possible change length of native documentum attributes of dm_document type?

Launching: ALTER TYPE dm_document MODIFY title string (1000); I get: Is it possible to do these kind of things in some other manner?
Falco
  • 1,458
  • 3
  • 19
  • 47
0
votes
1 answer

Getting version mismatch error while updating into DCTM using java

I am trying to update into DCTM through java code, below is the code snippet IDfDocument communication = (IDfDocument) getDfSession().getObject(DfId.valueOf(communicationId)); communication.setString(ATTR_STATUS, status); communication.save(); but…
Mahesh Nighut
  • 115
  • 1
  • 10
0
votes
1 answer

DQL - dOCUMENTUM - Replacing one acl with another

How can i write a dql/iapi script to replace a specific acl in a specific location? update dm_sysobject object set acl_name="new_acl" set acl_domain = 'domain" where acl_name='old_acl' WHERE FOLDER('/xxxxxxxxxxxxx', descend)
Eitan Weiss
  • 1
0
votes
0 answers

in webtop 6.8.2, i had imported documentum with folder r_object_type mismatch what actually has to be

I have imported few documents, by creating a new folder, in webtop 6.8.2 patch 9, having wrong "r_object_type" which cause access will not be updated for users. Thus, I updated "r_object_type" using API script which causes sub-folders to get…
jyoti srivastava
  • 1
  • 1
0
votes
1 answer

How to properly create type using Documentum DQL

Have a horrible error on simple script execution. Please help. Error occured during query execution :[DM_QUERY_E_SYNTAX]error: "A Parser Error (syntax error) has occurred in the vicinity of: create type…
Ivan Karotki
  • 139
  • 2
  • 15
0
votes
1 answer

Write, append DQL query results to excel in java using apache poi and DFC

I have to write the dql query results to excel in java using apache poi and DFC. I have the following code written, this needs to be organized to handle efficiently. I tried writing to excel utility in other method, but this is not working…
user11163621
0
votes
1 answer

Combining Complex Queries, Selecting from 4 Tables

I've been trying to combine these queries with no success Simply selecing fol.r_folder_path from dm_folder fol doesn't work and I am unsure why... SELECT distinct(rec.r_object_id) as record_obj_id, rec.accession_no, rec.pier_content_type,…
HotSauceCoconuts
  • 301
  • 5
  • 19
0
votes
1 answer

How to delegate a document to a user via Samson using DQL

I'm new with writing DQL queries, and trying to find documentation for Samson 1.0 is a huge pain. So, can someone help me figure out how to delegate a Documentum task via Samson using DQL? Also, if anyone could point me to where I can find…
Everett
  • 145
  • 2
  • 12
0
votes
1 answer

Access to Documents file and metada on Content Server using DQL

I would like to know whether there is a way to execute DQL queries against a content Documentum server apart from the JAVA API DFC classes interface, using other languages such as Python or R. I need to access and old version of the documentum…
Gonzalo Polo
  • 357
  • 3
  • 14
0
votes
3 answers

Documentum DQL Editor?

I am using Documentum which is on the remote server.I want to see the data in dm_sysobject table.Through my research I found that we can see the table data in DQL Editor.But,I am unable to find from where can I get this DQL Editor.Do I need to…
sai
  • 1
  • 4
-1
votes
1 answer

How to list docbroaker configured with the docbase?

Via Documentum Administrator, how is it possible to list the docbroaker configured with the actual accessed docbase?
Andrea
  • 6,032
  • 2
  • 28
  • 55
-1
votes
1 answer

to calculate number of days between two dates in dql documentum

I have two attributes, effect_date,next_effect_date. I have to calculate the difference between these two dates in days. what will be the dql query? Please Help
Yalisai
  • 11
  • 1
  • 5
1
2