It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

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 votes

Answer accepted

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 votes

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

It's not the same without you

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

2 answers

1 accepted

Suggest an answer

Vannya Vallejo Vega

Run into these Solution Partners at Atlassian Open

Community Events

Events near you

Ask a question

Start a discussion

Products

Interests

Groups

Community resources

Support

It's not the same without you

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

2 answers

1 accepted

Suggest an answer

Vannya Vallejo Vega

Run into these Solution Partners at Atlassian Open

Community Events

Events near you