So, I've been unsuccessful in finding an answer to this question so hopefully, someone can enlighten me as to how to set this up correctly.
Setup user security for a user to only see their information OR for a user to see ALL the areas.
To try and help with the concept and see if it can be done, i'll keep it simple.
I have a table of Clinics and a table of User Initial Values (the UIV table we define a userid = x clinic or the default of all).
Clinic Table User Intital Values
Clinic Name | Department UserID | Clinic Name
Cardiology Sub-Dept 1 John Cancer
Cardiology Sub-Dept 2 John Surgery
Cardiology Sub-Dept 3 Scott Cardiology
Cancer Sub-Dept 1 Carrie ALL
Cancer Sub-Dept 2
Surgery Sub-Dept 1
How do you setup a filter so that when John opens the board it will filter for Cancer and Surgery; Scott filters for Cardiology only; and Carrie should see ALL the clinics (Cardiology, Cancer and Surgery)? I know you can define this in the user filter and assign each person to a set of clinics - but not feasible with 400+ users.
Calculated Field 'User Clinics' : USERNAME() = [VUNET_ID]
* this works well when you add this to the Filter shelf and set it to 'True'. Only the clinics that the user is mapped to show up. But if you have ALL mapped as your 'Clinic' it returns 'False' and each user would have to remember to change this.
Calculated Field A : if (USERNAME() = [UserID] AND [CLINIC] = 'ALL') then 'False' else 'True' end
*not sure how I could use this to flag a filter for the clinics
Parameter A : listed all the clinics in a parameter, but parameters will only return one value - you can just compare against a list of values
So, I'm currently stuck at 50%. I don't want to have to map each user to a series of clinics (12-18 clinics for each user with 400+ users ... yeah, that's a big lookup table).
Thoughts on if this is possible would be greatly appreciated!
Thanks for ya'll time!