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_advanced_setting. closes #11 #18

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, key, type from jira_advanced_setting; ``` ``` +-----------------------------------------+--------------------------------------------------------+-----------------------------------------+--------------+ | id | name | key | type | +-----------------------------------------+--------------------------------------------------------+-----------------------------------------+--------------+ | jira.date.time.picker.java.format | DateTime Picker Format (Java) | jira.date.time.picker.java.format | string | | jira.view.issue.links.sort.order | Sort order for view issue links | jira.view.issue.links.sort.order | list | | jira.comment.collapsing.minimum.hidden | jira.comment.collapsing.minimum.hidden | jira.comment.collapsing.minimum.hidden | uint | | jira.issue.actions.order | JIRA issue actions order | jira.issue.actions.order | enum | | jira.newsletter.tip.delay.days | Delay in days before newsletter signup tip is shown | jira.newsletter.tip.delay.days | int | | jira.table.cols.subtasks | JIRA subtasks table columns | jira.table.cols.subtasks | list | | jira.date.picker.javascript.format | Date Picker Format (JavaScript) | jira.date.picker.javascript.format | string | | jira.date.picker.java.format | Date Picker Format (Java) | jira.date.picker.java.format | string | | jira.date.time.picker.javascript.format | DateTime Picker Format (JavaScript) | jira.date.time.picker.javascript.format | string | | jira.clone.prefix | The prefix added to the Summary field of cloned issues | jira.clone.prefix | string | +-----------------------------------------+--------------------------------------------------------+-----------------------------------------+--------------+ ``` ### list advanced settings that supports string type value ```sql select id, name, key, type from jira_advanced_setting where type = 'string'; ``` ``` +-----------------------------------------+--------------------------------------------------------+-----------------------------------------+--------+ | id | name | key | type | +-----------------------------------------+--------------------------------------------------------+-----------------------------------------+--------+ | jira.date.time.picker.java.format | DateTime Picker Format (Java) | jira.date.time.picker.java.format | string | | jira.date.time.picker.javascript.format | DateTime Picker Format (JavaScript) | jira.date.time.picker.javascript.format | string | | jira.clone.prefix | The prefix added to the Summary field of cloned issues | jira.clone.prefix | string | | jira.date.picker.javascript.format | Date Picker Format (JavaScript) | jira.date.picker.javascript.format | string | | jira.date.picker.java.format | Date Picker Format (Java) | jira.date.picker.java.format | string | +-----------------------------------------+--------------------------------------------------------+-----------------------------------------+--------+ ```