Programmatic filtering on Sever-side

Environment

Product

Telerik WebForms Grid for ASP.NET AJAX

Description

How can I filter the Telerik WebForms Grid programmatically on Sever-side (in CodeBehind) or apply a default filter on initial load?

Solution

To filter the Grid programmatically on Server-side, you will need to configure the Columns and trigger the Filter command by using the FireCommandEvent() method.

In this article, we will show examples for each Filter Type:

• Classic
• CheckList
• Combined
• HeaderContext

Example for applying default filter at initial load

• Apply Default Filter on Initial Load

Classic

When using the FilterType="Classic", you will need to:

Set the column's CurrentFilterFunction property to any function other than NoFilter.

C#

RadGrid1.MasterTableView.GetColumnSafe("OrderID").CurrentFilterFunction = GridKnownFunction.EqualTo;

VB

RadGrid1.MasterTableView..GetColumnSafe("OrderID").CurrentFilterFunction = GridKnownFunction.EqualTo

Access the column's filter Control within the GridHeaderItem and set its value to the value you would like to filter by.

C#

GridFilteringItem filteringItem = RadGrid1.MasterTableView.GetItems(GridItemType.FilteringItem).FirstOrDefault() as GridFilteringItem;

(filteringItem["OrderID"].Controls[0] as RadNumericTextBox).Value = 1;

VB

Dim filteringItem As GridFilteringItem = TryCast(RadGrid1.MasterTableView.GetItems(GridItemType.FilteringItem).FirstOrDefault(), GridFilteringItem)

CType(filteringItem("OrderID").Controls(0), RadNumericTextBox).Value = 1

Trigger the filter command using the FireCommandEvent(commandName, commandArguments) method of the GridFilteringItem object.

The FireCommandEvent() method parameters:

• The commandName parameter is the name of the command to be triggered, in this case Filter. You can also use the constant RadGrid.FilterCommandName which has the same value.
• The commandArguments parameter is a Pair object where:
  • First property requires the column's UniqueName.
  • Second property requires the string representation of the filter function.

C#

GridFilteringItem filteringItem = RadGrid1.MasterTableView.GetItems(GridItemType.FilteringItem).FirstOrDefault() as GridFilteringItem;

GridColumn orderIdColumn = RadGrid1.MasterTableView.GetColumnSafe("OrderID");

Pair filterArgs = new Pair()
{
    First = orderIdColumn.UniqueName,
    Second = orderIdColumn.CurrentFilterFunction.ToString()
};

filteringItem.FireCommandEvent(RadGrid.FilterCommandName, filterArgs);

VB

Dim filteringItem As GridFilteringItem = TryCast(RadGrid1.MasterTableView.GetItems(GridItemType.FilteringItem).FirstOrDefault(), GridFilteringItem)

Dim orderIdColumn As GridColumn = RadGrid1.MasterTableView.GetColumnSafe("OrderID")

Dim filterArgs As Pair = New Pair() With {
    .First = orderIdColumn.UniqueName,
    .Second = orderIdColumn.CurrentFilterFunction.ToString()
}

filteringItem.FireCommandEvent(RadGrid.FilterCommandName, filterArgs)

The Filter command can only be triggered for one column at a time, however, this will filter multiple columns if they are all prepared in the same way as described above.

Example: Applying the filters on Button Click

C#

protected void RadButton1_Click(object sender, EventArgs e)
{
    GridTableView tableView = RadGrid1.MasterTableView;

    GridFilteringItem filteringItem = tableView.GetItems(GridItemType.FilteringItem).FirstOrDefault() as GridFilteringItem;

    if (filteringItem != null)
    {
        (filteringItem["OrderID"].Controls[0] as RadNumericTextBox).Value = 1;
        tableView.GetColumnSafe("OrderID").CurrentFilterFunction = GridKnownFunction.EqualTo;

        (filteringItem["ShipName"].Controls[0] as TextBox).Text = "Name 1";
        tableView.GetColumnSafe("ShipName").CurrentFilterFunction = GridKnownFunction.Contains;

        (filteringItem["ShipCountry"].Controls[0] as TextBox).Text = "Country 1";
        tableView.GetColumnSafe("ShipCountry").CurrentFilterFunction = GridKnownFunction.StartsWith;

        string columnUniqueName = "OrderID";
        string columnFilterFunction = GridKnownFunction.EqualTo.ToString();

        Pair filterArgs = new Pair()
        {
            First = columnUniqueName,
            Second = columnFilterFunction
        };

        filteringItem.FireCommandEvent(RadGrid.FilterCommandName, filterArgs);
    }
}

