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