The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.
SQL like query interface for Jira in R language
This package provides a SQL like query interface to fetch data from any Jira installation. The data is fetched into R dataframe (using Jira REST API)
Key features: * Data is fetched using Jira
REST API therefore can be used over web without needing to connect
to any database. * Function to authenticate into Jira instance using
jira.login() * Function to fetch METADATA from Jira
instance using jira.metadata() * Function to QUERY jira
data with SQL like syntax using jira.query()
To get the current development version from github:
# install.packages("devtools")
library(devtools)
devtools::install_github("nikhilchoudhry/nJira")You should have an account in the Jira instance to query its data. You can use the same log-in credentials that you use on your Jira website.
Assuming your Jira credentials are as follows
jira.login(jira.env = "https://issues.apache.org/jira", jira.user = "jiraTestUser", jira.pwd = "jiraTestPwd")jiraMetadata <- jira.metadata()
issues <- jira.query(table = "issues", fields = "id AS IssueId, Created, Status, Priority",
where = "project = 'HIVE' AND created >= '2019-01-01' AND created <= '2019-12-31' AND
Status IN ('Open', 'Closed', 'Resolved')")
issues <- jira.query(table = "issues", fields = "id AS IssueId, Created",
where = "'cf[10021]' = 'ABCD' AND Created > '2019-01-01'")
history <- jira.query(table = "history", fields = "id AS IssueId, toString AS Status,
COUNT(fromString) AS Count", where = "id = 'HIVE-22692' AND field = 'status'",
groupby = "id,toString")
These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.