Hi All,
Getting myself a little stuck here - just wondering if someone can help with a quick solution.
I am trying to update the configuration in IT Shop for "Employees for whom a request can be placed" - in theory my requirements are simple:
- If you are a manager, then you can place a request for your direct reports
- If you are in AERole = 'helpdesk', then you can place a request for anyone
For some reason, I don't seem to be able to get the SQL quite right. Tried a few different CASE statements, but it's not working.... does anyone have a simple SQL that I can use?
Thanks
Paul