Multi-Level Hierarchy

[#1]

Hello,

I am trying to display a multi-level hierarchy listbox by using the 'Hierarchy load' technique that looks like this:

Business Development ->Worldwide Sales ->Americas -> US Repair -> Korea Repair

Following is the script:

Group:

Hierarchy

(GROUP_ID, RELATED_GROUP_ID, GROUP_NAME, PARENT_NAME, GROUP_NAME, [Group Hierarchy]

)

LOAD

RELATED_GROUP_ID

,

GROUP_ID

,

RELATED_GROUP_NAME

,

GROUP_NAME

,

RESOURCE_NAME

RELATED_GROUP_ID is the Parent ID and GROUP_ID is the child ID.

//......................................................................................................................

My issue is that it is able to get the list box in the desired manner. However, it gets only one Resource_Name value from each hierarchy and totally excludes the others in the load.

Any ideas?

[#2]

Just to elaborate, suppose there are 10 resources available at Business Development -> Worldwide Sales -> Americas level, it will only bring the first resource and exclude the rest 9.

Amit

[#3 · Accepted solution]

I figured it out! All I had to do was load the Resource ID and Resource Name as a separate table joined to the Group ID.

Amit