PublicationCriteria (JSP)
Use PublicationCriteria and AndCriteria to query the broker storage for a specific Publication.
<%@ 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
String strTaxURI = "tcm:34-70-512";
int iPublicationID = 4;
Query myQuery = new Query();
Criteria myCriteria = null;
TaxonomyCriteria taxCriteria = new TaxonomyCriteria(strTaxURI);
PublicationCriteria pubCriteria = new PublicationCriteria(iPublicationID);
AndCriteria andCriteria = new AndCriteria(taxCriteria, pubCriteria);
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>