xpath example 4

gistfile1.java

private String implementation4(String name, Category category, Long offset) throws CoreException
{
	StringBuilder b = new StringBuilder();
	
	//create the xpath
	XPath<Product> xpath = XPath.create(getContext(), Product.class)
			.subconstraint( Product.MemberNames.Product_ProductState , ProductState.entityName )
				.eq( ProductState.MemberNames.Published , true )
				.or()
				.eq( ProductState.MemberNames.PublishAnyway , true )
			.close()
			.and()
			.eq( Product.MemberNames.Product_Category , category )
			.and()
			.eq( Product.MemberNames.Name , name)
		.offset(offset.intValue())
		.addSortingAsc(Product.MemberNames.Nr);

	//count
	long count = xpath.count();
	b.append(count).append("\n");
		
	//retrieve all
	List<Product> products = xpath.all();
	
	Product first = xpath.first();
		
	//add number of the first
	if (first != null)
		b.append(first.getNr()).append("\n");
		
	//add descriptions of the others
	for(Product p : products) 
		b.append(p.getDescription()).append("\n");
		
	return b.toString();
}