JQL Group By function

Subhrangshu Choudhury

Hello,

I am trying to generate a report from JIRA which can show me defects raised every month. Say month January I have 10 defects and in month February I have 7 defects.

I want the JQL to give me a report as below:

JAN 10

FEB  07

and so on...

 

Please let me know if this is possible in a single query to filter all the defects count for all the months.

 

Regards

Subhrangshu

Nic Brough -Adaptavist-

JQL (filtering) and reporting are two separate things.

JQL / filters find issues.  That's it.  They have nothing to say about how they are displayed or reported on.  That's up to the reports you use them in.  You can easily filter for "issues per month", because you can use things like "created > startofmonth(x) and created < endofmonth(x)", but the JQL for "all issues I want to see" is simply going to give you all the issues.  The JQL cannot have anything to say about grouping the results up because it is just a search.

The only way I can think of doing this is for you to create one filter for each month, and then put each filter in its own gadget on a dashboard.