InCriteria (JSP)

The following is an example of using the InCriteria:

<%@ 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="/cd_tags.tld" 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;

        ItemReferenceCriteria itemReferenceCriteria = new ItemReferenceCriteria(56);

        ItemTypeCriteria itemTypeCriteria = new ItemTypeCriteria(64);

        InCriteria inCriteria = new InCriteria(itemReferenceCriteria);

        AndCriteria andCriteria = new AndCriteria(inCriteria, 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>