How to display only "active" references in References

Question

Have a few use cases for this question.

We have a schema/object type of Employee with Manager as an attribute of the Employee which is a self object reference back  to the object type of Employee.

If you are the Manager you would have inbound references of other Employees, including those that have a status of Terminated.

Is it possible to alter the view from the Manager Employee object so they only see the Active employees from their Asset page.  Without removing the Manager's name from  the Manager attribute in their former reportee's Employee object. We use that information if there are outstanding assets/actions/tickets left connected to the former employee.

TIA

Michael Frade · Answer

Another use case is that we have team attributes, which exists on the employee record. When you look at the team and see the inbound refs - it shows all employees ( active and terminated) as part of the Team object.

Marc -Devoteam- · Answer

Hi @Michael Frade

Correct, but this is based on your setup.

Otherwise with other references this will work.

So in your case there is no solution as your relations, in a way are a loop from employee to manger and from manager back to employee

Michael Frade · Answer

I don't believe that would work.  The object is the employee and the attribute is Manager.  So if a Manager was to look at their own employee object they would have inbound references for employees that report to them.  Filtering on the attribute as you suggest, would only limit the ability to select an "active" employee as a manager.  The manager would still see inbound references to them from terminated employees no?