JirAgileR is a R package with the objective to bring the power
of the project management tool JIRA to R. By doing so, users
benefit from the best capabilities of both platforms. More specifically,
the package is a wrapper around JIRA’s REST
API,
allowing users to analyze proyects or issues from JIRA in R. The
underlying powertrain of the API is the Jira Query Language (JQL).
You can find more information about it
here.
All used functions return as a result a data.frame.
–> More information about the package can be found here.
- Extract all project names with their basic information (e.g. Name, ID, Key, Type, Category etc.).
- Extract all issues specific to a user defined JIRA query (it allows to use both JIRA’s default fields as well as user defined custom JIRA fields).
- Extract comments and comments’ details from JIRA issues.
- Define integrated Reference Classes within the package
- Include pipes to facilitate analysis
- Include plotting graphs
You can install the latest release of this package from
Github with the following
commands in R:
if (!require("devtools")) install.packages("devtools")
devtools::install_github("matbmeijer/JirAgileR")This is a basic example which shows you how to obtain a simple table of
issues of a project and create a tabular report. You will need a
username and your password to authenticate in your domain. Possible
fields to obtain (which will populate the data.frame columns) can be
found
here.
library(JirAgileR, quietly = T)
library(knitr, quietly = T)
Domain <- "https://bitvoodoo.atlassian.net"
JQL_query <- "project='CONGRATS'"
Search_field <- c("summary","created", "status")
# Other possible fields are for example c("project", "key", "type", "priority", "resolution", "labels", "description", "links")
df<-JiraQuery2R(domain = Domain, query = JQL_query, fields = Search_field)
kable(df, row.names = F, padding = 0)| id | self | key | summary | created | status |
|---|---|---|---|---|---|
| 57446 | https://bitvoodoo.atlassian.net/rest/api/latest/issue/57446 | CONGRATS-29 | Display issue of standard profile picture in Internet Explorer | 2019-03-25 | In Progress |
| 57383 | https://bitvoodoo.atlassian.net/rest/api/latest/issue/57383 | CONGRATS-27 | Congrats - Define performance tests | 2019-02-04 | Open |
| 57327 | https://bitvoodoo.atlassian.net/rest/api/latest/issue/57327 | CONGRATS-26 | Congrats Data Center Checklist | 2018-11-07 | Closed |
| 57249 | https://bitvoodoo.atlassian.net/rest/api/latest/issue/57249 | CONGRATS-24 | Congrats for Confluence Data Center compatibility | 2018-09-12 | In Progress |
| 57157 | https://bitvoodoo.atlassian.net/rest/api/latest/issue/57157 | CONGRATS-23 | If max entries is above 100 user icons overlap with Congrats | 2018-07-03 | Closed |
| 57041 | https://bitvoodoo.atlassian.net/rest/api/latest/issue/57041 | CONGRATS-20 | “You already congratulated” message missing after refresh | 2018-03-19 | Closed |
| 56904 | https://bitvoodoo.atlassian.net/rest/api/latest/issue/56904 | CONGRATS-18 | Add a dialogue for users that urges them to fill in dates | 2017-12-05 | Closed |
| 56797 | https://bitvoodoo.atlassian.net/rest/api/latest/issue/56797 | CONGRATS-17 | Synchronisation with the //Seibert/Media CUP | 2017-09-26 | Open |
| 56796 | https://bitvoodoo.atlassian.net/rest/api/latest/issue/56796 | CONGRATS-16 | Add an Interface to configure the sync fields | 2017-09-26 | Open |
| 56795 | https://bitvoodoo.atlassian.net/rest/api/latest/issue/56795 | CONGRATS-15 | Synchronisation with the Communardo UPP | 2017-09-26 | Open |
| 55800 | https://bitvoodoo.atlassian.net/rest/api/latest/issue/55800 | CONGRATS-11 | Display of age for birthday configurable | 2017-04-05 | Closed |
| 52800 | https://bitvoodoo.atlassian.net/rest/api/latest/issue/52800 | CONGRATS-6 | Do not display inactive users in Congrats Macro | 2016-11-24 | Closed |
| 51806 | https://bitvoodoo.atlassian.net/rest/api/latest/issue/51806 | CONGRATS-3 | Incomplete rendering if placed in tabs | 2016-10-21 | Closed |
| 50050 | https://bitvoodoo.atlassian.net/rest/api/latest/issue/50050 | CONGRATS-1 | Display current event in the center | 2016-08-09 | Closed |