VB

Protected Sub RadButton1_Click(ByVal sender As Object, ByVal e As EventArgs)
    Dim tableView As GridTableView = RadGrid1.MasterTableView

    Dim filteringItem As GridFilteringItem = TryCast(tableView.GetItems(GridItemType.FilteringItem).FirstOrDefault(), GridFilteringItem)

    If filteringItem IsNot Nothing Then

        CType(filteringItem("OrderID").Controls(0), RadNumericTextBox).Value = 1
        tableView.GetColumnSafe("OrderID").CurrentFilterFunction = GridKnownFunction.EqualTo

        CType(filteringItem("ShipName").Controls(0), TextBox).Text = "Name 1"
        tableView.GetColumnSafe("ShipName").CurrentFilterFunction = GridKnownFunction.Contains

        CType(filteringItem("ShipCountry").Controls(0), TextBox).Text = "Country 1"
        tableView.GetColumnSafe("ShipCountry").CurrentFilterFunction = GridKnownFunction.StartsWith

        Dim columnUniqueName As String = "OrderID"
        Dim columnFilterFunction As String = GridKnownFunction.EqualTo.ToString()

        Dim filterArgs As Pair = New Pair() With {
            .First = columnUniqueName,
            .Second = columnFilterFunction
        }

        filteringItem.FireCommandEvent(RadGrid.FilterCommandName, filterArgs)
    End If
End Sub

CheckList

When using the FilterType="CheckList", you will need to:

Populate the column's ListOfFilterValues property with the desired values.

C#

RadGrid1.MasterTableView.GetColumnSafe("OrderID").ListOfFilterValues = new string[] { "1", "2", "3" };

VB

RadGrid1.MasterTableView.GetColumnSafe("OrderID").ListOfFilterValues = New String() {"1", "2", "3"}

Set the column's CurrentFilterFunction property to GridKnownFunction.EqualTo.

C#

RadGrid1.MasterTableView.GetColumnSafe("OrderID").CurrentFilterFunction = GridKnownFunction.EqualTo;

VB

RadGrid1.MasterTableView.GetColumnSafe("OrderID").CurrentFilterFunction = GridKnownFunction.EqualTo

FilterType="CheckList" only works with the filter functions GridKnownFunction.EqualTo (to filter) and GridKnownFunction.NoFilter (to clear the filter).

Trigger the Filter command using the FireCommandEvent(commandName, commandArguments) method of the GridFilteringItem object.

The FireCommandEvent() method parameters are:

• The commandName parameter is the name of the command to be triggered, in this case Filter. You can also use the constant RadGrid.FilterCommandName which has the same value.
• The commandArguments parameter is a Pair object where:
  • First property requires the column's UniqueName.
  • Second property requires the string representation of the column's filter function.

C#

GridFilteringItem filteringItem = RadGrid1.MasterTableView.GetItems(GridItemType.FilteringItem).FirstOrDefault() as GridFilteringItem;

GridColumn orderIdColumn = RadGrid1.MasterTableView.GetColumnSafe("OrderID");

Pair filterArgs = new Pair()
{
    First = orderIdColumn.UniqueName,
    Second = orderIdColumn.CurrentFilterFunction.ToString()
};

filteringItem.FireCommandEvent(RadGrid.FilterCommandName, filterArgs);

VB

Dim filteringItem As GridFilteringItem = TryCast(RadGrid1.MasterTableView.GetItems(GridItemType.FilteringItem).FirstOrDefault(), GridFilteringItem)

Dim orderIdColumn As GridColumn = RadGrid1.MasterTableView.GetColumnSafe("OrderID")

Dim filterArgs As Pair = New Pair() With {
    .First = orderIdColumn.UniqueName,
    .Second = orderIdColumn.CurrentFilterFunction.ToString()
}

filteringItem.FireCommandEvent(RadGrid.FilterCommandName, filterArgs)

The Filter command can only be triggered for one column at a time, however, this will filter multiple columns if they are all prepared in the same way as described above.

Example: Applying the filters on Button Click

C#

