public class XmlFilter : XmlFilterObject

Public Class XmlFilter
	Inherits XmlFilterObject

int CategoryID = 168;
//Create a new instance of the XmlFilter object
ContentStudio.Document.EPT.XmlFilter xfi = new ContentStudio.Document.EPT.XmlFilter(CS_ConnectionId, CS_UserSessionId, CategoryID);
//Add the two fields that return data first the default String datatype
xfi.AddField("Head", true);
xfi.AddField("Intro", true);
//Add fields to filter and sort on that does not return data
xfi.AddField("Area", ContentStudio.Document.EPT.XmlIndexQuery.QueryDataTypes.Integer);
xfi.AddField("CS_PublishDate", ContentStudio.Document.EPT.XmlIndexQuery.QueryDataTypes.DateTime);
//Define a criteria and a sort command
xfi.FilterCriteria = "[Area] > 1173";
xfi.SortCommand = "[CS_PublishDate] DESC";
//Limit the number of records
xfi.PageSize = 10;

Response.Write("<table>" + Environment.NewLine);
//perform the filter operation and read the data using an XmlFilterReader
//until the last page has been reached
do
{
    using (XmlFilterReader xre = xfi.FilterReader())
    {
        //Get the data
        while (xre.Read())
        {
           Response.Write("<tr>" + Environment.NewLine);
           Response.Write("<td>" + Server.HtmlEncode(xre["Head"]) + "</td>");
           Response.Write("<td>" + Server.HtmlEncode(xre["Intro"]) + "</td>");
           Response.Write("</tr>" + Environment.NewLine);
        }
    }
    //Move to the next data page
    xfi.PageNumber++;
}(while xfi.PageNumber <= xfi.PageCount);
Response.Write("</table>" + Environment.NewLine);

Dim CategoryID As Integer = 168
'Create a new instance of the XmlFilter object
Dim xfi As New ContentStudio.Document.EPT.XmlFilter(CS_ConnectionId, CS_UserSessionId, CategoryID)
'Add the two fields that return data with the default String datatype
xfi.AddField("Head", true)
xfi.AddField("Intro", true)
'Add fields to filter and sort on that does not return data
xfi.AddField("Area", ContentStudio.Document.EPT.XmlIndexQuery.QueryDataTypes.Integer)
xfi.AddField("CS_PublishDate", ContentStudio.Document.EPT.XmlIndexQuery.QueryDataTypes.DateTime)
'Define a criteria and a sort command
xfi.FilterCriteria = "[Area] > 1173"
xfi.SortCommand = "[CS_PublishDate] DESC"
'Limit the number of records
xfi.PageSize = 10
Response.Write("<table>" & Environment.NewLine)
'perform the filter operation and read the data using an XmlFilterReader
'until the last page has been reached
Do
   Using xre As XmlFilterReader = xfi.FilterReader()
     'Get the data
     While xre.Read()
        Response.Write("<tr>" & Environment.NewLine)
        Response.Write("<td>" & Server.HtmlEncode(xre("Head")) & "</td>")
        Response.Write("<td>" & Server.HtmlEncode(xre("Intro")) & "</td>")
        Response.Write("</tr>" & Environment.NewLine)
     End While
   End Using
   'Move to the next data page
   xfi.PageNumber += 1
While xfi.PageNumber <= xfi.PageCount
Response.Write("</table>" & Environment.NewLine)