Generate weekly report of Azure DevOps Work Items.
mikan's Weekly Report
===== To-Do / 16 =====
โ [scrum1] ๐27: Sample Product Backlog Item / 8
โ [scrum1] ๐33: Sample Product Backlog Item / 8
===== DOING / 0 =====
โ [agile2] ๐3: Sample User Story / 0
โ [scrum1] ๐21: Sample Epic / 0
โ [scrum1] ๐37: Sample Epic / 0
โ [agile2] ๐43: Sample Task / 0
===== DONE / 50 =====
โ [scrum1] ๐4: Sample Product Backlog Item / 16
โ [scrum1] ๐19: Sample Epic / 0
โ [scrum1] ๐26: Sample Product Backlog Item / 5
โ [scrum1] ๐28: Sample Product Backlog Item / 8
โ [scrum1] ๐29: Sample Product Backlog Item / 13
โ [scrum1] ๐32: Sample Product Backlog Item / 8
โ [agile3] ๐39: Sample Bug / 0
โ [agile2] ๐40: Sample Task / 0
โ [agile3] ๐51: Sample Bug / 0
Format:
- each headers:
===== header / total-effort =====
- each items:
[project] number: title / effort
- Azure Boards Query UUIDs (shown in browser address bar)
- My to-do items
State
InNew,Open,Accepted,Ready,Approved,To Do
- And
Assigned To
=(YOU)
- My doing items
State
InCommitted,Doing,In Progress,Doing,Active
- And
Assigned To
=(YOU)
- My done items last week
Closed Date
>=@StartOfDay('-7d')
- And
Assigned To
=(YOU)
- My to-do items
- Personal Access Token
- Slack Incoming Webhook URL
Standard output (for testing)
go run main.go -o <ORG> -t <TOKEN> -todo <TODO_QUERY> -doing <DOING_QUERY> -done <DONE_QUERY> -n "<NAME>"
Slack
go run main.go -o <ORG> -t <TOKEN> -todo <TODO_QUERY> -doing <DOING_QUERY> -done <DONE_QUERY> -n "<NAME>" -s <WEBHOOK>
Cron tab
0 10 * * 1 work-item-reporter -o <ORG> -t <TOKEN> -todo <TODO_QUERY> -doing <DOING_QUERY> -done <DONE_QUERY> -n "<NAME>" -s <WEBHOOK>