Root level filter also filters children

[tim]

This question concerns a self-refercing hierarchy as on http://www.telerik.com/help/aspnet/grid/grdselfreferencinghierarchy.html

When I apply this in page_load:
RadGrid1.MasterTableView.FilterExpression = "ParentID IS NULL"  (for an entitydatasource)
I get:

http://img704.imageshack.us/img704/8003/withi.jpg

When I remove the filterexpression,
// RadGrid1.MasterTableView.FilterExpression = "ParentID IS NULL"  (for an entitydatasource)
I get this:
http://img514.imageshack.us/img514/5739/without.jpg

How to solve this problem?

Thanks,
Tim

[Mira]

Hello Tim,

Please use the following code to implement the desired functionality and let me know whether it helps:

RadGrid1.MasterTableView.FilterExpression = "it.ParentID == null"; //if the ParentID is of type string
RadGrid1.MasterTableView.FilterExpression = "(it.ParentID == null)"; //if the ParentID is of type int

For additional information on operating with the FilterExpression of the RadGrid manually, you can take a look at this help topic.

Sincerely yours,
Mira
the Telerik team