This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Full Organizational View from Top-Down

I am getting a continual request from top-level managers to see all of the employees they are responsible in the Web Portal. Right now, they can only see their direct-reports which is based on who they are a Manger of in AD. They cannot see the direct-reports of their Managers., Has anyone ran into this scenario and know how to resolve it? I believe delegation can resolve it, but I can't see how the delegation can automatically apply to new employees or a change in organizational structure.

Thanks for any hints or point in the right direction!

-CK

Parents Reply
  • I don't see a way to take advantage of this procedure in the VI_Employee_Overview and the recursive CTE query doesn't work because you are in a "WHERE" statement already when adding the condition under the  "Employees which can be edited by the current user" key. I think the best way to approach this is to give the Top-level manager the "QERVEditEmployee" rights for all subordinate employees. The challenge is how to provision and de-provision those rights.

    -CK

Children
  • I used the recursive query (renamed) and it worked fine by setting VI_Employee_Person_Filter to:

    "uid_person in ( select uid_person from CCC_FTPersonSubordinate('%useruid%') )"

    The view QERVEditEmployee finds who has responsibility for an employee using the following criteria (1) if they are the manager of a department at/or above the employee's department (2) they are the manager of the employee. The responsibility can be delegated for both (1) and (2), but that means creating, and maintaining a lot of delegations. I would recommend it, I'd use the recursive query.

  • Thank you CraigHunter so much! I was approaching it wrong by trying to embed the CTE into the filter, but once I injected the table function as you did, it is working perfectly. I was able to see and modify subordinates. You made my week!

    -CK