Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I need to Create section access based on department name and all the employee levels.
Example: Employee Shelli Baida needs to see two departments (RnD, HR).
anyone any suggestions? I think maybe first creating crosstable and then section access..
departmen_name | primary_owner | additional_view1 | additional_view2 | additional_view3 |
IoT | Steven King | Neena Kochhar | Diana Lorentz | Sarah Bell |
Security | Alexander Hunold | |||
Products | David Austin | Lex De Haan | Neena Kochhar | |
RnD | Alexander Hunold | Bruce Ernst | Shelli Baida | Diana Lorentz |
Sales | Steven King | |||
Operation | David Austin | Ellen Abel | ||
HR | Steven King | Amit Banda | Shelli Baida | Hermann Baer |
If it's just these three, you could load them in four passes:
Load departmen_name, primary_owner as USER
JOIN
Load departmen_name, additional_view1 as USER
etc.
If there's a larger number of potential addtional_view, then yes, you'll need to get this into a standard table rather than a crosstable, and then use that.