Change report filter based on user role

[AleCerri]

Hello everyone,

I have a request about report filter. Is it possible to change report filter based on user role ? For example I have a report with filter but I would like that a user with specific role can read the result despite not satisfying the filters or set different report filter based on user role. Exist something like that ?

Thanks in advance.

[ersureshbe]

Hi,

Per mu understanding, there is no specific option to restrict the filter based on role. But you can try with ACLs

Regards,

Suresh.

[Community Alums]

Hi @AleCerri ,

You can opt for Interactive Filters. You can use a Related List Condition on sys_user_has_role to achieve this an Interactive Filter.

Also, There will be ACL's on Roles Related list table(sys_user_has_role) which might be stopping your access to see it.

May be this one

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[AleCerri]

Hi @Sandeep Dutta ,

thank you for your reply but my problem is different. I wanted to make dynamic filter based on user role, that means that determinate user see specific filter and other users see different filter since they have different role