Retrieve only the lowest levelfrom the tree prompt

[sccheong]

Hi,

Please find the following hierarchy:

Company (root)
Zone (Level 1)
Region (Level 2)
Country (Level 3)
Branch (Level 4)

sample data:
Asia Pacific Zone
   Australia
     Australia
         Brisbane
         Sydney
         Melbourne
         Perth
   North Asia
      Japan
         Tokyo

When user does multiselect from the tree prompt at any level, only retrieve the lowest level, example user selected Australia (Level 3 -  Country) and Tokyo (Level 4 - Branch), the expected results is as follow:

Brisbane
Sydney
Melbourne
Perth
Tokyo

Can anyone tell the function or any way to achieve this.

Would really appreaciate if anyone would help :)

[cognostechie]

Check this:

http://www.cognoise.com/community/index.php/topic,10840.msg35568.html#msg35568