Is there a way in LPL to pull a field based on another field?

Hannah Johnson

Is there a way in LPL to pull a field based on another field?

Example:

From the WorkAssignment, I want to pull the Hierarchy of Management from ReportingRelationship from top to bottom and add to a derived field for File Creation Utility.

My thought was taking the Max level and subtracting for each level, so example below is looking at Level 3 from top down.

return (RREmployeeRel.ReportingRelation.ManagerEmpID) when (RREmployeeRel.Level =  max(RREmployeeRel.Level - 2))

cleverly

Are you looking for all the individual steps on the org chart, or just the 2nd from the top?

In this hypothetical situation: Alice (CEO) supervises Bob (CIO), and Bob supervises Charlie (IT Director) who in turn supervises David (IT Manager) who manages Eve (IT Analyst).

If you were looking at Eve's work assignment, would you want the derived field to return Charlie's ID (he's 3rd down from the top)? Or a list of ID's for Alice, Bob, and Charlie?

What would want to see from Bob's work assignment, since there isn't someone two levels above him?