View the original community article here
Last tested: Jun 17, 2019
At first thought, it might make sense to assign a blank value to override any default value input for user attribute values in the User Attribute page in the Admin Panel. However, if we assign blank override values for Admins or Unrestricted Access groups, Looker will interpret the blank as a value not having been assigned to a user. In this case, any default value specified will override the blank.
In cases where using access filters to restrict data access amongst users with user_attributes
, while allowing certain users or groups all access, we can set user attributes as such:
- To give an admin or other user access to all non-null values of a string field, set the user attribute data type to String Filter (advanced), and use a value of
%
. To include null values, set the user attribute to%, NULL
. - To give an admin or other user access to all non-null values of a number field, set the user attribute data type to Number Filter (advanced), and use
>0
orNOT NULL
. To include null values, set the user attribute to>0, NULL
.
This content is subject to limited support.