It doesn't quite work. I see that the access level is now checked, but that call to return $rows still comes up empty, and so the dropdown is then built with all possible values of categories, instead of only auth'ed categories.
I'm thinking that the query needs to look like this:
(id IN (0)
OR id IN (SELECT DISTINCT category_id FROM #__helpdeskpro_tickets AS t WHERE t.staff_id =508)
OR access IN (1,1,2,17)
)
since this way you only get categories if he's a staff member assigned to thaat category OR he is given access via usergroup.
My Groups and Levels look like this:
Groups:
- Registered
-- Group 1 (22)
-- Group 2 (23)
-- Group 3 (24)
Levels:
Group 1 -> Level 1 (19)
Group 2 -> Level 2 (18)
Group 3 -> Level 3 (17)
And then in the helpdesk categories:
Cat 1 -> Level 1
Cat 2 -> Level 2
Cat 3 -> Level 3
My Test User (id=508) belongs to Group 3, but his listview category dropdown shows all categories.
I also saw that if a user is only a member of Registered, then again the listview dropdown contains all categories.
Paul
