[Solved] Self Referencing hierarchy grid issue

[Mohan]

I have the  Person class with the following fields which reflects the table structure.
field               datatype
Id                   long
Name             string
Title               string
Supervisor     long


I want to build a self referencing grid. I keep getting the following error

System.Data.SyntaxErrorException: Syntax error in Lookup expression: Expecting keyword 'Supervisor' followed by a single column argument with possible relation qualifier: Supervisor[(<relation_name>)].<column_name>.


I have tried the various combinations of filterexpression in the Page_load event but none seem to work.

 RadGrid1.MasterTableView.FilterExpression = "Supervisor = 0";
 RadGrid1.MasterTableView.FilterExpression = "it.Supervisor = 0";

I am populating ICollection<Person> and setting it to the RadGrid1 datasource property.

I am not sure what is causing this error. I have looked through the forums but havent found any help in this matter.

Thanks

[Georgi Krustev]

Hello Mohan,

You can try to set EnableLinqExpressions to "false". If you need to show only root items you can try use this code snippet:

RadGrid1.MasterTableView.FilterExpression = "Supervisor IS NULL";

I will suggest you examine this online demo devoted on the same matter. For your convenience I have attached a test project which implements the required functionality.

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.

[Truong Pham]

I have the same above problem and I tried to change EnableLinqExpressions to "false" and it works. Thanks