- Create a Jira filter:
- Navigate to the Issue Navigator in Jira.
- Click on the “Advanced” search option.
- Enter the following JQL query to filter tasks with completed QA and their related QA tasks:sqlCopy code
issuetype = Task AND status = "QA Done" AND "QA Task" IS NOT EMPTY AND "Epic Link" IS NOT EMPTY - If you are having the task type is Testing, then give it and status is Done, then make changes in the query according to it.
- Adjust the query if you have different field names or status names for QA tasks and Epics.
- Save the filter:
- Click on the “Save as” button to save the filter with a meaningful name.
- This allows you to easily access and reuse the filter in the future.
- Export the filter results:
- Once the filter is saved, run the filter to display the filtered tasks.
- Click on the “Export” button and choose the desired export format (e.g., CSV, Excel, PDF).
- Select the columns and formatting options you want to include in the report.
- Save the exported file to your local system.
- Open the exported file:
- Open the exported file using the appropriate software (e.g., Microsoft Excel).
- The file will contain the filtered tasks and their related QA tasks.
- Customize the report as needed, rearranging columns, applying formatting, and calculating additional metrics if required.
By following these steps, you can generate a report in Jira that includes tasks with completed QA and their related QA tasks. The exported file can be further manipulated and formatted based on your reporting needs.
Please note that the specific field names, status names, and export options may vary based on your Jira configuration and version. Adjust the steps accordingly to match your Jira instance.