Setting the parent in the middle of a tree

[Chris]

Hi there.

I have a large organisational structure. When I load my page showing details of an item half way down the tree I want to load my RadTreeList using the selected item as the parent so that it only shows the current item as the parent and then all its children. Anything above it is ignored. So I'm specifying a dynamic starting parentID essentially

Thanks
Chris

[Veli]

RadTreeList does not support specifying the default values for the keys of root items. It looks for items whose data key values have a default value (e.g.  0 for int, null for nullable, etc.) If you need to specify a set of data items that do not have items that qualify as root in RadTreeList terms, you need to modify your data. For example, you can iterate over the data items, identify the roots, set their data key values to their defaults and add the modified items in a custom collection. Then you can pass RadTreeList this modified collection when databinding.

Veli
the Telerik team

[Chris]

I created an easy SQL only solution to setting the TreeList control to whatever point within my org tree.

Using a CASE statement in my select statement, if the ChildID equals where I want to start my tree I set the ParentOUID to 0. E.g.

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" SelectCommand="SELECT TOP (100) PERCENT dbo._OFLENZ0001OURelationship.OUFacilityID, CASE WHEN dbo._OFLENZ0001OU.OUID = @OUID THEN 0 ELSE dbo._OFLENZ0001OURelationship.ParentOUID END as ParentOUID, dbo._OFLENZ0001OU.OUID, dbo._OFLENZ0001OU.TenantID, dbo._OFLENZ0001OU.OrganisationName, dbo._OFLENZ0001OU.OUCode, dbo._OFLENZ0001OU.Address, dbo._OFLENZ0001OU.City, dbo._OFLENZ0001OU.OUGUID FROM dbo._OFLENZ0001OU INNER JOIN dbo._OFLENZ0001OURelationship ON dbo._OFLENZ0001OU.OUID = dbo._OFLENZ0001OURelationship.ChildOUID WHERE (dbo._OFLENZ0001OURelationship.IsProgramRelatedRelationship = 0) AND (dbo._OFLENZ0001OU.TenantID = 2) ORDER BY dbo._OFLENZ0001OU.TenantID, dbo._OFLENZ0001OU.OUID">
    <SelectParameters>
        <asp:QueryStringParameter Name="OUID" QueryStringField="o" DbType="Int32" />
        <asp:SessionParameter Name="TenantID" SessionField="TenantID" DbType="Int32" />
    </SelectParameters>
</asp:SqlDataSource>

Hope this helps someone.

Cheers
Chris