// uses my utility class to get repository, project area, and WI type refs 

ITeamRepository repo = getUtility().getRepo(true);

IProjectAreaHandle pa = getUtility().getProjectArea();

IWorkItemType wiType = getUtility().getWorkItemType();





// playing with these attributes

IQueryableAttribute paAttr = getAttribute(IWorkItem.PROJECT_AREA_PROPERTY);

IQueryableAttribute typeAttr = getAttribute(IWorkItem.TYPE_PROPERTY);

IQueryableAttribute rdateAttr = getAttribute(IWorkItem.RESOLUTION_DATE_PROPERTY);



// Need to know today for resolved by date use

java.util.Date dateToday = new java.util.Date();

java.sql.Timestamp timeToday = new java.sql.Timestamp(dateToday.getTime());



// Make simple expressions with the attributes - default WI type is Defect



Expression paExpr = new AttributeExpression(

		paAttr,	AttributeOperation.EQUALS, pa);

Expression typeExpr = new AttributeExpression(

		typeAttr, AttributeOperation.EQUALS, wiType.getIdentifier());

Expression rdateExpr = new AttributeExpression(

		rdateAttr, AttributeOperation.BEFORE, timeToday);



// Make a complex expression			

Term combined= new Term(Term.AND, new Expression[] { rdateExpr, paExpr, typeExpr});



// Setup and run query; check them for returned WI count

IQueryClient qc = (IQueryClient) repo.getClientLibrary(IQueryClient.class);

IQueryResult<IResolvedResult<IWorkItem>> result;



result = qc.getResolvedExpressionResults(pa, combined, IWorkItem.SMALL_PROFILE);



System.out.println("Combined expression query: "

		+ "(rdate, defect type, and pa specific) query found:"

		+ result.getTotalSize(null) + " WIs");