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

Akash Hande 21 Reputation points
2022-03-04T09:01:57.013+00:00

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) 180053-question-for-options.png

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,867 questions
{count} votes

1 answer

Sort by: Most helpful
  1. John Gardner (MSFT) 81 Reputation points Microsoft Employee
    2022-03-04T18:49:01.857+00:00

    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.

    0 comments No comments