OK - I'll try and make this sensible...
We have a requirement for users to be able to manage incidents/changes that they personally have not logged.
EG : Divisional Manager should be able to view all calls for their Division, including sub-departments.
Department Managers should be able to view all calls for their Department.
Incidents / Changes all have a location associated with them, and this takes the format of..
Company - Division - Department - SubDept
I can write a query which allows users to select records based on their choice of Location, but I need to be able to restrict it to their own area.
Each User has a link to the same Locations structure, so basically what I'd like to achieve is a Service Portal query, effectively,
SELECT (fields) WHERE
(im.incident.usr_locations) IS CATEGORY EQUAL TO (tps.user.usr_locations).
We're running ITBM 7.2.5, and I can't see how to achieve this.
The only way I can see is to hard-code locations into the queries, but this would be unmanageable, due to the number of groups and sub-groups involved - we're looking at up to 25,000 users.
Any pointers ?