[SOLVED] Azure CLI choose a option from a table

Azure CLI choose a option from a table

I am trying to get a table output with numbers in the Azure CLI which gives this as a output

Number      Location     Name
----------  -----------  -------------
1           somewhere    ResourceGroup1
2           somewhere    ResourceGroup2

The code I have right now is

az group list --query '[].{location:location, name:name}'

The output I'm getting right now is

Location     Name
----------  ---------------
somewhere    ResourceGroup1
somewhere    ResourceGroup2

My end goal is that if you choose the number 1 you select the name so I can use that later in the script

Solution

you can use contains expression (jmespath) in the filter to filter the results:

filter=resource_group_name
filterExpression="[?contains(name, '$filter')].name"
az group list --query "$filterExpression" -o tsv

which is a much better way compared to already present answers.