[Solved] Show child records without parent in Self-referencing Hierarchy grid.

[Jason Maronge]

I am implementing a Self-referencing Hierarchy grid and it works great for showing the parent and child relationships.  The two columns used are ID and ParentID.  I have to allow my users to search for items in the grid and since I have a filter expression of

MasterTableView.FilterExpression = "ParentID IS NULL";

this causes the child items to appear under the parent.  Problem is that if say someone changes a lastname and searches by lastname, the query will only bring back the child record, and since the filter is set, it will never show the child record.  Is there anyway to show the children if they do not have a parent?  Hopefully this makes sense to someone.

Thanks,

Jason

[Georgi Krustev]

Hello Jason,

Unfortunately the behavior you are trying to achieve is not possible. The applied filter will show only parent rows at first level. Hence the child rows could not be shown in the grid without parent row. To achieve your goal you need to avoid using this format string.

Best regards,
Georgi Krustev
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.