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 column properties in the table jira_project Closes #89 #105

Closed ParthaI closed 10 months ago

ParthaI commented 10 months ago

Example query results

Results ``` > select id, jsonb_pretty(properties) from jira_project +-------+---------------------------------------------------------------+ | id | jsonb_pretty | +-------+---------------------------------------------------------------+ | 10000 | [ | | | { | | | "key": "jsw.fusion.code.agility.feature.enabled", | | | "value": true | | | }, | | | { | | | "key": "jswSelectedBoardType", | | | "value": { | | | "jswSelectedBoardType": "agility" | | | } | | | } | | | ] | | 10001 | [ | | | { | | | "key": "demo-issue-created.SD_DEMO_ISSUE_1", | | | "value": "DESK-1" | | | }, | | | { | | | "key": "demo-issue-created.SD_DEMO_ISSUE_2", | | | "value": "DESK-2" | | | }, | | | { | | | "key": "demo-issue-created.SD_DEMO_ISSUE_3", | | | "value": "DESK-3" | | | }, | | | { | | | "key": "demo-issue-created.SD_DEMO_ISSUE_4", | | | "value": "DESK-4" | | | }, | | | { | | | "key": "demo-issue-created.SD_DEMO_ISSUE_5", | | | "value": "DESK-5" | | | }, | | | { | | | "key": "demo-issue-created.SD_DEMO_ISSUE_AUTOMATION", | | | "value": "DESK-7" | | | }, | | | { | | | "key": "demo-issue-created.SD_DEMO_ISSUE_LINK_SW", | | | "value": "DESK-6" | | | }, | | | { | | | "key": "isDemo", | | | "value": true | | | } | | | ] | +-------+---------------------------------------------------------------+ Time: 73ms. Rows fetched: 2 (cached). Hydrate calls: 0. ```