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 optional quals for table jira_issue. #47

Closed LalitLab closed 2 years ago

LalitLab commented 2 years ago

We've added below additional key columns to filter issues data at the api level: issue_id, issue_key, project_key, project_id, project_name, status, assignee_display_name, assignee_display_name, creator_account_id, creator_display_name, reporter_account_id, reporter_display_name, created, duedate, updated, epic_key, type and priority.

Example query results

Results ```sql select id, key, assignee_account_id, assignee_display_name, created, creator_account_id, creator_display_name, duedate, epic_key, priority, project_id, project_key, project_name, reporter_account_id, reporter_display_name, status, type, updated from jira_issue where assignee_display_name = 'Lalit Bhardwaj' and project_name = 'plugin-jira' and reporter_display_name = 'John Smyth' +-------+--------------+--------------------------+-----------------------+---------------------------+--------------------------+----------------------+---------------------------+----------+----------+------------+-------------+--------------+--------------------------+-----------------------+--------+-------------+---------------------------+ | id | key | assignee_account_id | assignee_display_name | created | creator_account_id | creator_display_name | duedate | epic_key | priority | project_id | project_key | project_name | reporter_account_id | reporter_display_name | status | type | updated | +-------+--------------+--------------------------+-----------------------+---------------------------+--------------------------+----------------------+---------------------------+----------+----------+------------+-------------+--------------+--------------------------+-----------------------+--------+-------------+---------------------------+ | 10035 | PLUGINJIRA-3 | 5a0a5314a1a46046a530f71a | Lalit Bhardwaj | 2021-06-15T04:22:10+05:30 | 5a7a1a69a0a85a006aa00aa1 | John Smyth | 2021-07-04T05:30:00+05:30 | | Medium | 10001 | PLUGINJIRA | plugin-jira | 5a7a1a69a0a85a006aa00aa1 | John Smyth | To Do | New Feature | 2021-06-15T04:23:08+05:30 | +-------+--------------+--------------------------+-----------------------+---------------------------+--------------------------+----------------------+---------------------------+----------+----------+------------+-------------+--------------+--------------------------+-----------------------+--------+-------------+---------------------------+ ``` ```sql > select id, key, assignee_account_id, assignee_display_name, created, creator_account_id, creator_display_name, duedate, epic_key, priority, project_id, project_key, project_name, reporter_account_id, reporter_display_name, status, type, updated from jira_issue where created > now() - interval '9 months' +-------+--------------+--------------------------+-----------------------+---------------------------+--------------------------+----------------------+---------+----------+----------+------------+-------------+--------------+--------------------------+-----------------------+--------+------+---------------------------+ | id | key | assignee_account_id | assignee_display_name | created | creator_account_id | creator_display_name | duedate | epic_key | priority | project_id | project_key | project_name | reporter_account_id | reporter_display_name | status | type | updated | +-------+--------------+--------------------------+-----------------------+---------------------------+--------------------------+----------------------+---------+----------+----------+------------+-------------+--------------+--------------------------+-----------------------+--------+------+---------------------------+ | 10046 | TEST6-7 | | | 2021-07-20T18:20:49+05:30 | 60ccb403c90cb2006814fb8b | sayan | | | Medium | 10006 | TEST6 | test_45 | 60ccb403c90cb2006814fb8b | sayan | Closed | Bug | 2021-07-20T18:31:53+05:30 | | 10048 | PLUGINJIRA-6 | 5c0e5314a1b46046f530f71b | Lalit Bhardwaj | 2021-07-20T18:40:35+05:30 | 60ec3b86a0de58006a978977 | khushboo sharma | | | Medium | 10001 | PLUGINJIRA | plugin-jira | 60ec3b86a0de58006a978977 | khushboo sharma | Done | Task | 2021-07-20T18:54:55+05:30 | | 10049 | TEST6-9 | | | 2021-07-20T20:42:58+05:30 | 60ec3b86a0de58006a978977 | khushboo sharma | | | Medium | 10006 | TEST6 | test_45 | 60ec3b86a0de58006a978977 | khushboo sharma | Open | Task | 2021-07-20T20:42:58+05:30 | | 10047 | TEST6-8 | | | 2021-07-20T18:23:32+05:30 | 60ccb403c90cb2006814fb8b | sayan | | | Medium | 10006 | TEST6 | test_45 | 60ccb403c90cb2006814fb8b | sayan | Open | Bug | 2021-07-20T18:23:32+05:30 | ```