protected void RadButton1_Click(object sender, EventArgs e)
{
    GridTableView tableView = RadGrid1.MasterTableView;

    tableView.GetColumnSafe("OrderID").ListOfFilterValues = new string[] { "1", "2", "3" };
    tableView.GetColumnSafe("OrderID").CurrentFilterFunction = GridKnownFunction.EqualTo;

    tableView.GetColumnSafe("ShipName").ListOfFilterValues = new string[] { "Name 1", "Name 2", "Name 3" };
    tableView.GetColumnSafe("ShipName").CurrentFilterFunction = GridKnownFunction.EqualTo;

    tableView.GetColumnSafe("ShipCountry").ListOfFilterValues = new string[] { "Country 1", "Country 2", "Country 3" };
    tableView.GetColumnSafe("ShipCountry").CurrentFilterFunction = GridKnownFunction.EqualTo;

    GridFilteringItem filteringItem = tableView.GetItems(GridItemType.FilteringItem).FirstOrDefault() as GridFilteringItem;

    if (filteringItem != null)
    {
        string columnUniqueName = "ShipName";
        string columnFilterFunction = GridKnownFunction.EqualTo.ToString();

        Pair checkListFilterArgs = new Pair()
        {
            First = columnUniqueName,
            Second = columnFilterFunction
        };

        filteringItem.FireCommandEvent(RadGrid.FilterCommandName, checkListFilterArgs);
    }
}

VB

Protected Sub RadButton1_Click(ByVal sender As Object, ByVal e As EventArgs)
    Dim tableView As GridTableView = RadGrid1.MasterTableView

    tableView.GetColumnSafe("OrderID").ListOfFilterValues = New String() {"1", "2", "3"}
    tableView.GetColumnSafe("OrderID").CurrentFilterFunction = GridKnownFunction.EqualTo

    tableView.GetColumnSafe("ShipName").ListOfFilterValues = New String() {"Name 1", "Name 2", "Name 3"}
    tableView.GetColumnSafe("ShipName").CurrentFilterFunction = GridKnownFunction.EqualTo

    tableView.GetColumnSafe("ShipCountry").ListOfFilterValues = New String() {"Country 1", "Country 2", "Country 3"}
    tableView.GetColumnSafe("ShipCountry").CurrentFilterFunction = GridKnownFunction.EqualTo

    Dim filteringItem As GridFilteringItem = TryCast(tableView.GetItems(GridItemType.FilteringItem).FirstOrDefault(), GridFilteringItem)

    If filteringItem IsNot Nothing Then
        Dim columnUniqueName As String = "ShipName"
        Dim columnFilterFunction As String = GridKnownFunction.EqualTo.ToString()

        Dim checkListFilterArgs As Pair = New Pair() With {
            .First = columnUniqueName,
            .Second = columnFilterFunction
        }

        filteringItem.FireCommandEvent(RadGrid.FilterCommandName, checkListFilterArgs)
    End If
End Sub

Combined

The FilterType="Combined" is the combination of the Classic and CheckList filter types. Check out the CheckList and Classic sections for details.

Example: Applying the filters on Button Click

C#

protected void RadButton1_Click(object sender, EventArgs e)
{
    GridTableView tableView = RadGrid1.MasterTableView;
        
    GridFilteringItem filteringItem = tableView.GetItems(GridItemType.FilteringItem).FirstOrDefault() as GridFilteringItem;

    if (filteringItem != null)
    {
        // CheckList
        GridColumn orderIdColumn = tableView.GetColumnSafe("OrderID");
        orderIdColumn.ListOfFilterValues = new string[] { "1", "2", "3" };
        orderIdColumn.CurrentFilterFunction = GridKnownFunction.EqualTo;

        // Classic
        GridColumn shipNameColumn = tableView.GetColumnSafe("ShipName");
        shipNameColumn.CurrentFilterFunction = GridKnownFunction.Contains;

        TextBox shipNameFilterControl = (TextBox) filteringItem[shipNameColumn.UniqueName].Controls[0];
        shipNameFilterControl.Text = "Name 1";

        // Filter Args
        Pair filterArgs = new Pair()
        {
            First = shipNameColumn.UniqueName,
            Second = shipNameColumn.CurrentFilterFunction.ToString()
        };

        // Trigger the Filter Command
        filteringItem.FireCommandEvent(RadGrid.FilterCommandName, filterArgs);
    }
}

VB

