Results
### Basic info
```sql
select
id,
name,
description,
avatar_id
from
jira_issue_type;
```
```
+-------+--------------------------------+---------------------------------------------------------------------+-----------+
| id | name | description | avatar_id |
+-------+--------------------------------+---------------------------------------------------------------------+-----------+
| 10019 | Employee onboarding | Submit an onboarding request for a new hire. | 10553 |
| 10010 | Bug | A problem or error. | 10303 |
| 10005 | Subtask | Subtasks track small pieces of work that are part of a larger task. | 10316 |
| 10008 | Sub-task | A small piece of work that's part of a larger task. | 10316 |
| 10017 | Change request | Send a request to make changes to your information. | 10551 |
| 10015 | Epic | A collection of related bugs, stories, and tasks. | 10307 |
| 10018 | Questions for HR | Send us a question or make a general request. | 10552 |
| 10011 | Story | Functionality or a feature expressed as a user goal. | 0 |
| 10003 | Bug | A problem or error. | 10303 |
| 10020 | IT Help | An IT problem or question. | 10554 |
| 10006 | Improvement | An improvement or enhancement to an existing feature or task. | 10310 |
| 10007 | Task | A small, distinct piece of work. | 10318 |
| 10012 | Story | Functionality or a feature expressed as a user goal. | 10315 |
| 10009 | New Feature | A new feature of the product, which has yet to be developed. | 10311 |
| 10013 | Task | A small, distinct piece of work. | 10318 |
| 10004 | Epic | A collection of related bugs, stories, and tasks. | 10307 |
| 10022 | Service Request | A request that follows ITSM workflows. | 10556 |
| 10014 | Bug | A problem or error. | 10303 |
| 10016 | Subtask | Subtasks track small pieces of work that are part of a larger task. | 10316 |
| 10000 | Epic | A collection of related bugs, stories, and tasks. | 0 |
| 10021 | Employee offboarding | Submit an offboarding request for an employee leaving the company. | 10555 |
| 10002 | Task | A small, distinct piece of work. | 10318 |
| 10026 | new-test-type | test type | 10314 |
| 10001 | Story | Functionality or a feature expressed as a user goal. | 10315 |
| 10023 | Emailed request | Request received from your email support channel. | 10557 |
| 10024 | Service Request with Approvals | A requests that may require approval. | 10558 |
+-------+--------------------------------+---------------------------------------------------------------------+-----------+
```
### List issue types for a specific project
```sql
select
id,
name,
description,
avatar_id,
scope
from
jira_issue_type
where
scope -> 'project' ->> 'id' = '10000';
```
```
+-------+---------+---------------------------------------------------------------------+-----------+---------------------------------------------+
| id | name | description | avatar_id | scope |
+-------+---------+---------------------------------------------------------------------+-----------+---------------------------------------------+
| 10004 | Epic | A collection of related bugs, stories, and tasks. | 10307 | {"project":{"id":"10000"},"type":"PROJECT"} |
| 10001 | Story | Functionality or a feature expressed as a user goal. | 10315 | {"project":{"id":"10000"},"type":"PROJECT"} |
| 10003 | Bug | A problem or error. | 10303 | {"project":{"id":"10000"},"type":"PROJECT"} |
| 10002 | Task | A small, distinct piece of work. | 10318 | {"project":{"id":"10000"},"type":"PROJECT"} |
| 10005 | Subtask | Subtasks track small pieces of work that are part of a larger task. | 10316 | {"project":{"id":"10000"},"type":"PROJECT"} |
+-------+---------+---------------------------------------------------------------------+-----------+---------------------------------------------+
```
### List issue types associated with subtask creation
```sql
select
id,
name,
description,
avatar_id,
subtask
from
jira_issue_type
where
subtask;
```
```
+-------+----------+---------------------------------------------------------------------+-----------+---------+
| id | name | description | avatar_id | subtask |
+-------+----------+---------------------------------------------------------------------+-----------+---------+
| 10008 | Sub-task | A small piece of work that's part of a larger task. | 10316 | true |
| 10005 | Subtask | Subtasks track small pieces of work that are part of a larger task. | 10316 | true |
| 10016 | Subtask | Subtasks track small pieces of work that are part of a larger task. | 10316 | true |
+-------+----------+---------------------------------------------------------------------+-----------+---------+
```
### List issue types with hierarchy_level 0 (Base)
```sql
select
id,
name,
description,
avatar_id,
hierarchy_level
from
jira_issue_type
where
hierarchy_level = '0';
```
```
+-------+--------------------------------+--------------------------------------------------------------------+-----------+-----------------+
| id | name | description | avatar_id | hierarchy_level |
+-------+--------------------------------+--------------------------------------------------------------------+-----------+-----------------+
| 10010 | Bug | A problem or error. | 10303 | 0 |
| 10020 | IT Help | An IT problem or question. | 10554 | 0 |
| 10011 | Story | Functionality or a feature expressed as a user goal. | 0 | 0 |
| 10019 | Employee onboarding | Submit an onboarding request for a new hire. | 10553 | 0 |
| 10001 | Story | Functionality or a feature expressed as a user goal. | 10315 | 0 |
| 10007 | Task | A small, distinct piece of work. | 10318 | 0 |
| 10017 | Change request | Send a request to make changes to your information. | 10551 | 0 |
| 10003 | Bug | A problem or error. | 10303 | 0 |
| 10009 | New Feature | A new feature of the product, which has yet to be developed. | 10311 | 0 |
| 10022 | Service Request | A request that follows ITSM workflows. | 10556 | 0 |
| 10013 | Task | A small, distinct piece of work. | 10318 | 0 |
| 10021 | Employee offboarding | Submit an offboarding request for an employee leaving the company. | 10555 | 0 |
| 10023 | Emailed request | Request received from your email support channel. | 10557 | 0 |
| 10012 | Story | Functionality or a feature expressed as a user goal. | 10315 | 0 |
| 10002 | Task | A small, distinct piece of work. | 10318 | 0 |
| 10018 | Questions for HR | Send us a question or make a general request. | 10552 | 0 |
| 10014 | Bug | A problem or error. | 10303 | 0 |
| 10024 | Service Request with Approvals | A requests that may require approval. | 10558 | 0 |
| 10026 | new-test-type | test type | 10314 | 0 |
| 10006 | Improvement | An improvement or enhancement to an existing feature or task. | 10310 | 0 |
+-------+--------------------------------+--------------------------------------------------------------------+-----------+-----------------+
```
Integration test logs
Logs
``` N/A ```Example query results
Results
### Basic info ```sql select id, name, description, avatar_id from jira_issue_type; ``` ``` +-------+--------------------------------+---------------------------------------------------------------------+-----------+ | id | name | description | avatar_id | +-------+--------------------------------+---------------------------------------------------------------------+-----------+ | 10019 | Employee onboarding | Submit an onboarding request for a new hire. | 10553 | | 10010 | Bug | A problem or error. | 10303 | | 10005 | Subtask | Subtasks track small pieces of work that are part of a larger task. | 10316 | | 10008 | Sub-task | A small piece of work that's part of a larger task. | 10316 | | 10017 | Change request | Send a request to make changes to your information. | 10551 | | 10015 | Epic | A collection of related bugs, stories, and tasks. | 10307 | | 10018 | Questions for HR | Send us a question or make a general request. | 10552 | | 10011 | Story | Functionality or a feature expressed as a user goal. | 0 | | 10003 | Bug | A problem or error. | 10303 | | 10020 | IT Help | An IT problem or question. | 10554 | | 10006 | Improvement | An improvement or enhancement to an existing feature or task. | 10310 | | 10007 | Task | A small, distinct piece of work. | 10318 | | 10012 | Story | Functionality or a feature expressed as a user goal. | 10315 | | 10009 | New Feature | A new feature of the product, which has yet to be developed. | 10311 | | 10013 | Task | A small, distinct piece of work. | 10318 | | 10004 | Epic | A collection of related bugs, stories, and tasks. | 10307 | | 10022 | Service Request | A request that follows ITSM workflows. | 10556 | | 10014 | Bug | A problem or error. | 10303 | | 10016 | Subtask | Subtasks track small pieces of work that are part of a larger task. | 10316 | | 10000 | Epic | A collection of related bugs, stories, and tasks. | 0 | | 10021 | Employee offboarding | Submit an offboarding request for an employee leaving the company. | 10555 | | 10002 | Task | A small, distinct piece of work. | 10318 | | 10026 | new-test-type | test type | 10314 | | 10001 | Story | Functionality or a feature expressed as a user goal. | 10315 | | 10023 | Emailed request | Request received from your email support channel. | 10557 | | 10024 | Service Request with Approvals | A requests that may require approval. | 10558 | +-------+--------------------------------+---------------------------------------------------------------------+-----------+ ``` ### List issue types for a specific project ```sql select id, name, description, avatar_id, scope from jira_issue_type where scope -> 'project' ->> 'id' = '10000'; ``` ``` +-------+---------+---------------------------------------------------------------------+-----------+---------------------------------------------+ | id | name | description | avatar_id | scope | +-------+---------+---------------------------------------------------------------------+-----------+---------------------------------------------+ | 10004 | Epic | A collection of related bugs, stories, and tasks. | 10307 | {"project":{"id":"10000"},"type":"PROJECT"} | | 10001 | Story | Functionality or a feature expressed as a user goal. | 10315 | {"project":{"id":"10000"},"type":"PROJECT"} | | 10003 | Bug | A problem or error. | 10303 | {"project":{"id":"10000"},"type":"PROJECT"} | | 10002 | Task | A small, distinct piece of work. | 10318 | {"project":{"id":"10000"},"type":"PROJECT"} | | 10005 | Subtask | Subtasks track small pieces of work that are part of a larger task. | 10316 | {"project":{"id":"10000"},"type":"PROJECT"} | +-------+---------+---------------------------------------------------------------------+-----------+---------------------------------------------+ ``` ### List issue types associated with subtask creation ```sql select id, name, description, avatar_id, subtask from jira_issue_type where subtask; ``` ``` +-------+----------+---------------------------------------------------------------------+-----------+---------+ | id | name | description | avatar_id | subtask | +-------+----------+---------------------------------------------------------------------+-----------+---------+ | 10008 | Sub-task | A small piece of work that's part of a larger task. | 10316 | true | | 10005 | Subtask | Subtasks track small pieces of work that are part of a larger task. | 10316 | true | | 10016 | Subtask | Subtasks track small pieces of work that are part of a larger task. | 10316 | true | +-------+----------+---------------------------------------------------------------------+-----------+---------+ ``` ### List issue types with hierarchy_level 0 (Base) ```sql select id, name, description, avatar_id, hierarchy_level from jira_issue_type where hierarchy_level = '0'; ``` ``` +-------+--------------------------------+--------------------------------------------------------------------+-----------+-----------------+ | id | name | description | avatar_id | hierarchy_level | +-------+--------------------------------+--------------------------------------------------------------------+-----------+-----------------+ | 10010 | Bug | A problem or error. | 10303 | 0 | | 10020 | IT Help | An IT problem or question. | 10554 | 0 | | 10011 | Story | Functionality or a feature expressed as a user goal. | 0 | 0 | | 10019 | Employee onboarding | Submit an onboarding request for a new hire. | 10553 | 0 | | 10001 | Story | Functionality or a feature expressed as a user goal. | 10315 | 0 | | 10007 | Task | A small, distinct piece of work. | 10318 | 0 | | 10017 | Change request | Send a request to make changes to your information. | 10551 | 0 | | 10003 | Bug | A problem or error. | 10303 | 0 | | 10009 | New Feature | A new feature of the product, which has yet to be developed. | 10311 | 0 | | 10022 | Service Request | A request that follows ITSM workflows. | 10556 | 0 | | 10013 | Task | A small, distinct piece of work. | 10318 | 0 | | 10021 | Employee offboarding | Submit an offboarding request for an employee leaving the company. | 10555 | 0 | | 10023 | Emailed request | Request received from your email support channel. | 10557 | 0 | | 10012 | Story | Functionality or a feature expressed as a user goal. | 10315 | 0 | | 10002 | Task | A small, distinct piece of work. | 10318 | 0 | | 10018 | Questions for HR | Send us a question or make a general request. | 10552 | 0 | | 10014 | Bug | A problem or error. | 10303 | 0 | | 10024 | Service Request with Approvals | A requests that may require approval. | 10558 | 0 | | 10026 | new-test-type | test type | 10314 | 0 | | 10006 | Improvement | An improvement or enhancement to an existing feature or task. | 10310 | 0 | +-------+--------------------------------+--------------------------------------------------------------------+-----------+-----------------+ ```