Hierarchical portlet is used for object and sub object relation. I have a requirement where I have to show list of other timesheet approvers if I am not able to approve. I would pass resource id as parameter. We are using Timesheet OBS. So I can have more than 10 other approvers for timesheet. Whether It is possible to show in Hierarchical way
Resource_name resource_email Primary_approver
Primary approver 2
If I my Timesheet obs is A with manager as B then my other approvers will be c,d,e who are there in timesheet obs A.
So I can pass the resource id in first query block to get resource primary approver and obs parent id. How can I pass the parent id obs in the second union block to get other approvers?
Right now I have concatenated all other approvers to show in single line.