Documentation Center

ItemReferenceCriteria (ASP.NET)

Use the ItemReferenceCriteria with NotInCriteria to query the Broker Storage for a specified item.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Tridion.ContentDelivery.DynamicContent.Query;
using Tridion.ContentDelivery.DynamicContent;

namespace TestTaxonomies
{
public partial class _Default : System.Web.UI.Page
{
	protected void Page_Load(object sender, EventArgs e)
	{

		// Create query
		Query myQuery = new Query();
		Criteria myCriteria = null;
		ItemReferenceCriteria itemReferenceCriteria = new ItemReferenceCriteria(56);
		ItemTypeCriteria itemTypeCriteria = new ItemTypeCriteria(64);
		NotInCriteria notInCriteria = new NotInCriteria(itemReferenceCriteria);
		AndCriteria andCriteria = new AndCriteria(notInCriteria, itemTypeCriteria);

		myCriteria = andCriteria;

		myQuery.Criteria = myCriteria;

		SortParameter sortParameter = new SortParameter(SortParameter.ItemTitle, SortParameter.Ascending);
		myQuery.AddSorting(sortParameter);
		myQuery.SetResultFilter(new LimitFilter(20));

		string[] itemURIs = myQuery.ExecuteQuery();

		foreach (string itemURI in itemURIs)
		{
			Response.Write(itemURI + ", ");
		}
	}
	}
}