Tech Kraft

Documentum, AWS, Java, Ruby on Rails, Linux, Windows, App Servers

DQL: Listing documents with their Folderpaths

Here’s a DQL to get a listing of Documents along with their folderpaths in the repository:

select fld.r_folder_path, 
doc.r_object_id, 
doc.object_name, doc.r_content_size, doc.acl_name, doc.r_creation_date, doc.r_modify_date, doc.r_creator_name, doc.title, doc.subject, doc.keywords 
from dm_document doc, dm_folder fld
where 
folder('/<CABINET_NAME>', descend) and 
fld.r_object_id = doc.i_folder_id 
and any r_folder_path is not nullstring 
enable (ROW_BASED)
,
chanakya2's avatar

Posted by:

chanakya2

Leave a comment

About Me

Senior Software Engineer professional with over 16 years of success with multiple open source technologies and various Content Management platforms and solutions.

Proven technical abilities through numerous projects involving enterprise web application design and development, application installation, configuration and support, and workflow and collaboration system designs.

  • Ability to learn new technologies and platforms quickly and apply them to the task at hand.
  • Excellent analytical skills, and strong communication and collaboration abilities.
  • Technical emphasis in including but not limited to Java, Ruby on Rails, Documentum and Alfresco
    in both Linux and Windows based environments

Recent Posts

Newsletter