1. Problem Statement
A worklog extractor in Jira is a tool that allows you to extract worklog data from Jira and store it in a desired format (CSV).
2. Analysis
Checked the API’s for getting worklog details.
| Method | API | Description | |
|---|---|---|---|---|
| 1 | Get Issue | GET |
| will return the project details |
| 2 | Get Worklog | GET |
| will return the worklog |
3.Solution
Step1: Get the project list from the server instance.
Step2: Get the issue list from the project list.
Step3: Get the worklog from all the issues on the list.
Step4: Create a CSV that contains a worklog of all the issues for the particular projects.
4.Estimation
Tasks | Description | Estimated Efforts(hrs) | |
|---|---|---|---|
1 | UI | ||
1.1 | Create an Atlassian project. | create a cloud project with pre-requisites | 2h |
1.2 | Add Projects Field, Date Range Field, Worklog Data Button, and Worklog Data Table | complete UI design | 7h |
2 | Business Logic | ||
2.1 | List the API’s and check with Postman. | 3h | |
2.2 | Write a script for the frontend to get user-entered data from the UI. | will have the user enter details | 6h |
2.3 | Getting the project list | Call APIs and get the details | 3h |
2.4 | Getting the issue list | Call APIs and get the details | 3h |
2.5 | Getting the worklog data | Call APIs and get the details | 3h |
2.6 | Testing | 2h | |
3 | Logger Implementation | ||
3.1 | logger implement | 7h | |
4 | End-to-end testing | ||
Complete process testing | 4h |