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
5
votes
3 answers

How do you update a locked record in Documentum using DQL?

I'm unable to update the record with DQL due to a lock. Is it possible to unlock the record, update it and lock it again? I'm running the following code in idql64.exe on the content server. UPDATE dm_document objects SET keywords = 'D' WHERE…
aduguid
  • 3,099
  • 6
  • 18
  • 37
4
votes
2 answers

DQL query to find active users count

Can someone suggest me a DQL query to find the count of active users in a repository in documentum. Below is the query I am using but it is not giving correct results, can someone suggest? select count(user_name) from dm_user u , dm_group g where…
ScriptLearner
  • 163
  • 3
  • 16
2
votes
2 answers

How do I clear up Documentum rendition queue?

We have around 300k items on dmi_queue_item If I do right click and select "destroy queue item" I see the that row no longer appears if I query by r_object_id. Would it mean that the file no longer will be processed by the CTS service ? Need to…
Allende
  • 1,480
  • 2
  • 22
  • 39
2
votes
1 answer

Documentum DQL Getting list subfolders from a few folders

everyone! I am starting with Documentum this month and here is my problem. There is multi-select drop-down list with cabinets. I have to choose some of them to get list of inner folders in my result list below. This query: select * from dm_folder…
issverg
  • 80
  • 9
2
votes
1 answer

Deleting top 100 objects in DQL statement

I need to delete the first top 100 objects from a dm_document table. I already tried: DELETE dm_document objects where object_name='TestObject' enable (RETURN_TOP 100); DELETE dm_document objects where r_object_id in (select r_object_id from…
MrPapaye
  • 23
  • 1
  • 3
2
votes
1 answer

Documentum DQL join by repeating attribute

I tried to join these tables using repeating attribute: table1: r_object_id codes ... 1,2,3,4,5 ... 7,6,3,4,5 ... 1,5,4,2,3 Where codes attribute is the repeating…
kfir
  • 732
  • 10
  • 22
2
votes
2 answers

dm_folder_r is not registered or you do not have access to it in documentum

I am a newbie to documentum and i am trying to run the following query: select distinct A.*,A.i_chronicle_id,A.r_full_content_size,B.r_folder_path,B.r_object_id as folder_id from dm_document A, dm_folder_r B where any A.i_folder_id = B.r_object_id…
Akhil
  • 391
  • 3
  • 20
1
vote
1 answer

How to get the deleted documents list in a cabinet using DQL in Documentum?

I'm trying to find the list of documents deleted using DQL with few conditions, but I need to find the list that belongs to only a particular cabinet. I'm not able to frame query using audittrail with r_object_id of dm_cabinet. Maybe something like…
sb709057
  • 45
  • 6
1
vote
1 answer

How do I delete folders recursively using DQL?

I work on an application using Documentum. Let's say I have the following structure : MyCabinetName |->Folder 1 |->Folder 2 |-> Folder 3 I am trying to delete all the folders inside a cabinet. I am running the following DQL query…
The Once-ler
  • 220
  • 3
  • 16
1
vote
3 answers

Unable to delete documents in documentum application using DFC

I have written the following code with the approach given in EMC DFC 7.2 Development Guide. With this code, I'm able to delete only 50 documents even though there are more records. Before deletion, I'm taking the dump of object id. I'm not sure if…
this.srivastava
  • 1,045
  • 12
  • 22
1
vote
1 answer

Deleting Records from Documentum

I need to delete a number of records from a Documentum database. As these are Documentum objects I can't just go into the backend SQL and remove them so trying DQL. Delete from cbs_speciality where speciality_id = 'zzz' and I get the error Error…
Paul S Chapman
  • 832
  • 10
  • 37
0
votes
1 answer

Script parse error on select distinct in Documentum

need expert advice here with regards to running Documentum DQL. I'm getting an error when running script below: SELECT DISTINCT TRIM(a.r_gen_source), '|', TRIM(a.user_name), '|', TRIM(a.time_stamp), '|', TRIM(d.object_name) FROM dm_audittrail a,…
aintgel
  • 626
  • 3
  • 12
  • 21
0
votes
1 answer

Where is the SQL trace log

I am trying to find the logs about all the SQL queries that run when a DQL is executed. If I try to execute this from the API tester it works, and I can see the logs. But the difference is that I run that directly from the remote machine, while here…
Q_Q_
  • 3
  • 2
0
votes
1 answer

DQL Documentum count with multi values

select c_currency, count(r_object_id) from table group by c_currency c_currency is multi value erreur : the DQL statement has aggregation function on lightweight repeating attribute , the clause can only have r_object_id But when i add r_object_id…
Yes yassine
  • 13
  • 5
0
votes
1 answer

Selecting maximum value row using documentum query language (dql)

I have a few columns let's say r_object_id, date, c, d, e, f Now I want to have results such that only the object id row with maximum maximum dates remains Eg: If the values are R1, 29nov, c1,d1,e1,F1 R1, 30nov, c2,d2,e2,f2 R2, 20nov,…
Shivam
  • 383
  • 1
  • 3
  • 8
1
2