Search code examples
javadb2filenet-p8filenet-content-engine

FileNet: Count of total documents in a FileNet Folder

I am working on a FileNet project where I need to display the count of documents in a folder named Others. I can do it easity via CE API but I need to know where this information is stored in FileNet DB.

The document count I can get from a table called DocVersion, the folder information is stored at Container table. What I need is a query that goes like:

SELECT COUNT(*) FROM DOCVERSION D, CONTAINER C WHERE --container name is 'Others'

Any help would be highly appreciated.

Solution

  • I have not try the code in application but, it will be like..

    SELECT count (*) as Row_Count

FROM Container c, DocVersion d

WHERE c.object_id = d.object_class_id

AND c.name = 'Others'

    Hope this will help you with your idea.