Filtering for self-reference hierarchy in gridview

[thuy]

Hello,



I have displayed in datagridview with data in self-reference hierarchy. For example, I have data in the gridview ad the below:

Node1

    Node 1.1

    Node 1.2

        Node 1.2.1

        Node 1.2.2

            Node 1.2.2.1

.....



When I click filtering icon in the header column. The filtering dialog
doesn't display the same structure in the datagridview. It just displays
as the below in filtering dialog.

All

    Node1

    Node 1.1

    Node 1.2



I expect the filtering dialog should display as same as the
datagridview. Please show me how to do. I also attach the screenshot for
more detail

Thannks

[Dess | Tech Support Engineer, Principal]

Hello Thuy,

Thank you for writing.

I confirm that the missing items for deeper levels in self-reference hierarchy is an issue in our RadGridView. I have logged it in our Feedback Portal. You can track its progress, subscribe for status changes and add your vote/comment to it on the following link - Feedback Item.

I have also updated your Telerik points.

Currently, the possible solution is to customize the filter popup via the RadGridView.FilterPopupInitialized event and the RadListFilterPopup.PopupOpened event. Thus, you can add the missing values:

DataTable dt = new DataTable();

public Form1()
{
    InitializeComponent();

    this.radGridView1.EnableFiltering = true;
    this.radGridView1.ShowHeaderCellButtons = true;

    this.radGridView1.Relations.AddSelfReference(this.radGridView1.MasterTemplate, "ID", "ParentID");

    dt.Columns.Add("ID", typeof(int));
    dt.Columns.Add("Title", typeof(string));
    dt.Columns.Add("ParentID", typeof(int));

    for (int i = 1; i <= 5; i++)
    {
        dt.Rows.Add(i, "Parent." + i, 0);
    }

    Random rand = new Random();
    for (int i = 6; i < 20; i++)
    {
        dt.Rows.Add(i, "Child." + i, rand.Next(1, 6));
    }

    for (int i = 20; i < 40; i++)
    {
        dt.Rows.Add(i, "SubChild." + i, rand.Next(6, 20));
    }

    this.radGridView1.DataSource = dt;
    this.radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
}

string columnName = string.Empty;
private void radGridView1_FilterPopupInitialized(object sender, FilterPopupInitializedEventArgs e)
{
    RadListFilterPopup popUp = e.FilterPopup as RadListFilterPopup;
    columnName = e.Column.FieldName;
    if (popUp != null)
    {
        popUp.PopupOpened -= popUp_PopupOpened;
        popUp.PopupOpened += popUp_PopupOpened;
    }
}

private void popUp_PopupOpened(object sender, EventArgs args)
{
    RadListFilterPopup popUp = sender as RadListFilterPopup;
    popUp.MenuTreeElement.TreeView.Nodes.Last().Nodes.Clear();

    foreach (DataRow row in dt.Rows)
    {
        RadTreeNode node = new RadTreeNode(row[columnName].ToString());
        node.Checked = true;
        popUp.MenuTreeElement.TreeView.Nodes.Last().Nodes.Add(node);
    }


}

Note that this is just a sample approach, which demonstrates the idea and it may not cover all possible cases. Feel free to modify it in a way which suits your scenario best.

I hope this information helps. Should you have further questions, I would be glad to help.

Regards,
Desislava
Telerik