Feature request · Customization · Blocks work
Support optional query parameters without SQL workarounds
3 source threads · first seen 2018-10 · last seen 2019-11
Summary
Making a parameter optional currently requires a workaround inside the query logic; the reporter asks that a section can be skipped when no value is given.
- Affects
- query authors
- Workaround
- Compare against a magic value like 'All' in the WHERE clause
Evidence
Excerpts are copied word for word from the source; follow the link to read it in full.
“if the title has `{{x}}` in it, it will be replaced with the parameter value”
“Today to make a parameter optional, the user needs to have a workaround in the query logic itself”
“we can add some useful short hands like: last month, last week, last 7 days, last 30 days, etc”