How to construct compound / multipart JQL Query?

Ken Wood
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 4, 2015

A user wants a report that is based on multiple queries:

 

        A = JIRA ticket count with Condition A

 

        B = JIRA ticket count with Condition B

 

        C = JIRA ticket count with Condition C

 

        print A / (A+B)

 

        print B / (B+C)

There's probably an obvious way to do this using scriptrunner or maybe even with a filter, but all documentation and examples I found were for much simpler cases.

 

Any suggestions on what I should read/look up to figure out an approach to this?

 

Thanks!

1 answer

0 votes
Volodymyr Krupach
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 6, 2015

I do not know the obvious way but I think you can do it via JIRA REST API search method:

https://docs.atlassian.com/jira/REST/latest/#d2e2450

For A, B and C use "total" property.

Suggest an answer

Log in or Sign up to answer