How to get the count of documents for the object store using FileNet API's

Question

I have more than a million documents in object store, and I want to know the count of documents for a specific time period. How can I get the count using FileNet CE api's

The code I use is below, which gives me only a maximum of 200 documents.

--Code
SearchScope scope= new SearchScope(obj);
SearchSQL sql= new SearchSQL();
sql.setMaxRecords(100000);
String query="select * from document where datecreated >(date)";
RepositoryRowSet res= scope.fetchRows(sql,1000,null,null);
int count=0;
PageIterator p= result.pageIterator();
while(p.nextPage){
count+=p.getElementCount();a
}

If maximum result number is the issue, please, consider this also: https://stackoverflow.com/questions/54311405/setting-maximum-results-number-via-fem — Andrea, Nov 05 '21 at 10:35

score 1 · Answer 1 · edited Sep 23 '21 at 19:21

1

It is possible to use COUNT() function in background searches:

select COUNT(Id) from Document

Link to SQL syntax for background search query

Working with background search queries via API

Or, you can use a direct database connection and find the count of documents using documented database tables schema from DocVersion table.

Table schema - DocVersion

edited Sep 23 '21 at 19:21

ﾤﾡ

5,669
6
43
57

answered Aug 19 '21 at 09:44

swepss

481
3
9

How to get the count of documents for the object store using FileNet API's

1 Answers1