Regarding TreeView in ListBox

[#1]

Hello Guys,

Kindly help me with my problem in hierarchical data.

Actually I got a table with ParentEntityID and EntityID hierarchy. I have already created the hierarchy in the script but I was not able to show the hierarchy in the listbox.

Script for reference:

Hierarchy(EmployeeBusinessEntityID, ParentEmployeeBusinessEntityID, FirstName,ResourcePath,'|',PathDepth)

SQL SELECT BaseRate,

    BirthDate,

    CurrentFlag,

    DepartmentName,

    EmailAddress,

    EmergencyContactName,

    EmergencyContactPhone,

    EmployeeBusinessEntityID,

    EndDate as Employee_EndDate,

    FirstName,

    Gender,

    HireDate,

    LastName,

    MaritalStatus,

    MiddleName,

    ParentEmployeeBusinessEntityID,

    PayFrequency,

    Phone,

    SalariedFlag,

    SalesPersonFlag,

    SalesTerritoryKey,

    SickLeaveHours,

    StartDate as Employee_StartDate,

    Status,

    Title,

    VacationHours

FROM Employee;

After reload,I created a listbox for ResourcePath field with tree view check box enabled but still, I am not getting the tree view in the list box.

Kindly let me know if you know any possible solutions

Thanks

Kiru

[#2 · Accepted solution]

PFA. You need to adjust the script according to your columns.

[#3]

[tresesco]

The default separator in listbox for treeview is '/', have you changed it to '|' ?

[#5]

Thank you so much for all your helpful answers guys and I really appreciate your time!

Best,

Kiru