Knowledge Drop

How to: Multiple user attribute values (OR logic)

  • 6 April 2021
  • 2 replies
  • 357 views

Userlevel 4

Last tested: May 20, 2019

 

Use a String Filter (advanced) user attribute type and input the user attribute values with the following syntax:

'value1','value2'

 

Each value should be wrapped with single quotes and delimited with a comma. Make sure there are no white spaces between the values.

 

This content is subject to limited support.                

 

 


2 replies

Is this syntax still valid? We tried it out for our region field, with user attribute set to:

‘US’,’EU’
 

Single quotes, delimited with comma, no white spaces.

But we get No Results from the query.

@Andreas_Granstrom

It looks valid. Did you select String Filter (advanced)?

 

cloud.google.com/looker/docs/admin-panel-users-user-attributes

String Filter (advanced): Select this option to allow multiple string values or a Looker filter expression in the user attribute. See the Filter expressions documentation page for a list of filter expressions you can use for strings.

Reply