Documentation Center

NumericalRangeCriteria (JSP)

Use NumericalRangeCriteria to retrieve content which has a specific custom metadata value within the specified range of values.

<%@ page language="java" contentType="text/html; charset=UTF-8"%>
<%@page import="com.tridion.broker.StorageException,
com.tridion.broker.querying.*,
com.tridion.broker.querying.criteria.*,
com.tridion.broker.querying.criteria.categorization.*,
com.tridion.broker.querying.criteria.content.*,
com.tridion.broker.querying.criteria.metadata.*,
com.tridion.broker.querying.criteria.operators.*,
com.tridion.broker.querying.criteria.taxonomy.*,
com.tridion.broker.querying.filter.LimitFilter,
com.tridion.broker.querying.sorting.SortParameter"%>

<%@ taglib uri="http://www.sdl.com/delivery/tags/cd/2.0" prefix="tridion" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
		<title></title>
	</head>
<%
	//Create query
	Query myQuery = new Query();

	Criteria myCriteria = null;
	NumericalRangeCriteria numericalRangeCriteria = new NumericalRangeCriteria("Number", 0, 1000);
	//return all items with float value custom metadata

	ItemTypeCriteria itemTypeCriteria = new ItemTypeCriteria(16);
	//only return components

	AndCriteria andCriteria = new AndCriteria(numericalRangeCriteria, itemTypeCriteria);

	myCriteria = andCriteria;

	myQuery.setCriteria(myCriteria);

	SortParameter sortParameter = new SortParameter(SortParameter.ITEMS_TITLE, SortParameter.ASCENDING);

	myQuery.addSorting(sortParameter);
	myQuery.setResultFilter(new LimitFilter(20));


	String[] itemURIs = myQuery.executeQuery();
	String strOutput = "";
	for (int i = 0; i < itemURIs.length; i++) {
		strOutput += itemURIs[i] + ", ";
	}
%>
	<body>
		<%=strOutput%>
	</body>
</html>