Dynamic Filters for reports

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,

Hi @infiamit
It sounds like you’re looking for the Sandboxing functionality, which is part of the Enterprise edition:
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.