Forum Discussion

Thim's avatar
Thim
Resolver V
4 years ago

Slicer from list

Hi All. 🙂   Is there a way to make a slicer accept multiple searches/filters at the same time. Example: Today if i have a user who has a list of 10 items they want to filter down to, they need to...
Need Help
Thejeswar's avatar
Thejeswar
Super User
4 years ago

Hi,

I think you can achieve this by implementing RLS, where based on the User, only those items are listed.

 

This way the User will see only those 10 items that he is associated with.

All that you need, is, another table with the mapping between User and the Item

 

Regards,

Thim's avatar
Thim
Resolver V
4 years ago

Thanks for the suggestion.

Will the user be able to change this themself, if they have a new list tomorrow?

  • Thejeswar's avatar
    Thejeswar
    Super User
    4 years ago

    It might not be possible for the user to change it themselves. But for this to be automatically updated, we might have to keep updating the table with User-Item mapping with the latest information. This will ensure that the User sees the latest list of Items that is related with his user

    • Thim's avatar
      Thim
      Resolver V
      4 years ago

      Thanks for the input. 🙂

       

      I think this will require a bit to much for it to be worth the work comparing to finding the different items on a slicer manually.

       

      But this could be a strong way to fix other reports I am working on.

      Cheers.