I have approximately 3 tables that the same concept needs to be applied to. All 3 tables are different types of reports, where while the Status is ‘Pending’ where only the person that entered the report or userrole of Admin should be able to perform ALL UPDATES.
The table Update Mode is set as follows:
I set up a slice for Pending Reports with the Update permissions as follows:
Now I also wanted to set up a slice for only ‘Complete’ reports with a filter condition of Status = “Complete”, but it is then that I noticed I am not able to set the ‘Update mode’ as conditional. My intent was to allow ALL UPDATES for ‘Admin’ userrole only and READ ONLY for everyone else.
So the possible solutions I have come up with are:
Create a second application for ‘Admin’ userrole only. Cons: Having to maintain a second application.
Use conditional navigation in conjunction with slices for reports in ‘Complete’ status, as in if ‘Admin’ go to view X otherwise go to view Y. In this case I would navigate to ‘Complete’ report slice ‘Read Only’ for all users but Admins and a second slice for ‘Complete’ reports that allows ‘All Updates’. Cons: Possible wider spread security issues.
Is there another solution to this that I am missing? I am really hesitant to create another application for this just because of the possible maintenance aspect.