How to allow empty param values in data explorer?

data & reporting
1

I would like to allow a filtering step to be optional, but if I leave the query field empty, I get an error:

---[params]
--- string :query = '%'
select uh.details 
from user_histories uh
where uh.details like case 
      when :query is not null then '%' || :query || '%'
      else '%'
      end
limit 5

Error: DataExplorer::ValidationError: Missing parameter query of type string

2 Likes