Custom criteria to hide employees on garden leave from directory view.
Summary:
We have a requirement to hide employees who are on Garden leave and we have created a custom criteria for the same. Putting the code here:
But when we have added this to the employee role, pages like - My activity center, check-ins, etc. started to fail and didn't load. We don't see the connection between the two, but we need some suggestions on this as to how such a requirement was handled.
Content (please ensure you mask any confidential information):
EXISTS
(select 1
from per_all_assignments_f paaf
where paaf.person_id = &TABLE_ALIAS.PERSON_ID
and trunc(sysdate) BETWEEN paaf.effective_start_date AND paaf.effective_end_date