AnsweredAssumed Answered

Heirarchy Portlet - Data on one table

Question asked by bfarquhar on May 18, 2011
Latest reply on May 19, 2011 by Chris_Hackett
Experts,
I'm trying to build my first Hierarchical Portlet and having some troubles. What I'm trying to do is a bit different. All the examples I have seen pull the hierarchy from 2 tables. I'm trying to pull it from one table. I'm wondering if it is even possible to build a Hierarchy portlet based on 2 fields in the same table ?
Here is an example... Assume these fields are on the same table.

Field 1........... Field 2
A ..................1
A.................. 2
A.................. 3
A.................. 4
B.................. 1
B.................. 3
B.................. 5
B.................. 7

I want to be able to expand field 1 to see the values in field 2.

So it would look like this...
A
B
..................1
..................3
..................5
..................7

Can anyone assist with the NSQL code for this ?

Thanks,
Ben

Outcomes