Can I limit the default options on a filter value?

[trinidad_aguirr]

Hi!! Need to be able to only show the option matches a user attribute = email. Nothing else as this would allow users to slice the data outside of that permitted one.

[Dawid]

We don’t have ability to change how the filter works. The only way to achieve that would be to use sql_always_where, and if you can’t do that to the whole explore, you may need to create an extension with sql_always_where that is used only for the Dashboard

[trinidad_aguirr]

Hi @Dawid thank you so much for the quick response. Would you be able to provide some documentation on this sql statement? Thank you!

[Dawid]

Here is the way to do it with always_filter:

https://cloud.google.com/looker/docs/admin-panel-users-user-attributes#access_filters

Here is an example using Liquid to get user attribute and create a tighter join by equalling it with a field.

Both examples show up in the SQL tab:

https://community.looker.com/lookml-5/advanced-permissioning-using-user-attributes-6347