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_comment Closes #89 #103

Closed ParthaI closed 10 months ago

ParthaI commented 10 months ago

Example query results

Results ``` > select * from jira_issue_comment where issue_id = '10008' and id = '10006' +-------+----------+--------------------------------------------------------------------+---------+---------------------------+---------------------------+-----------+-----------+------------------------------------------------------------------------------------------> | id | issue_id | self | Body | created | updated | JsdPublic | issue_key | author > +-------+----------+--------------------------------------------------------------------+---------+---------------------------+---------------------------+-----------+-----------+------------------------------------------------------------------------------------------> | 10006 | 10008 | https://turbi63.atlassian.net/rest/api/2/issue/10008/comment/10006 | testint | 2023-11-09T16:16:10+05:30 | 2023-11-09T16:16:10+05:30 | true | | {"accountId":"712020:5dab9f7f-a163-4a8e-86ff-68c1393f08f1","accountType":"atlassian","act> | | | | | | | | | ia/Calcutta"} > +-------+----------+--------------------------------------------------------------------+---------+---------------------------+---------------------------+-----------+-----------+------------------------------------------------------------------------------------------> > select id, issue_id, body, created, updated from jira_issue_comment where updated >= now() - interval '2' hour; +-------+----------+-------------+---------------------------+---------------------------+ | id | issue_id | body | created | updated | +-------+----------+-------------+---------------------------+---------------------------+ | 10006 | 10008 | testint --- | 2023-11-09T16:16:10+05:30 | 2023-11-09T21:06:34+05:30 | +-------+----------+-------------+---------------------------+---------------------------+ ```