Intersoft Community - WebGrid Enterprise - Sorting Child Records on Self Referencing Table with LoadOnDemand

Sorting Child Records on Self Referencing Table with LoadOnDemand

yudi — Thu, 05 Nov 2009 23:51:49 GMT

Thank you for the sent simple sample. It helps a lot to describe the issue.

It seems that you forgot to set the value of a property called “ApplyChildSorting” to true.
WebGrid now introduces a new setting in SelfReferenceSettings object called ApplyChildSorting. This feature instructs WebGrid to perform sorting on the self referencing child when the column sorting action occurred.

<SelfReferencingSettings ChildDataMember="ReportsTo" Enabled="True" ExpandColumnMember="FirstName"
    LoadOnDemand="True" ParentDataMember="EmployeeID" ApplyChildSorting="True" />

Hope this help.

Sorting Child Records on Self Referencing Table with LoadOnDemand

handy@intersoftpt.com — Thu, 05 Nov 2009 22:33:20 GMT

Hi,

You will need to set ApplyChildSorting="true" at SelfReferencingSettings properties. The sorting should be working as expected with this way.

Regards,
Handy

Sorting Child Records on Self Referencing Table with LoadOnDemand

sfrench@sierradata.com — Thu, 05 Nov 2009 14:08:26 GMT

Hello,

Our application contains multiple grids using self referencing tables with a lot of records. The children are loaded on demand. We've notived that if you sort at the top level the child records are never sorted. Is there a way to enable sorting so all records are sorted by the selected column? You can see what we mean in the attached sample. Load the page, sort by name, then expand the children. No matter what order or direction the children always load in the same order. How can we get the child records to load in the direction requested?

Thanks!