Slice Filters

Rahul_Sanghavi · 06-03-2021 10:37 PM

I have a users table, which maintains list of users and roles. These roles are more than one and is a enumlist.

I have a table where i store the menu structure of the app. Each menu item has roles defined.

I have created slice where i need to filter data based on user roles.

I have used below formula

and([Screen]=“Masters”,in(any(logged_user[role]),[Roles]))

At times this doesnt work.

Please assis.

Steve

In what way doesn’t it work?

Rahul_Sanghavi

I have created few forms/views. i wish to restrict these based on roles defined for each users. i have created a table for all form/views and use deeplinks to show these. i have added the roles in this table also.

now i want to show or hide the forms based on the user roles and roles defined in the menu table.

for example.

user “Rahul Barve” can access forms assigned to “planning” and “production” since in user master is have assigned him those two.
in the second screenshot, i have tagged forms which can be accessed by which roles.

i hope i was able to make you understand.

i have found some solution right now which is as under:

and([Screen]=“Home”,

IF(
COUNT(logged_user[role])=1,
CONTAINS([roles], ANY(logged_user[role])),
IF(
COUNT(logged_user[role])=2,
OR(
CONTAINS([roles], INDEX(logged_user[role], 1)),
CONTAINS([roles], INDEX(logged_user[role], 2))),
IF(
COUNT(logged_user[role])=3,
OR(
CONTAINS([roles], INDEX(logged_user[role], 1)),
CONTAINS([roles], INDEX(logged_user[role], 2)),
CONTAINS([roles], INDEX(logged_user[role], 3))),
OR(
CONTAINS([roles], INDEX(logged_user[role], 1)),
CONTAINS([roles], INDEX(logged_user[role], 2)),
CONTAINS([roles], INDEX(logged_user[role], 3)),
CONTAINS([roles], INDEX(logged_user[role], 4))))))
)

Steve

Maybe this?

ISNOTBLANK(
  INTERSECT(
    logged_user[role]
    [roles]
  )
)