学步园

在利用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 );
		
	}