Protected Sub RadButton1_Click(ByVal sender As Object, ByVal e As EventArgs)

    Dim tableView As GridTableView = RadGrid1.MasterTableView

    Dim filteringItem As GridFilteringItem = TryCast(tableView.GetItems(GridItemType.FilteringItem).FirstOrDefault(), GridFilteringItem)

    If filteringItem IsNot Nothing Then

        'CheckList
        Dim orderIdColumn As GridColumn = tableView.GetColumnSafe("OrderID")
        orderIdColumn.ListOfFilterValues = New String() {"1", "2", "3"}
        orderIdColumn.CurrentFilterFunction = GridKnownFunction.EqualTo

        'Classic
        Dim shipNameColumn As GridColumn = tableView.GetColumnSafe("ShipName")
        shipNameColumn.CurrentFilterFunction = GridKnownFunction.Contains
        Dim shipNameFilterControl As TextBox = CType(filteringItem(shipNameColumn.UniqueName).Controls(0), TextBox)
        shipNameFilterControl.Text = "Name 1"
    
        'Filter Args
        Dim filterArgs As Pair = New Pair() With {
            .First = shipNameColumn.UniqueName,
            .Second = shipNameColumn.CurrentFilterFunction.ToString()
        }

        'Trigger the Filter Command
        filteringItem.FireCommandEvent(RadGrid.FilterCommandName, filterArgs)
    End If
End Sub

HeaderContext

When using the FilterType="HeaderContext", the ContextMenu provides two options for filtering:

To filter using the CheckBoxList values, populate the column's ListOfFilterValues property with an array of string.

C#

RadGrid1.MasterTableView.GetColumnSafe("OrderID").ListOfFilterValues = new string[] { "1", "2", "3" };

VB

RadGrid1.MasterTableView.GetColumnSafe("OrderID").ListOfFilterValues = New String() {"1", "2", "3"}

To filter by the second option, which is located below the CheckBoxList (where you can use two different values and filter functions to create two different conditions) you will need to:

• Set the column's CurrentFilterValue and CurrentFilterFunction properties (first condition)
• Set the column's AndCurrentFilterValue and AndCurrentFilterFunction properties (second condition)

C#

GridColumn shipNameColumn = RadGrid1.MasterTableView.GetColumnSafe("ShipName");

// First Filter Condition
shipNameColumn.CurrentFilterValue = "Name 1";
shipNameColumn.CurrentFilterFunction = GridKnownFunction.Contains;

// Second Filter Condition
shipNameColumn.AndCurrentFilterValue = "Name 2";
shipNameColumn.AndCurrentFilterFunction = GridKnownFunction.Contains;

VB

Dim shipNameColumn As GridColumn = RadGrid1.MasterTableView.GetColumnSafe("ShipName")

'First Filter Condition
shipNameColumn.CurrentFilterValue = "Name 1"
shipNameColumn.CurrentFilterFunction = GridKnownFunction.Contains

'Second Filter Condition
shipNameColumn.AndCurrentFilterValue = "Name 2"
shipNameColumn.AndCurrentFilterFunction = GridKnownFunction.Contains

Once the columns are configured, trigger the Filter command using the FireCommandEvent(commandName, commandArguments) method of the GridHeaderItem object.

The FireCommandEvent() method parameters are:

• The commandName parameter is the name of the command to be triggered, in this case HeaderContextMenuFilter. You can also use the constant RadGrid.HeaderContextMenuFilterCommandName which has the same value.
• The commandArguments parameter is a Triplet object where:
  • First property requires the column's UniqueName
  • Second property is a Pair object where:
    • First property requires the string representation of the column's CurrentFilterFunction property value.
    • Second property requires column's CurrentFilterValue property value.
  • Third property is a Pair object where:
    • First property requires the string representation of the column's AndCurrentFilterFunction property value.
    • Second property requires column's AndCurrentFilterValue property value.

C#

GridHeaderItem headerItem = RadGrid1.MasterTableView.GetItems(GridItemType.Header).FirstOrDefault() as GridHeaderItem;

if (headerItem != null)
{
    GridColumn orderIdColumn = RadGrid1.MasterTableView.GetColumnSafe("OrderID");

    Triplet filterArgs = new Triplet()
    {
        First = orderIdColumn.UniqueName,
        Second = new Pair()
        {
            First = orderIdColumn.CurrentFilterFunction,
            Second = orderIdColumn.CurrentFilterValue
        },
        Third = new Pair()
        {
            First = orderIdColumn.AndCurrentFilterFunction,
            Second = orderIdColumn.AndCurrentFilterValue
        }
    };
    headerItem.FireCommandEvent(RadGrid.HeaderContextMenuFilterCommandName, filterArgs);
}

