Dynamic Filters for reports

Get Help
1

I want to know how to add dynamic filters to our reports. Right now if a user have access to two locations out of 5 we show him only two location data from our DB.

But i am not able to figure it out how to do it from metabase.

it will be select data from table where locationAccess in ( list of locations),.

and for different users list of locations will be different so i want to inject these location list from my front end.

Please help if possible,

2

Hi @infiamit
It sounds like you’re looking for the Sandboxing functionality, which is part of the Enterprise edition:
https://www.metabase.com/docs/latest/enterprise-guide/data-sandboxes.html
You can create similar functionality by using Embedding, but you will need to code parts of it - specifically the select-filters, which defines what “locations” are available to the user.