Fill value tree from selection

Syntax:

Unload(<TabOrderType>) 
Parameters:

<TabOrderType> (optional)

Type: QueryResultIteration. 
Specifies the record tab order type for the selection.
Default value: Linear 
Returned value:

Type: ValueTable; ValueTree. 
If the tab type is Linear, the result is uploaded to the values table,
otherwise it is uploaded to the values tree.

   Query = New Query;
   Query.Text = 
      "SELECT
      |   Departments.Ref AS Department,
      |   Employees.Description AS HeadFullName
      |FROM
      |   InformationRegister.DepartmentHeads.SliceLast(&Period, ) AS DepartmentHeadsSliceLast
      |      LEFT JOIN Catalog.Departments AS Departments
      |      ON DepartmentHeadsSliceLast.Department = Departments.Ref
      |      LEFT JOIN Catalog.Employees AS Employees
      |      ON DepartmentHeadsSliceLast.Head = Employees.Ref";

   Query.SetParameter("Period", Period);

   QueryResult = Query.Execute();

   SelectionDetailRecords = QueryResult.Choose();

   While SelectionDetailRecords.Next() Do
      // Insert selection processing SelectionDetailRecords
   EndDo;

Query = New Query;
   Query.Text =
      "SELECT
      |   Departments.Ref AS Department,
      |   Employees.Description AS HeadFullName
      |FROM
      |   Catalog.Departments AS Departments
      |      LEFT JOIN InformationRegister.DepartmentHeads.SliceLast(&Period, ) AS DepartmentHeadsSliceLast
      |      ON DepartmentHeadsSliceLast.Department = Departments.Ref
      |      LEFT JOIN Catalog.Employees AS Employees
      |      ON DepartmentHeadsSliceLast.Head = Employees.Ref
      |
      |ORDER BY
      |   Departments.Ref HIERARCHY";

   Query.SetParameter("Period", CurrentDate());

   QueryResult = Query.Execute();

   YourTreeObject = FormAttributeToValue("YourTree");
   YourTreeObject = QueryResult.Unload(QueryResultIteration.ByGroupsWithHierarchy);
   ValueToFormAttribute(YourTreeObject, "YourTree");­