turbot / steampipe-plugin-jira

Use SQL to instantly query Jira. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/jira
Apache License 2.0
22 stars 14 forks source link

Add table jira_issue_worklog Closes #89 #104

Closed ParthaI closed 10 months ago

ParthaI commented 10 months ago

Example query results

Results ``` > select distinct w.issue_id, w.id, w.time_spent, w.updated as worklog_updated_at, i.duedate, i.priority, i.project_name, i.key from jira_issue_worklog as w, jira_issue as i where i.id = trim(w.issue_id) and w.updated >= now() - interval '1' day; +----------+-------+------------+---------------------------+---------+----------+----------------------+--------+ | issue_id | id | time_spent | worklog_updated_at | duedate | priority | project_name | key | +----------+-------+------------+---------------------------+---------+----------+----------------------+--------+ | 10006 | 10003 | 8m | 2023-11-10T11:41:34+05:30 | | Medium | Demo service project | DESK-7 | | 10006 | 10004 | 13m | 2023-11-10T11:41:44+05:30 | | Medium | Demo service project | DESK-7 | | 10008 | 10000 | 3h 20m | 2023-11-09T22:15:40+05:30 | | Medium | testing | TES-2 | | 10008 | 10001 | 16m | 2023-11-09T22:16:46+05:30 | | Medium | testing | TES-2 | | 10008 | 10002 | 8m | 2023-11-09T22:17:37+05:30 | | Medium | testing | TES-2 | +----------+-------+------------+---------------------------+---------+----------+----------------------+--------+ > SELECT issue_id, SUM(time_spent_seconds) AS total_time_spent_seconds FROM jira_issue_worklog GROUP BY issue_id; +----------+--------------------------+ | issue_id | total_time_spent_seconds | +----------+--------------------------+ | 10006 | 1260 | | 10008 | 13440 | +----------+--------------------------+ ```