Skip to main content
Search users Returns all* user records that match the given search criteria. If multiple search params are given and `filter_or` is FALSE or not specified, search params are combined in a logical AND operation. Only rows that match *all* search param criteria will be returned. If `filter_or` is TRUE, multiple search params are combined in a logical OR operation. Results will include rows that match **any** of the search criteria. String search params use case-insensitive matching. String search params can contain `%` and ’_’ as SQL LIKE pattern match wildcard expressions. example=“dan%” will match “danger” and “Danzig” but not “David” example=“D_m%” will match “Damage” and “dump” Integer search params can accept a single value or a comma separated list of values. The multiple values will be combined under a logical OR operation - results will match at least one of the given values. Most search params can accept “IS NULL” and “NOT NULL” as special expressions to match or exclude (respectively) rows where the column is null. Boolean search params accept only “true” and “false” as values. (*) Results are always filtered to the level of information the caller is permitted to view. Looker admins can see all user details; normal users in an open system can see names of other users but no details; normal users in a closed system can only see names of other users who are members of the same group as the user.
External DocumentationTo learn more, visit the Google Looker documentation.

Basic Parameters

Advanced Parameters

Example Output

Workflow Library Example

Search Users with Google Looker and Send Results Via Email
Workflow LibraryPreview this Workflow on desktop