# Packaging reporting

## About the data in Jira

- We have tickets in the following project: `PKG`
- These are created via Slack in #package_requests
- These issues go through different statuses (e.g. 'in review', 'merged', 'done', etc.)
- These issues have the following metadata associated with them:
- urgency
- type ("New Package", "Package Update", "Other", "Bug Report")
- package name
- package version
- destination (e.g. `defaults`)

### JQL query for finding finished package requests

project = "PKG" AND 
"Package Name[Short text]" IS NOT EMPTY AND
type = Task AND
status = Done
ORDER BY created DESC

## What's possible to do via Jira's API

- We can see how long it takes to complete packaging requests by inspecting the status "history"

## Jira reporting dashboards

It's possible to create a reporting dashboards in Jira:

https://confluence.atlassian.com/jirakb/reporting-in-jira-461504615.html

After messing around with it a little, I found that the "Javascript for JIRA Cloud" is the best
one.

## Useful links

- [Jira Python API](https://jira.readthedocs.io/)
- https://anaconda.atlassian.net/wiki/spaces/AD/pages/3468034057/Team+Marquee#Package-prioritization

## Term definitions

SOW - Statement of work; contracts