DQL update objects limit results of subquery
Hi,
I am trying to link exactly 1000 documents to a folder with a DQL update statement:
update dm_document link '/folder/path/1000-folder' where r_object_id in (select r_object from dm_document ... )
Using enable(RETURN_TOP 1000)
in the subquery does not have any effect. Is there another way to accomplish the limit of 1000 documents?
Thanks,
Hartmut
Comments
-
I would like to avoid using external tools like Excel, but probably that will be the last resort.
For the query itself, that works when you extend the condition with
... and not folder('/folder/path', descend')
. With that the second query will never find objects updated by the first query.0 -
Hi Hartmut, old fellow!
Quite sure you can not do that subquery limit through DQL + ENABLE(RETURN_TOP n)... documentation also says:
If the query includes a subquery the hint (RETURN_TOP n) is not applied to the subquery.But what about this approach:
If that update is more than a one time fix but a repeated task you may think about creating+registering an underlying (Oracle?) RDBMS view for your subquery. That dynamic view should have the (Oracle?) query result ROW-NUMBER available as a column to be used as a filter (...and row-number < 1000...) in your DQL update statement's where condition...0
Categories
- All Categories
- 108 Developer Announcements
- 53 Articles
- 107 General Questions
- 144 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 899 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 119 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management