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

[Murali Raman]

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.

[mayursuryawanshi777]

Hi Murali Raman and yongtao_li,

Did you get solution for this?

Thanks,

Mayur

[yongtao_li]

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]

Hi Yongtao,

Thanks for reply.

Is it possible to to share that tool with me?

Thanks,

Mayur

[yongtao_li]

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

[Jarosław Solecki _Deviniti_]

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.

[yongtao_li]

HI Murali，

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

BR

Yongtao

[Murali Raman]

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