A set of helper tools to work with JIRA REST API to collect, aggregate & process the data that cannot be retrieved directly from the UI.
npm install -g @acumatica/jiraapiAfter installing it, run jiraapi --help without arguments to see the list of commands available.
On Windows, please make sure that you have %APPDATA\Roaming\npm in your PATH environment variable.
On the first execution of any command, the tool will ask you for your JIRA credentials. After that, they will be securely stored on your computer using the default credentials manager on your OS. This tool uses Basic Authentication in JIRA REST API.
You can use both usernames (jsmith) or full names (Josh Smith) in the list of assignees. If there are multiple users found by the full name provided, the tool will ask you which one should be used. It is OK to make typos in the user's full name, the tool uses JIRA search to find the appropriate assignee.
Time periods support years ("2022"), quarters ("2022 Q3", "2022-Q3", "2022, Q3"), months ("2022-07", "2022 07", "Jul, 2022", "July, 2022"), days ("2022-09-17", "2022 09 17"), and ranges for any units mentioned above, using .. as a separator ("2022-09-17..2022-09-18").
jiraapi worklog -a "Josh Smith, Maxwell Baker, John Deer, Alexa Bloom" -t "2020 Q2" --itemtype SupportRequestsOutput:
Alexa Bloom 73.79d
John Deer 54.09d
Josh Smith 30.89d
Maxwell Baker 47.87d
Total 206.64djiraapi worklog -a "jsmith, maxwell.baker, john.deer, alexa.bloom" -t "2019 Q4" --itemtype ExternalBugsOutput:
alexa.bloom 73.79d
john.deer 54.09d
jsmith 30.89d
maxwell.baker 47.87d
Total 206.64djiraapi worklog -a "John Smith, Maxwell Baker, John Deer, Alexa Bloom" -t "2019 Q4" -q "Project = PI AND Status not in (Resolved, Closed)"jiraapi worklog -a "Josh Smith, Alexa Bloom" -t "2019-12" --detailedOutput:
Alexa Bloom 2.82d
DEV-1922 (https://jira.mydomain.com/browse/DEV-1922) 1.76d
DEV-1378 (https://jira.mydomain.com/browse/DEV-1378) 1.06d
Josh Smith 7.93d
PI-223 (https://jira.mydomain.com/browse/PI-223) 3.46d
QA-8842 (https://jira.mydomain.com/browse/QA-8842) 2.29d
DEV-1922 (https://jira.mydomain.com/browse/DEV-1922) 2.18d
Total 12.23dIf you have a terminal that supports embedded hyperlinks (e.g., Windows Terminal v1.4 and higher), the output will look like this:
Alexa Bloom 2.82d
DEV-1922 1.76d
DEV-1378 1.06d
Josh Smith 7.93d
PI-223 3.46d
QA-8842 2.29d
DEV-1922 2.18d
Total 12.23d
jiraapi worklog -a "John Smith, Maxwell Baker, John Deer, Alexa Bloom, Nick Daniels" -t "2020 Q2" --humanizeOutput:
Alexa Bloom 2 months, 2 weeks, 3 days, 2 hours, 46 minutes
John Deer 1 month, 2 weeks, 5 hours, 3 minutes
Josh Smith 3 months, 2 weeks, 2 days, 3 hours, 27 minutes
Maxwell Baker 2 months, 2 weeks, 4 days, 4 hours, 2 minutes
Nick Daniels 2 months, 1 week, 1 day, 5 hours, 48 minutes
Total 1 year, 3 weeks, 4 hours, 30 minutes
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent