@acumatica/jiraapi

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.

Installing

npm install -g @acumatica/jiraapi

After 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.

Usage

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").

Getting an aggregated worklog for a predefined item category

jiraapi worklog -a "Josh Smith, Maxwell Baker, John Deer, Alexa Bloom" -t "2020 Q2" --itemtype SupportRequests

Output:

Alexa Bloom     73.79d
John Deer       54.09d
Josh Smith      30.89d
Maxwell Baker   47.87d

Total           206.64d

jiraapi worklog -a "jsmith, maxwell.baker, john.deer, alexa.bloom" -t "2019 Q4" --itemtype ExternalBugs

Output:

alexa.bloom     73.79d
john.deer       54.09d
jsmith          30.89d
maxwell.baker   47.87d

Total           206.64d

Getting an aggregated worklog using a custom JQL query

jiraapi worklog -a "John Smith, Maxwell Baker, John Deer, Alexa Bloom" -t "2019 Q4" -q "Project = PI AND Status not in (Resolved, Closed)"

Getting a detailed worklog

jiraapi worklog -a "Josh Smith, Alexa Bloom" -t "2019-12" --detailed

Output:

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.23d

If 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

Getting a human-readable output for large amounts of time

jiraapi worklog -a "John Smith, Maxwell Baker, John Deer, Alexa Bloom, Nick Daniels" -t "2020 Q2" --humanize

Output:

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