| where $click.name$ == if("$click.value$" == "Totals", * , "$click.value$")
This bit of code is intended to allow us to use a drill-down on a table that includes a generated row where the clicked value or the clicked value's field name may not be descriptive search terms, specifically a row of column totals. Obviously, it doesn't work.
Where appears to lack the wildcarding semantic entirely, which makes sense I suppose. However, I rather need that bit of functionality.
A bare * isn't really a valid return value here, a quoted one becomes a useless string literal, and an escaped one doesn't work either.
I was wondering if anyone had a better approach to this kind of last-minute substitution-chicanery, or if anyone knows how to get a match-any boolean expression out of a where clause?
... View more