beh wl 16.Apr.04 03:24 AM a Web browser General 3.0 Windows 2000
I need a view to display the user's hierarchy with other info in the application db.
I've created a relation "Initiator Department Hierarchy"
Form = "Department" & @ismember(@Input;CurrentMembersOS) & @isunavailable( InconsistentOS )
return = HierarchyTotalOS
To get the data, I added a custom attribute that get HierarchyTotalOS in the workflow.
@Relation([Initiator Department Hierarchy]; Notify_User)
The field in the org db is "dept one/dept two/team one"
But from the workflow, my form in app db gets "dept onedept twoteam one". So it's not possible to get the hierarchy.
1) Why the value (HierarchyTotalOS) change when workflow put the value into the custom field - without "/"?
2) How can I resolve this?
3) Is there any other easier way to get the hierarchy into to be display in the app db documents?