I need to pull a list of all JIRA Tickets with no test coverage (test cases not written) in a Projec

Murali Raman
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 1, 2021

Probably asked and answered earlier, but here goes, all the same: I have a Project in JIRA that I am working on. The tickets I am involved with are of the types "User Story", "Enhancement" or "Bug". We use TestRail to author the Test cases, and such Test cases are displayed within the JIRA Tickets through an integration between JIRA and TestRail.

I would like to pull a report of a list of all Tickets that have no Test cases written against them (JIRA Tickets of these 3 types with no test coverage). 

How do I accomplish this?

Appreciate your guidance.

NOTE: I have reviewed the canned Reports in JIRA but do not see anything that would allow me to pull a RTM kind of Report.

3 answers

0 votes
mayursuryawanshi777
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 20, 2023

Hi Murali Raman and yongtao_li,

Did you get solution for this?

 

Thanks,

Mayur

yongtao_li November 27, 2023

Hi Mayur,

 

JIRA does not support this function. I had to develop a small tool, the tool reads JIAR DB and TestRail DB, calculates the SRS coverage then writes the SRS coverage and SRS&TestCase matrix to a csv file.

 

BR

Yongtao

mayursuryawanshi777
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 27, 2023

Hi Yongtao,

Thanks for reply.

Is it possible to to share that tool with me?

Thanks,

Mayur

yongtao_li November 27, 2023

Hi Mayur,

The tool is on the server which is in security zone,so I can't share it.

You can look into the DBs of JIRA and TestRail then develop your tool.

BR

Yongtao

0 votes
Jarosław Solecki _Deviniti_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
January 12, 2022

Hi, you could achieve that using Requirements and Test Management for Jira

There is the possibility to create a traceability matrix that will show you coverage by Test Cases. It is based on native Jira relations so you can also use it for other purposes.

 

Screenshot 2022-01-13 at 08.34.43.png

0 votes
yongtao_li August 23, 2021

HI Murali,

Did you find the solution? we meet the same issue.

 

BR

Yongtao

Murali Raman
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 28, 2021

It's been 3 months and 85+ views since I posted this Query, but no answer / solution yet. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events