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_workflow. #13 #30

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 name, entity_id, description, is_default from jira_workflow; ``` ``` +--------------------------------------------------------------------------------------+--------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+------------+ | name | entity_id | description | is_default | +--------------------------------------------------------------------------------------+--------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+------------+ | Builds Workflow | | Builds Workflow | false | | HSM: Jira Service Management default workflow | feac34db-ec19-41db-a9b5-172998c3654a | This Jira Service Management default workflow was generated for Project HSM | false | | HSM: Simple ESM workflow for Jira Service Management | f877dce7-7485-455f-8bab-497a0dc9e295 | This Jira Service Management Service Simple ESM workflow was generated for Project HSM | false | | DEMO: Service Request Fulfilment with Approvals workflow for Jira Service Management | ae1026e5-1da1-4f22-a2f3-09fa4b8e8d13 | This Jira Service Management Service Request Fulfilment with Approvals workflow was generated for Project DEMO | false | | DEMO: Service Request Fulfilment workflow for Jira Service Management | 57613c52-3759-4f59-be0c-1788863d95e8 | This Jira Service Management Service Request Fulfilment workflow was generated for Project DEMO | false | | jira | | The default Jira workflow. | true | | Software Simplified Workflow for Project SSP | 0d41b46f-d9e4-4c27-ba67-746f698606e9 | Generated by JIRA Software version 1001.0.0-SNAPSHOT. This workflow is managed internally by Jira Software. Do not manually modify this workflow. | false | | classic default workflow | 670ab1ba-57c8-ec68-c3aa-8e7d3f4485db | The classic JIRA default workflow | false | | Software Simplified Workflow for Project TEST1 | 647ac4ef-2268-493f-b797-4746a1d71d3b | Generated by JIRA Software version 1001.0.0-SNAPSHOT. This workflow is managed internally by Jira Software. Do not manually modify this workflow. | false | | Software Simplified Workflow for Project PLUGINJIRA | 5c68290f-284a-439e-8db6-30367b63631a | Generated by JIRA Software version 1001.0.0-SNAPSHOT. This workflow is managed internally by Jira Software. Do not manually modify this workflow. | false | | DEMO: Jira Service Management default workflow | ef339cb0-d501-4358-9cc4-cd2f2a209938 | This Jira Service Management default workflow was generated for Project DEMO | false | | Copy of classic default workflow | 2e285a08-acfd-49dd-a4e4-6b8ed4dc901c | | false | | Software Simplified Workflow for Project SBT | ac22b4ab-ca6f-47e0-ae10-9c68a602cb79 | Generated by JIRA Software version 1001.0.0-SNAPSHOT. This workflow is managed internally by Jira Software. Do not manually modify this workflow. | false | | HSM: Default ESM workflow for Jira Service Management | 1dec6755-b33f-41be-a946-319a2fafcae4 | This Jira Service Management Service Default ESM workflow was generated for Project HSM | false | +--------------------------------------------------------------------------------------+--------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+------------+ ``` ### List workflows that are not default ```sql select name, entity_id, description, is_default from jira_workflow where not is_default; ``` ``` +--------------------------------------------------------------------------------------+--------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+------------+ | name | entity_id | description | is_default | +--------------------------------------------------------------------------------------+--------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+------------+ | Builds Workflow | | Builds Workflow | false | | HSM: Jira Service Management default workflow | feac34db-ec19-41db-a9b5-172998c3654a | This Jira Service Management default workflow was generated for Project HSM | false | | HSM: Simple ESM workflow for Jira Service Management | f877dce7-7485-455f-8bab-497a0dc9e295 | This Jira Service Management Service Simple ESM workflow was generated for Project HSM | false | | DEMO: Service Request Fulfilment with Approvals workflow for Jira Service Management | ae1026e5-1da1-4f22-a2f3-09fa4b8e8d13 | This Jira Service Management Service Request Fulfilment with Approvals workflow was generated for Project DEMO | false | | DEMO: Service Request Fulfilment workflow for Jira Service Management | 57613c52-3759-4f59-be0c-1788863d95e8 | This Jira Service Management Service Request Fulfilment workflow was generated for Project DEMO | false | | Software Simplified Workflow for Project SSP | 0d41b46f-d9e4-4c27-ba67-746f698606e9 | Generated by JIRA Software version 1001.0.0-SNAPSHOT. This workflow is managed internally by Jira Software. Do not manually modify this workflow. | false | | classic default workflow | 670ab1ba-57c8-ec68-c3aa-8e7d3f4485db | The classic JIRA default workflow | false | | Software Simplified Workflow for Project TEST1 | 647ac4ef-2268-493f-b797-4746a1d71d3b | Generated by JIRA Software version 1001.0.0-SNAPSHOT. This workflow is managed internally by Jira Software. Do not manually modify this workflow. | false | | Software Simplified Workflow for Project PLUGINJIRA | 5c68290f-284a-439e-8db6-30367b63631a | Generated by JIRA Software version 1001.0.0-SNAPSHOT. This workflow is managed internally by Jira Software. Do not manually modify this workflow. | false | | DEMO: Jira Service Management default workflow | ef339cb0-d501-4358-9cc4-cd2f2a209938 | This Jira Service Management default workflow was generated for Project DEMO | false | | Copy of classic default workflow | 2e285a08-acfd-49dd-a4e4-6b8ed4dc901c | | false | | Software Simplified Workflow for Project SBT | ac22b4ab-ca6f-47e0-ae10-9c68a602cb79 | Generated by JIRA Software version 1001.0.0-SNAPSHOT. This workflow is managed internally by Jira Software. Do not manually modify this workflow. | false | | HSM: Default ESM workflow for Jira Service Management | 1dec6755-b33f-41be-a946-319a2fafcae4 | This Jira Service Management Service Default ESM workflow was generated for Project HSM | false | +--------------------------------------------------------------------------------------+--------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+------------+ ``` ### List workflows that are not associated with entity id ```sql select name, entity_id, description, is_default from jira_workflow where entity_id = ''; ``` ``` +-----------------+-----------+----------------------------+------------+ | name | entity_id | description | is_default | +-----------------+-----------+----------------------------+------------+ | Builds Workflow | | Builds Workflow | false | | jira | | The default Jira workflow. | true | +-----------------+-----------+----------------------------+------------+ ```