How to use Azure monitor => Workbook => Parameters => Select All option

Question

I am using some parameters in my workbook to filter resources and these selected values are used to build query / displays results. They are dependent on each other i.e. FilterCustomer is dependent on FilterRegion and FilterRegion is dependent on FilterHub. I am using them as shown in the attached file (in where clause).

If I add and select "All" option in FilterRegion I am expecting all values in the next filter i.e. FilterCustomer where I can use it in the query (something like => | where resourceGroup in ({FilterRegion:resourcegroup}). How can I use these values in where clause ?

@John Gardner (MSFT)

Answer 1

The parameters only return a single value for each item, they do not have an easy way to return extra fields to do something like "{filterregion:resourcegroup}"

your FilterCustomer query would then have to join between however you get your FilterRegion field and your resourceGroup field.

in this case, the error comes because your region field is returning many values (literally: "a", "b", "c").. when replaced in your query that is using "==", you're getting a query generated like resourceGroup == "a", "b", "c" which isn't valid syntactically, you'd need to use in instead.