在利用FileNet API获取doucmnt实例总量时需要注意获取的是root folder(/),而要考虑UnfiledDocument中的document是否有用。例如,在zhy的某项目中UnfiledDocument下的文档虽然跟文档管理平台,但它里面却存储着Notes归档来的邮件附件。简单的查询操作,如下代码所示(注意PageIterator 的使用)。
public int queryTotal(ObjectStore os,String docType){
String sql = "select ID FROM " + docType + " d WITH INCLUDESUBCLASSES WHERE d.This INSUBFOLDER '/' ";
SearchSQL searchSql = new SearchSQL(sql);
SearchScope scope = new SearchScope(os);
PropertyFilter filter = new PropertyFilter();
FilterElement ele = new FilterElement(null, null, null, "ID", null);
filter.addIncludeProperty(ele);
RepositoryRowSet rows = scope.fetchRows(searchSql, null, filter, null);
Iterator iter = rows.iterator();
int count = 0 ;
while(iter.hasNext()){
iter.next();
count++;
}
return count;
}
public int queryRangeAmount(ObjectStore os,String docType,Date startDate,Date endDate){
String sql = "select ID FROM " + docType + " d WITH INCLUDESUBCLASSES WHERE (d.This INSUBFOLDER '/') AND " +
PropertyNames.DATE_CREATED + " >= " + dateFormat(startDate) +
" AND " +
PropertyNames.DATE_CREATED + " < " + dateFormat(endDate) ;
SearchSQL searchSql = new SearchSQL(sql);
SearchScope scope = new SearchScope(os);
PropertyFilter filter = new PropertyFilter();
FilterElement ele = new FilterElement(null, null, null, "ID", null);
filter.addIncludeProperty(ele);
RepositoryRowSet rows = scope.fetchRows(searchSql, null, filter, null);
Iterator iter = rows.iterator();
int count = 0 ;
while(iter.hasNext()){
iter.next();
count++;
}
return count;
}
private String dateFormat(Date date){
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
String dateStr = sdf.format(date);
sdf = new SimpleDateFormat("HHmmss");
dateStr = dateStr + "T" + sdf.format(date) + "Z";
return dateStr;
}
public void testQueryTotalByDocType(){
String sql = "select ID FROM CompanyDoc d WITH INCLUDESUBCLASSES WHERE d.This INSUBFOLDER '/' ";
SearchSQL searchSql = new SearchSQL(sql);
SearchScope scope = new SearchScope(os);
PropertyFilter filter = new PropertyFilter();
FilterElement ele = new FilterElement(null, null, null, "ID", null);
filter.addIncludeProperty(ele);
RepositoryRowSet rows = scope.fetchRows(searchSql, 1000, filter, true);
Iterator iter = rows.iterator();
int count = 0 ;
PageIterator pageIterator = rows.pageIterator();
while(pageIterator.nextPage()){
count = count + pageIterator.getElementCount();
}
logger.info("count is : " + count );
}