How do I show all of the values of a column in a liquid parameter's allowed value definition

[LookerExperts]

Knowledge Drop

Last tested: Jun 11, 2019
 

Say you have a parameter with allowed values yes and no, but also want an option for end users to choose all values (essentially no filter applied).

You can enter two double quotes "" in the value for the filter which equates to 1=1, such as:

parameter: filter_for_yes_no_all {
type: string
allowed_value: {
label: "Yes"
value: "1"}
allowed_value: {
label: "No"
value: "0"}
allowed_value: {
label: "ALL"
value: ""}
}

This content is subject to limited support.