If a label is specified, the Label will be shown in the Field to Filter dropdown for Dashboard and widget filters.
Example: Using the runtime parameter filter with the label- "MEMBERS" at the dashboard and widget level:
Using c9 Token Optionally
It allows users to use the c9 token optionally. If you have a token for filtering the data you can use and pass the token in your query.
For example,
select *
where X = Y |$ and Z = $c9_&<abc>$(*)$ $|
If you don't pass any value in the <abc> (i.e., the value of <abc> is *), the section from |$ to $| will be removed.
The nested and multiple objects can be handled as illustrated below.
For example,
select *
where X = Y |$ and Z = $c9_blah$(*)$ |$ and W = $c9_foo$(*)$ $|$| |$ and T = $c9_baz$(*)$ $|