Access control list

[Rupesh]

I am currently evaluating Metabase for my organization and have a couple of questions:

• I am populating a dropdown in a dashboard using a question with a parameter. How can I pass a value to this parameter when embedding the dashboard?
• I have a table called gl that contains a company_id field. User access depends on the company_id stored in a separate table. To retrieve the GLs for a user, I use the following query:

SELECT * FROM gl WHERE company_id IN (SELECT company_id FROM users WHERE user_id = 123)

How can I achieve this in Metabase? I’ve tried using a linked filter by linking the gl table with the company_id column, but if the company_id filter isn’t applied, how can I retrieve all GLs for the user across all companies?"

[Luiggi]

@Rupesh

• I am populating a dropdown in a dashboard using a question with a parameter. How can I pass a value to this parameter when embedding the dashboard?

embedding the question or dashboard with static embedding

@Rupesh

• I have a table called gl that contains a company_id field. User access depends on the company_id stored in a separate table. To retrieve the GLs for a user, I use the following query:

you can use linked filters, check the docs

[Rupesh]

As mentioned, I was already using linked filters. We were able to get around this. Thanks!