Results
### Basic info
```sql
select
key,
project_key,
created,
creator_display_name,
status,
summary
from
jira_backlog_issue;
```
```
+---------+-------------+---------------------+----------------------+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| key | project_key | created | creator_display_name | status | summary |
+---------+-------------+---------------------+----------------------+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| TEST-1 | TEST | 2021-06-08 10:18:50 | Lalit Bhardwaj | To Do | test |
| TEST1-1 | TEST1 | 2021-06-23 13:47:06 | sayan | To Do | test issue |
| TEST1-2 | TEST1 | 2021-06-23 14:09:31 | sayan | To Do | another issue |
| TEST1-5 | TEST1 | 2021-06-25 13:05:16 | sayan | To Do | tsk |
| SSP-5 | SSP | 2021-06-01 11:09:00 | Lalit Bhardwaj | To Do | As a team, I'd like to commit to a set of stories to be completed in a sprint (or iteration) >> Click "Create Sprint" then drag the footer down to select issues for a sprint (you can't start a sprint at the moment because one is already active) |
| SSP-2 | SSP | 2021-06-01 11:08:59 | Lalit Bhardwaj | To Do | As a product owner, I'd like to express work in terms of actual user problems, aka User Stories, and place them in the backlog >> Try creating a new story with the "+ Create Issue" button (top right of screen) |
| SSP-6 | SSP | 2021-06-01 11:09:00 | Lalit Bhardwaj | To Do | As a scrum master, I'd like to break stories down into tasks we can track during the sprint >> Try creating a task by clicking the Sub-Tasks tab in the Detail View on the right |
| SSP-8 | SSP | 2021-06-01 11:09:01 | Lalit Bhardwaj | To Do | As a product owner, I'd like to include bugs, tasks and other issue types in my backlog >> Bugs like this one will also appear in your backlog but they are not normally estimated |
| SSP-3 | SSP | 2021-06-01 11:09:00 | Lalit Bhardwaj | To Do | As a product owner, I'd like to rank stories in the backlog so I can communicate the proposed implementation order >> Try dragging this story up above the previous story |
| SSP-7 | SSP | 2021-06-01 11:09:00 | Lalit Bhardwaj | To Do | This is a sample task. Tasks are used to break down the steps to implement a user story |
| SSP-4 | SSP | 2021-06-01 11:09:00 | Lalit Bhardwaj | To Do | As a team, I'd like to estimate the effort of a story in Story Points so we can understand the work remaining >> Try setting the Story Points for this story in the "Estimate" field |
| SSP-25 | SSP | 2021-06-14 23:12:09 | John Smyth | To Do | as a reviewer, i want to see what is linked to an epic |
| SSP-9 | SSP | 2021-06-01 11:09:01 | Lalit Bhardwaj | To Do | As a developer, I'd like to update story status during the sprint >> Click the Active sprints link at the top right of the screen to go to the Active sprints where the current Sprint's items can be updated |
+---------+-------------+---------------------+----------------------+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
```
### List issues for a specific project
```sql
select
id,
key,
project_key,
created,
creator_display_name,
assignee_display_name,
status,
summary
from
jira_backlog_issue
where
project_key = 'TEST1';
```
```
+-------+---------+-------------+---------------------+----------------------+-----------------------+--------+---------------+
| id | key | project_key | created | creator_display_name | assignee_display_name | status | summary |
+-------+---------+-------------+---------------------+----------------------+-----------------------+--------+---------------+
| 10043 | TEST1-5 | TEST1 | 2021-06-25 13:05:16 | sayan | sayan | To Do | tsk |
| 10040 | TEST1-2 | TEST1 | 2021-06-23 14:09:31 | sayan | | To Do | another issue |
| 10039 | TEST1-1 | TEST1 | 2021-06-23 13:47:06 | sayan | | To Do | test issue |
+-------+---------+-------------+---------------------+----------------------+-----------------------+--------+---------------+
```
### List all issues assigned to a specific user
```sql
select
id,
key,
summary,
project_key,
status,
assignee_display_name,
assignee_account_id
from
jira_backlog_issue
where
assignee_display_name = 'sayan';
```
```
+-------+---------+---------+-------------+--------+-----------------------+--------------------------+
| id | key | summary | project_key | status | assignee_display_name | assignee_account_id |
+-------+---------+---------+-------------+--------+-----------------------+--------------------------+
| 10043 | TEST1-5 | tsk | TEST1 | To Do | sayan | 60ccb403c90cb2006814fb8b |
+-------+---------+---------+-------------+--------+-----------------------+--------------------------+
```
### List issues due in the 30 days
```sql
select
id,
key,
summary,
project_key,
status,
assignee_display_name,
assignee_account_id,
due_date
from
jira_backlog_issue
where
due_date > current_date
and due_date <= (current_date + interval '30' day);
```
```
+-------+---------+---------+-------------+--------+-----------------------+--------------------------+---------------------+
| id | key | summary | project_key | status | assignee_display_name | assignee_account_id | due_date |
+-------+---------+---------+-------------+--------+-----------------------+--------------------------+---------------------+
| 10043 | TEST1-5 | tsk | TEST1 | To Do | sayan | 60ccb403c90cb2006814fb8b | 2021-06-30 00:00:00 |
+-------+---------+---------+-------------+--------+-----------------------+--------------------------+---------------------+
```
Integration test logs
Logs
``` N/A ```Example query results
Results
### Basic info ```sql select key, project_key, created, creator_display_name, status, summary from jira_backlog_issue; ``` ``` +---------+-------------+---------------------+----------------------+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | key | project_key | created | creator_display_name | status | summary | +---------+-------------+---------------------+----------------------+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | TEST-1 | TEST | 2021-06-08 10:18:50 | Lalit Bhardwaj | To Do | test | | TEST1-1 | TEST1 | 2021-06-23 13:47:06 | sayan | To Do | test issue | | TEST1-2 | TEST1 | 2021-06-23 14:09:31 | sayan | To Do | another issue | | TEST1-5 | TEST1 | 2021-06-25 13:05:16 | sayan | To Do | tsk | | SSP-5 | SSP | 2021-06-01 11:09:00 | Lalit Bhardwaj | To Do | As a team, I'd like to commit to a set of stories to be completed in a sprint (or iteration) >> Click "Create Sprint" then drag the footer down to select issues for a sprint (you can't start a sprint at the moment because one is already active) | | SSP-2 | SSP | 2021-06-01 11:08:59 | Lalit Bhardwaj | To Do | As a product owner, I'd like to express work in terms of actual user problems, aka User Stories, and place them in the backlog >> Try creating a new story with the "+ Create Issue" button (top right of screen) | | SSP-6 | SSP | 2021-06-01 11:09:00 | Lalit Bhardwaj | To Do | As a scrum master, I'd like to break stories down into tasks we can track during the sprint >> Try creating a task by clicking the Sub-Tasks tab in the Detail View on the right | | SSP-8 | SSP | 2021-06-01 11:09:01 | Lalit Bhardwaj | To Do | As a product owner, I'd like to include bugs, tasks and other issue types in my backlog >> Bugs like this one will also appear in your backlog but they are not normally estimated | | SSP-3 | SSP | 2021-06-01 11:09:00 | Lalit Bhardwaj | To Do | As a product owner, I'd like to rank stories in the backlog so I can communicate the proposed implementation order >> Try dragging this story up above the previous story | | SSP-7 | SSP | 2021-06-01 11:09:00 | Lalit Bhardwaj | To Do | This is a sample task. Tasks are used to break down the steps to implement a user story | | SSP-4 | SSP | 2021-06-01 11:09:00 | Lalit Bhardwaj | To Do | As a team, I'd like to estimate the effort of a story in Story Points so we can understand the work remaining >> Try setting the Story Points for this story in the "Estimate" field | | SSP-25 | SSP | 2021-06-14 23:12:09 | John Smyth | To Do | as a reviewer, i want to see what is linked to an epic | | SSP-9 | SSP | 2021-06-01 11:09:01 | Lalit Bhardwaj | To Do | As a developer, I'd like to update story status during the sprint >> Click the Active sprints link at the top right of the screen to go to the Active sprints where the current Sprint's items can be updated | +---------+-------------+---------------------+----------------------+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ ``` ### List issues for a specific project ```sql select id, key, project_key, created, creator_display_name, assignee_display_name, status, summary from jira_backlog_issue where project_key = 'TEST1'; ``` ``` +-------+---------+-------------+---------------------+----------------------+-----------------------+--------+---------------+ | id | key | project_key | created | creator_display_name | assignee_display_name | status | summary | +-------+---------+-------------+---------------------+----------------------+-----------------------+--------+---------------+ | 10043 | TEST1-5 | TEST1 | 2021-06-25 13:05:16 | sayan | sayan | To Do | tsk | | 10040 | TEST1-2 | TEST1 | 2021-06-23 14:09:31 | sayan |