OnActivate Trigger selection prevents access to sheet
Hi,
In my qvw on certain sheets have an OnActivate trigger which Select In Field. Field is ROLE and Search String is (KAM|AM). Works fine for me and users who have access to data for both 'KAM' and 'AM' ROLE's. But a user who only has 'KAM' ROLE (using data reduction) cannot enter the sheet, presumably because the selection fails or runs into security issue.
If the Search String is (KAM|abc) where abc isn't a valid entry for ROLE, the user can enter the sheet and it selects KAM.
Is this a bug. I'd like the security to prevent the user seeing the 'AM' data, but not being locked out of the sheet entirely as they can see 'KAM' data. I can revert to using macro's or other workaround, but like to know if there is a better solution.
