Community

How do I create a query to show the Statistics for test case completion by projects

I am looking to display completions rate of test cases by project, what SQL statement can I use to accomplish this?

2 answers

1 accepted

0 vote

Jira does not display precentages and the query I am looking for is not a simple solution, found another way to obtain the infromation I was seeking.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 vote

What does "completions rate" mean? What are the factors?

what SQL statement can I use to accomplish this?

Create your own SQL statements? The jiraissue and the changegroup and changeitems table in the db should be able to give you the information you need.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Products

Interests

Groups

Community resources

Support

How do I create a query to show the Statistics for test case completion by projects

2 answers

1 accepted

Suggest an answer

How to earn badges on the Atlassian Community

Kelvin Yap

5 ways you can make the most of Jira Software and Bitbucket Cloud

Atlassian User Groups

Find my local user group

Groups near you