Hi Everyone,
I am running a search:
| inputlookup MyLookup
| where Foo="$FooValueFromDropdown$"
| stats values(Price)
where, $FooValueFromDropdown$ replaces itself with a value coming from a drop-down above.
When drop-down is set to some value like Cadbury or Nestle, search works fine, but when the drop-down is set to All, search shows nothing.
I tried search command, but it's not case-sensitive, which means if I have values like Cadbury(with capital C) and cadbury(with small c) and I select Cadbury with capital C, search will show results for both of them.
How can I use case-sensitivity of where and wildcard(*) friendliness of search together?
Please help.
Thank you 🙂
... View more