Description Usage Arguments Details Value Examples
Query Jira using SQL like query syntax. The query response from Jira REST API is returned as a dataframe.
1 | jira.query(table, fields = NULL, where = NULL, groupby = NULL)
|
table |
Name of Jira table from which data will be fetched. |
fields |
Comma separated names of the fields from the specified table whose values will be fetched. |
where |
specifies the where clause of the query. You can also pass your Jira JQL as-is in the where clause. |
groupby |
specifies the list of fields on which the data is grouped. |
For querying Jira 'history' table, the where clause must specify issue 'id'
Example : where = "id = 'HIVE-22692'"
Data frame of results returned by the Jira query.
1 2 3 4 5 6 7 8 9 10 11 12 | 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", where = "id = 'HIVE-22692'")
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")
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.