blocks|key|4652663|text|您可以尝试这个dql：select+*+from+dm_folder+where+r_object_id+in+(select+i_folder_id+from+dm_document+where+r_object_id+=+'<objectId>')|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4652664|entityMap^0|B|37|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

You can try this dql: <code>select * from dm_folder where r_object_id in (select i_folder_id from dm_document where r_object_id = '&lt;objectId&gt;')</code>

blocks|key|4652724|text|您可以同时在API控制台中转储object+ID。命令转储，c，您可以看到很多地狱般的属性--比DQL能提供给您的属性更多/然后再次搜索r_object_id转储，并搜索I_folder_path，您将得到您的誓言|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4652725|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You can simultaneously Dump the object ID in API console..
Command dump,c, 
You can see hell lot of attributes - more than what DQL can provide you/
Then Search for r_object_id
Dump that again and Search for I_folder_path you will get yor oath

blocks|key|4652763|text|您有文档的对象id，而不是文件夹的对象id。因此，首先使用文档的对象id获取文件夹id。此步骤的查询为：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4652764|select+i_folder_id+from+dm_document+where+r_object_id='<objectid>'|code-block|syntax|javascript|4652765|作为上述查询的结果，您将获得i_folder_id。如果你只需要转储这个id就足够了。您将获得有关该文件夹的信息。|4652766|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You have object id of the document and not the object id of the folder. So first you get the folder id using the object id of the document. The query for this step is:

<pre><code>select i_folder_id from dm_document where r_object_id='&lt;objectid&gt;'
</code></pre>

As a result of the above query, youy will get the i_folder_id. It is enough if you just dump this id. You will get information about the folder.

blocks|key|4652821|text|对于已签出的文档，您可以使用-|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4652822|select+*+from+dm_document+where+r_lock_owner+not+like+'+'|code-block|syntax|javascript|4652823|您可以从上面的查询结果中选择r_object_id。然后查看文件夹详细信息-|4652824|select+*+from+dm_folder+where+r_object_id+in+(select+i_folder_id+from+dm_document+where+r_object_id+=+'r_object_id')|4652825|如果您想要所有已签出文档的文件夹路径，您可以提供以下内容：|4652826|select+distinct+d.r_object_id,d.object_name,+f.r_folder_path+from+dm_folder+f,dm_document+d+where+any+d.i_folder_id+=+f.r_object_id+and+d.r_object_id+in+<'give+r_object_id+for+checked+out+documents'>+enable+(ROW_BASED)+|4652827|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

For checked out document you can use - 

<pre><code>select * from dm_document where r_lock_owner not like ' '
</code></pre>

you can select your r_object_id from the above query result. then for folder details - 

<pre><code>select * from dm_folder where r_object_id in (select i_folder_id from dm_document where r_object_id = 'r_object_id')
</code></pre>

and if you want the folder path for all checked out documents , you can give like -

<pre><code>select distinct d.r_object_id,d.object_name, f.r_folder_path from dm_folder f,dm_document d where any d.i_folder_id = f.r_object_id and d.r_object_id in &lt;'give r_object_id for checked out documents'&gt; enable (ROW_BASED) 
</code></pre>

blocks|key|3242515|text|在这里相对较新，但希望这对您有所帮助。我只在select列表中包含了r_folder_path，但是您可以包含所需的任何其他dm_folder属性。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3242516|如果您没有文档的r_object_id，则可以使用以下DQL返回所有已签出文档的文件夹详细信息：|3242517|select++++++d.r_object_id,+
++++++++++++d.title,+
++++++++++++f.r_folder_path
from++++++++dm_document+d,+dm_folder+f
where+++++++d.i_folder_id+=+f.r_object_id
and+++++++++d.r_object_id+in+
(
++++select++++++r_object_id
++++from++++++++dm_document
++++where+++++++r_lock_owner+not+like+'+'
)
and+f.r_folder_path+not+like+'+'
enable++++++(row_based)|code-block|syntax|javascript|3242518|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Relatively new here, but hopefully this is helpful. I have only included the r_folder_path in my select list, but you can include any of the other dm_folder attributes you require. 

