Has anyone been able to create a "derived" column on a list using configuration console? Our users are asking to include the effective date from actions that are sent to the inbasket. For instance a Change Relationship action would need to pull the effective date field from the Employee business class. A position change request action would need to pull the effective date from the Position business class, a Work Assignment change request would need to pull the effective date from the WorkAssignment business class and so on. They want one effective date field and based on the action, display the appropriate effective date. Has anyone done anything like this before? From the research that I have done, it doesn't appear you can do this without creating some type of relationship table modifying all the flows/actions to write to these tables, then add the column to the list. Sound how the FilterKey and FilterValue fields work today in the PFIQUEUETASK table. Am I making any sense or am I way off base?
