issues
search
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_component. closes #5
#15
Closed
sayan133
closed
3 years ago
sayan133
commented
3 years ago
Integration test logs
Logs
``` N/A ```
Example query results
Results
### Basic info ```sql select id, name, project, issue_count from jira_component; ``` ``` +-------+----------------+------------+-------------+ | id | name | project | issue_count | +-------+----------------+------------+-------------+ | 10000 | comp1 | PLUGINJIRA | 3 | | 10003 | Public website | DEMO | 0 | | 10002 | Intranet | DEMO | 0 | | 10004 | Jira | HSM | 0 | | 10005 | Intranet | HSM | 0 | | 10001 | Jira | DEMO | 0 | | 10006 | Public website | HSM | 0 | +-------+----------------+------------+-------------+ ``` ### List components having issues ```sql select id, name, project, issue_count from jira_component where issue_count > 0; ``` ``` +-------+-------+------------+-------------+ | id | name | project | issue_count | +-------+-------+------------+-------------+ | 10000 | comp1 | PLUGINJIRA | 3 | +-------+-------+------------+-------------+ ``` ### List components with no leads ```sql select id, name, project, issue_count, lead_display_name from jira_component where lead_display_name = ''; ``` ``` +-------+-------+------------+-------------+-------------------+ | id | name | project | issue_count | lead_display_name | +-------+-------+------------+-------------+-------------------+ | 10000 | comp1 | PLUGINJIRA | 3 | | +-------+-------+------------+-------------+-------------------+ ```
Integration test logs
Logs
``` N/A ```Example query results
Results
### Basic info ```sql select id, name, project, issue_count from jira_component; ``` ``` +-------+----------------+------------+-------------+ | id | name | project | issue_count | +-------+----------------+------------+-------------+ | 10000 | comp1 | PLUGINJIRA | 3 | | 10003 | Public website | DEMO | 0 | | 10002 | Intranet | DEMO | 0 | | 10004 | Jira | HSM | 0 | | 10005 | Intranet | HSM | 0 | | 10001 | Jira | DEMO | 0 | | 10006 | Public website | HSM | 0 | +-------+----------------+------------+-------------+ ``` ### List components having issues ```sql select id, name, project, issue_count from jira_component where issue_count > 0; ``` ``` +-------+-------+------------+-------------+ | id | name | project | issue_count | +-------+-------+------------+-------------+ | 10000 | comp1 | PLUGINJIRA | 3 | +-------+-------+------------+-------------+ ``` ### List components with no leads ```sql select id, name, project, issue_count, lead_display_name from jira_component where lead_display_name = ''; ``` ``` +-------+-------+------------+-------------+-------------------+ | id | name | project | issue_count | lead_display_name | +-------+-------+------------+-------------+-------------------+ | 10000 | comp1 | PLUGINJIRA | 3 | | +-------+-------+------------+-------------+-------------------+ ```