Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How would I create a query to find out all the issues that were closed since a point in time i.e., 3

mcarreon11 April 2, 2018

How would I create a query to find out all the issues that were closed since a point in time i.e., 3/1/18? Or since a status changed from one thing to another from a given point in time  I know the History shows this information on each issue but I can't find a way to access that information in a query. 

3 answers

0 votes
Alana Fernando
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.
April 3, 2018

hi @mcarreon11,

 

I suppose JIRA has

  • Create
  • update
  • Resolved dates captured. and visible in the side pane.

therefore i suppose currently it is not possible to query Closed tickets with JQL.

 

I usually use below query.

resolutiondate >=  "2018/03/01"

But as @Nic Brough -Adaptavist- said. you can create a report to query this information.  

 

Generating Reports

Creating a JIRA report

mcarreon11 April 5, 2018

I did some more research and found the following resolved my issue

 AND status changed to "" after ""

Alana Fernando
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.
April 5, 2018

I suppose i misunderstood your question @mcarreon11. glad you found a way :) . 

0 votes
Nic Brough -Adaptavist-
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.
April 2, 2018

Code.  You need to do one of:

  • create reports that can find your issues
  • write JQL functions that can look for it
  • create standard custom field and write code to populate them with the closed date
  • write scripted or calculated fields that can go back into the history and look for the dates you want
0 votes
mcarreon11 April 2, 2018

And we cannot create any new custom fields to track the date closed. 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events