VB

Dim headerItem As GridHeaderItem = TryCast(RadGrid1.MasterTableView.GetItems(GridItemType.Header).FirstOrDefault(), GridHeaderItem)

If headerItem IsNot Nothing Then
    Dim orderIdColumn As GridColumn = RadGrid1.MasterTableView.GetColumnSafe("OrderID")

    Dim filterArgs As Triplet = New Triplet() With {
        .First = orderIdColumn.UniqueName,
        .Second = New Pair() With {
            .First = orderIdColumn.CurrentFilterFunction,
            .Second = orderIdColumn.CurrentFilterValue
        },
        .Third = New Pair() With {
            .First = orderIdColumn.AndCurrentFilterFunction,
            .Second = orderIdColumn.AndCurrentFilterValue
        }
    }
    headerItem.FireCommandEvent(RadGrid.HeaderContextMenuFilterCommandName, filterArgs)
End If

The Filter command can only be triggered for one column at a time, however, this will filter multiple columns if they are all prepared in the same way as described above.

Example: Applying the filters on Button Click

C#

protected void RadButton1_Click(object sender, EventArgs e)
{
    GridTableView tableView = RadGrid1.MasterTableView;

    // Filter the OrderID by Option 1
    tableView.GetColumnSafe("OrderID").ListOfFilterValues = new string[] { "1", "2", "3" };

    // Filter ShipName by Option 2
    GridColumn shipNameColumn = tableView.GetColumnSafe("ShipName");

    // First Filter Condition
    shipNameColumn.CurrentFilterValue = "Name 1";
    shipNameColumn.CurrentFilterFunction = GridKnownFunction.Contains;

    // Second Filter Condition
    shipNameColumn.AndCurrentFilterValue = "Name 2";
    shipNameColumn.AndCurrentFilterFunction = GridKnownFunction.Contains;

    GridHeaderItem headerItem = tableView.GetItems(GridItemType.Header).FirstOrDefault() as GridHeaderItem;

    if (headerItem != null)
    {
        string columnUniqueName = shipNameColumn.UniqueName;

        // First Filter Condition
        string currentFilterFunction = shipNameColumn.CurrentFilterFunction;
        string currentFilterValue = shipNameColumn.CurrentFilterValue;
        
        // Second Filter Condition
        string andCurrentFilterFunction = shipNameColumn.AndCurrentFilterFunction;
        string andCurrentFilterValue = shipNameColumn.AndCurrentFilterFunction;

        Triplet headerContextFilterArgs = new Triplet()
        {
            First = columnUniqueName,
            Second = new Pair()
            {
                First = currentFilterFunction,
                Second = currentFilterValue
            },
            Third = new Pair()
            {
                First = andCurrentFilterFunction,
                Second = andCurrentFilterValue
            }
        };
        headerItem.FireCommandEvent(RadGrid.HeaderContextMenuFilterCommandName, headerContextFilterArgs);
    }
}

VB

Protected Sub RadButton1_Click(ByVal sender As Object, ByVal e As EventArgs)

    Dim tableView As GridTableView = RadGrid1.MasterTableView

    'Filter the OrderID by Option 1
    tableView.GetColumnSafe("OrderID").ListOfFilterValues = New String() {"1", "2", "3"}

    'Filter ShipName by Option 2
    Dim shipNameColumn As GridColumn = tableView.GetColumnSafe("ShipName")

    'First Filter Condition
    shipNameColumn.CurrentFilterValue = "Name 1"
    shipNameColumn.CurrentFilterFunction = GridKnownFunction.Contains

    'Second Filter Condition
    shipNameColumn.AndCurrentFilterValue = "Name 2"
    shipNameColumn.AndCurrentFilterFunction = GridKnownFunction.Contains

    Dim headerItem As GridHeaderItem = TryCast(tableView.GetItems(GridItemType.Header).FirstOrDefault(), GridHeaderItem)

    If headerItem IsNot Nothing Then
        Dim columnUniqueName As String = shipNameColumn.UniqueName
        'First Filter Condition
        Dim currentFilterFunction As String = shipNameColumn.CurrentFilterFunction
        Dim currentFilterValue As String = shipNameColumn.CurrentFilterValue
        'Second Filter Condition
        Dim andCurrentFilterFunction As String = shipNameColumn.AndCurrentFilterFunction
        Dim andCurrentFilterValue As String = shipNameColumn.AndCurrentFilterFunction

        Dim headerContextFilterArgs As Triplet = New Triplet() With {
            .First = columnUniqueName,
            .Second = New Pair() With {
                .First = currentFilterFunction,
                .Second = currentFilterValue
            },
            .Third = New Pair() With {
                .First = andCurrentFilterFunction,
                .Second = andCurrentFilterValue
            }
        }
        headerItem.FireCommandEvent(RadGrid.HeaderContextMenuFilterCommandName, headerContextFilterArgs)
    End If
