How to filter related tasks

Question

Hi all,

Background

We are working in an Agile environment, using Story issue type.

For each story we are pricing the development effort using the Story Points field.

For measure the QA effort, we added a custom field called "QA Story Points".

Each story is linked to a custom issue type called "QA task", and the QA task assignee is the tester of the related story.

My Question

How can I run a JQL query that will provide me the information regarding a specific QA tester? I want to measure the workload on each employee of the team.

Thanks in advance!

Dvir Malka · Answer

Hey @John Funk ,

thanks for the quick response!

The query you suggest will provide me with the QA tasks  information.

I'll share an example:

User story PPP-1, dev story points = 5, QA story points =3.

To the story PPP-1 we have a QA task (related to link), with me as the assignee.

What I want is a query that will provide me with all the Stories that has QA task with me as assignee.

John Funk · Answer

Hi @Dvir Malka  - Welcome to the Atlassian Community!

You should be able to use a JQL like this:

project = ABC and issuetype = "QA task" and assignee = dvir.malka

(where you would put in the actual name of the user).

The other option is to just do this:

Project = ABC and issuetype = "QA task" and statuscategory ! = Done

That will show you all non-completed issues. Then same that filter and share it.

Next, create a Dashboard and add an Issue Statistics gadget to the Dashboard (or just add the gadget to an existing dashboard)

Choose Assignee for the issue statistic. This will show you a count by current assignees.