Azure / Azure/azure-cli-extensions
Trouble with JMES Query because of dots in fieldnames
- Dominant language
- Python
- Stars
- 454
- Forks
- 1.7k
- Avg merge
- 2d 19h
- Merged PRs (30d)
- 64
Description
az boards query --id 02187725-f42d-4a44-b787-afc2e52629f8 --query "[0:1].fields" retrieves:
```
[
{
"System.AreaPath": "AreaPath",
"System.Id": 87,
"System.IterationPath": "ProjectName\\Iteration 1",
"System.State": "Active",
"System.Title": "Tasktitle",
"System.WorkItemType": "Task"
}
]
```
I'm trying to retrieve only a list of workitem titles but I'm having a hard time constructing a working jmespath because of the dots used in the fieldnames.
I've tried
az boards query --id 02187725-f42d-4a44-b787-afc2e52629f8 --query "[0:1].fields.'System.Title'"
az boards query --id 02187725-f42d-4a44-b787-afc2e52629f8 --query "[0:1].fields.`System.Title`"
az boards query --id 02187725-f42d-4a44-b787-afc2e52629f8 --query "[0:1].fields.System.Title"
az boards query --id 02187725-f42d-4a44-b787-afc2e52629f8 --query '[0:1].fields."System.Title"'
any clue on how to select only specific fields?
---
#### Document Details
⚠ *Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.*
* ID: d535510f-f15c-3c79-c44d-34b7742a1544
* Version Independent ID: 334f9fc5-2811-f125-4faa-3fb90ec19559
* Content: [az boards](https://docs.microsoft.com/en-us/cli/azure/ext/azure-devops/boards?view=azure-cli-latest)
* Content Source: [latest/docs-ref-autogen/ext/azure-devops/boards.yml](https://github.com/MicrosoftDocs/azure-docs-cli/blob/master/latest/docs-ref-autogen/ext/azure-devops/boards.yml)
* GitHub Login: @rloutlaw
* Microsoft Alias: **routlaw**
Contributor guide
Assessment
This issue has not been assessed yet.