Tech Kraft

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

DQL:How to get count of all documents by folder

Here is how to get a count of all the documents in a cabinet by folder:

select count(*), f.r_folder_path from dm_document d, dm_folder f

where d.i_folder_id = f.r_object_id and folder('/CABINET_NAME', descend)

and f.r_folder_path is not nullstring

group by f.r_folder_path

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