Security Profile - Custom Criteria
Summary
SQL not working correctlyContent
I have the following script for some employees to only see certain people in reporting.... The issue I am having is if someone was in a prior role, left the company in that role and is now in a new role, they show. For example. we have an employee who is now in HR. She was an intern in a different BU, and left the company then rejoined. When I add the script which is for HR folks to not see anyone in HR, she still shows. Any idea what I need to do to the SQL to correct that?
Tagged:
0