If you do not have the r_object_id of the document, you can return folder details for all checked out documents using the following DQL - 

<pre><code>select d.r_object_id, 
 d.title, 
 f.r_folder_path
from dm_document d, dm_folder f
where d.i_folder_id = f.r_object_id
and d.r_object_id in 
(
 select r_object_id
 from dm_document
 where r_lock_owner not like ' '
)
and f.r_folder_path not like ' '
enable (row_based)
</code></pre>

blocks|key|1887629|text|select+*+from+dm_folder+where+r_object_id+in+(select+i_folder_id+from+dm_document+where+r_object_id+=+given_obj_id)；|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1887630|您可以选择自定义类型，而不是dm_document，这会将结果限制为您想要的类型。|1887631|entityMap^0|1Y|B|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|N|8|@]|D|@]|E|$]]]|I|$]]

select * from dm_folder where r_object_id in (select i_folder_id from dm_document where r_object_id = [given_obj_id]);

You may choose your custom type instead of dm_document, that will limit the results to your desired type.

blocks|key|1883355|text|如果您想知道签出的文档位于哪些文件夹中，可以通过以下方式获取文件夹路径：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1883356|select+distinct+r_folder_path+
++from+dm_folder+
+where+r_object_id+in
+++(select+i_folder_id+
++++++from+dm_document
+++++where+r_lock_owner+is+not+nullstring)|code-block|syntax|javascript|1883357|或者，您可以将最后一部分更改为：where+r_lock_owner+=+'<name+of+owner>'，并替换<name+of+owner>中的名称。|offset|length|style|CODE|1883358|entityMap^0|0|0|G|12|1M|F|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]|$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|N|$]]

If you want to know in which folders checked out documents exists, you can get the folderpaths via:

<pre><code>select distinct r_folder_path 
 from dm_folder 
 where r_object_id in
 (select i_folder_id 
 from dm_document
 where r_lock_owner is not nullstring)
</code></pre>

Or you can change the last part to: <code>where r_lock_owner = '&lt;name of owner&gt;'</code> and substitute the name in <code>&lt;name of owner&gt;</code>.

blocks|key|3242601|text|select+*+from+dm_sysobject
where+r_object_id+in+(select+i_folder_id+from+dm_sysobject+where+
r_object_id='your+_object_id')|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|3242602|如果您想要owner+details，type+of+the+folder+(如果您的业务有)，它的object+type和rest文件路径以外的其他信息可以从上面的查询中获得。如果您想要路径，则使用：|unstyled|offset|length|style|CODE|3242603|select+*+from+dm_folder
where+r_object_id=(select+i_folder_id+from+dm_sysobject+where+
r_object_id='your+_object_id')|3242604|entityMap^0|0|5|C|J|I|1E|B|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|P|8|@$G|Q|H|R|I|J]|$G|S|H|T|I|J]|$G|U|H|V|I|J]]|9|@]|A|$]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$B|C]]|$1|M|3|-4|5|F|7|X|8|@]|9|@]|A|$]]]|N|$]]

<pre><code>select * from dm_sysobject
where r_object_id in (select i_folder_id from dm_sysobject where 
r_object_id='your _object_id')
</code></pre>

If you want <code>owner detail</code>s, <code>type of the folder</code> (if your business has any),its <code>object type</code> and rest other information other than path to the files can be obtained from above query. If you want path then use:

<pre><code>select * from dm_folder
where r_object_id=(select i_folder_id from dm_sysobject where 
r_object_id='your _object_id')
</code></pre>

Can any one please provide a solution in Documentum Query Language to access the folder details of a file checked out from documentum if we provide the object_id of the corresponding file.
Thank You.......

DQL-Documentum query

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

如果我们提供了相应文件的object_id，任何人都可以用Documentum Query Language提供一个解决方案，以访问从documentum检出的文件的文件夹详细信息。谢谢你......

问DQL-Documentum查询
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问DQL-Documentum查询EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问DQL-Documentum查询
EN