End Sub

Apply Default Filter on Initial Load

To apply a default filter at initial load, move the code in the PreRender event so this gets executed during the Page's LifeCycle.

Check out the following sections to learn how to filter the Grid depending on the selected FilterType

• Classic
• CheckList
• Combined
• HeaderContext

Use the IsPostBack condition to limit code execution for onetime, when the page loads at the first time, so users can filter the Grid without those being reset to the initial values.

Example: Applying the filters in the Grid's PreRender event

C#

protected void RadGrid_PreRender(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        RadGrid grid = (RadGrid) sender;

        GridTableView tableView = grid.MasterTableView;

        tableView.GetColumnSafe("OrderID").ListOfFilterValues = new string[] { "1", "2", "3" };
        tableView.GetColumnSafe("OrderID").CurrentFilterFunction = GridKnownFunction.EqualTo;

        tableView.GetColumnSafe("ShipName").ListOfFilterValues = new string[] { "Name 1", "Name 2", "Name 3" };
        tableView.GetColumnSafe("ShipName").CurrentFilterFunction = GridKnownFunction.EqualTo;

        tableView.GetColumnSafe("ShipCountry").ListOfFilterValues = new string[] { "Country 1", "Country 2", "Country 3" };
        tableView.GetColumnSafe("ShipCountry").CurrentFilterFunction = GridKnownFunction.EqualTo;

        GridFilteringItem filteringItem = tableView.GetItems(GridItemType.FilteringItem).FirstOrDefault() as GridFilteringItem;

        if (filteringItem != null)
        {
            string columnUniqueName = "ShipName";
            string columnFilterFunction = GridKnownFunction.EqualTo.ToString();

            Pair checkListFilterArgs = new Pair()
            {
                First = columnUniqueName,
                Second = columnFilterFunction
            };

            filteringItem.FireCommandEvent(RadGrid.FilterCommandName, checkListFilterArgs);
        }
    }
}

VB

Protected Sub RadGrid_PreRender(ByVal sender As Object, ByVal e As EventArgs)
    If Not IsPostBack Then

        Dim grid As RadGrid = CType(sender, RadGrid)
        Dim tableView As GridTableView = grid.MasterTableView

        tableView.GetColumnSafe("OrderID").ListOfFilterValues = New String() {"1", "2", "3"}
        tableView.GetColumnSafe("OrderID").CurrentFilterFunction = GridKnownFunction.EqualTo

        tableView.GetColumnSafe("ShipName").ListOfFilterValues = New String() {"Name 1", "Name 2", "Name 3"}
        tableView.GetColumnSafe("ShipName").CurrentFilterFunction = GridKnownFunction.EqualTo

        tableView.GetColumnSafe("ShipCountry").ListOfFilterValues = New String() {"Country 1", "Country 2", "Country 3"}
        tableView.GetColumnSafe("ShipCountry").CurrentFilterFunction = GridKnownFunction.EqualTo

        Dim filteringItem As GridFilteringItem = TryCast(tableView.GetItems(GridItemType.FilteringItem).FirstOrDefault(), GridFilteringItem)

        If filteringItem IsNot Nothing Then
            Dim columnUniqueName As String = "ShipName"
            Dim columnFilterFunction As String = GridKnownFunction.EqualTo.ToString()

            Dim checkListFilterArgs As Pair = New Pair() With {
            .First = columnUniqueName,
            .Second = columnFilterFunction
        }

            filteringItem.FireCommandEvent(RadGrid.FilterCommandName, checkListFilterArgs)
        End If

    End If
End Sub