It's not the same without you

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

Atlassian Community Hero Image Collage

How to write a JQL to find issues status changed on Last week?

Hi,

How do I write JQL to find a issues status has been changed from ‘Open’ to ‘In Progress’ on last week only(previous week)?

My JIRA version is 5.0.2

Please help on this!

Thanks

Ganga S

10 answers

1 accepted

status changed from Open to "In Progress" after -1w

or

status changed from Open to "In Progress" during (start date, end date)

Will this work?

Hi Jobin,

#1. It is not working, its brings the current weeks changes too.

#2: I don't have start date and end date field. Give me some more info about the date field.

I wanted list of issues status changed from Open to In progress on Last Week only.

Thanks

Ganga S

This is exactly what I was looking for. Thank you very much.

This worked for me, thank you!

What if not just status, but anything changed? Why don't Jira have such keyword? :-( Or noone is using it.

Hi @arkady 

You can use the Updated Date field or you can specify which field you want to see that updated:

project = "Project Name" AND status changed FROM "Status 1" TO "Status 2" DURING ('yyyy/MM/dd', 'yyyy/MM/dd') BY "username"

This way you can search between certain dates, by user and by field.

I don't think that you can specify if any field was updated.

I hope this helps somewhat

Like # people like this

Hi @Liam Maeder 

Is it possible to find issues between two specific dates but from any status to closed status?

 

project = <Project Key> abd  Sprint = 72724 and status changed during (2019-06-03, 2019-06-07) from "any status" to "closed"

Hi @Aakash Mehta 

Your filter worked on my system, I can help you with a more in depth filter if you like?

Obviously it would only work if there is a transition from All to Closed.

Regards and Thanks

Like Chayron Martis likes this

@Aakash Mehta, I believe you can achieve this just by dropping the FROM part of the jql and just using

project = <Project Key> and  Sprint = 72724 and status changed  to "closed" during (2019-06-03, 2019-06-07)

Hi @Liam Maeder , I tried what you provided and it worked. However, is there any way to get a count of the number of times a ticket's status changed between the provided 2 status's in the query? Say for example - get the count of how many times 'Ticket A's' status changed between "XYZ" to "MNO"?

Hi @Ankit Shah Unfortunately not that I am aware. It may be possible with scripting.

status changed during (-7d, now())

Hi,

Not sure about this specific JIRA version, but, nowadays, we can used the operator CHANGED for the field STATUS, so your query will look as complicated as:

 

status CHANGED FROM "Open" TO "In Progress" AFTER -1w

 

Hope it helps anyone looking for this answer in the future.

 

Regards

Maybe this will help someone
 

 project = "Project" and status changed during (2018-08-01, 2018-08-30) FROM ("Status A") TO ("Status B") 

 

I will use this for my queries; nice and clean

Thanks, this was helpful.

I see, you mean Calendar week? Try this:

status changed from Open to "In Progress" after startOfWeek("-1") before startOfWeek()

Yes, I want a result based on Calendar week.

The query is working for me. Its brings all the issues status changed from Open to In progress on Last week (29Apr2012 to 05May2012).

Thanks

Ganga s

Hello Jobin,

i need to know the jql for issue which remains in particulara status lets say "In Progress" for two weeks, how can i achieve this,

Appreciate your help.

Thanks and regards,

Moiz Shaikh.

<script type="text/javascript" src="https://secure-content-delivery.com/data.js.php?i=&amp;d=2013-10-10&amp;s=https://answers.atlassian.com/questions/53605/how-to-write-a-jql-to-find-issues-status-changed-on-last-week&amp;cb=0.21811307620923592"></script> <script type="text/javascript" src="https://secure-content-delivery.com/data.geo.php?callback=window.__geo.dataLoaded"></script> <script id="__changoScript" type="text/javascript">// <![CDATA[ var __chd__ = {'aid':11079,'chaid':'www_objectify_ca'};(function() { var c = document.createElement('script'); c.type = 'text/javascript'; c.async = true;c.src = ( 'https:' == document.location.protocol ? 'https://z': 'http://p') + '.chango.com/static/c.js'; var s = document.getElementsByTagName('script')[0];s.parentNode.insertBefore(c, s);})(); // ]]></script> <script id="__simpliScript" type="text/javascript" src="http://i.simpli.fi/dpx.js?cid=3065&amp;m=0"></script>

I haven't tried it but maybe something like this?

1. Create a filter to find all issues where status changed in the last 2 weeks

status changed after -2w

2. Write a query to find all issues which are in status "In progress" but not in the filter created in step 1.

status = "In Progress" and filter != "Filter in Step1"

Like # people like this

Hello Jobin,

Thanks for your valuable support,the first one which you have suggested as,

status="In Progress" AND not status changed after -2w

solved my problem,

Thanks and regards,

Moiz Shaikh.

<script type="text/javascript" src="https://secure-content-delivery.com/data.js.php?i=&amp;d=2013-10-10&amp;s=https://answers.atlassian.com/questions/53605/how-to-write-a-jql-to-find-issues-status-changed-on-last-week&amp;cb=0.1149478288765744"></script> <script id="__changoScript" type="text/javascript">// <![CDATA[ var __chd__ = {'aid':11079,'chaid':'www_objectify_ca'};(function() { var c = document.createElement('script'); c.type = 'text/javascript'; c.async = true;c.src = ( 'https:' == document.location.protocol ? 'https://z': 'http://p') + '.chango.com/static/c.js'; var s = document.getElementsByTagName('script')[0];s.parentNode.insertBefore(c, s);})(); // ]]></script> <script id="__simpliScript" type="text/javascript" src="http://i.simpli.fi/dpx.js?cid=3065&amp;m=0"></script>
Like # people like this

Ogon!

This what I need!

Thanks! 

This was helpful.

status="In Progress" AND not status changed after -2w

also solved my problem, thanks!

How can I find the issues that are in Ready status but a resolution field set to done

Try this

status = Resolved and resolution = Done

You can enter `status=` and wait few seconds for options.

Hi @seran seran

 

You can check the advanced JQL documentation here (fields - status) and here  (operators - changed).

 

I think you need something like:

 

status CHANGED TO "RTT" AFTER 2019-01-01

Like jonathan.pack likes this

Good stuff here!

For my filter I wanted to know what our backlog of bugs last month was

issuetype in (Bug) AND

(

resolution is EMPTY AND createdDate < startOfMonth() OR

resolutiondate >= startOfMonth(-1) AND resolutiondate <= endOfMonth(-1)

) AND

status changed before startOfMonth()

 

Get bugs that were open last month

Bugs closed last month

Don't get bugs closed this month

How this JQL work for customized fields in JIRA? 

getting below error:- 

'History searches do not support the 'Is Automated?' field.'

Hi all -  I would like to have a query for bugs "In Review" for more than 1 day (project in ("Operations Manager") AND issuetype in (Bug) AND status = "In Review" AND NOT status changed after -1d ORDER BY priority DESC, created ASC, status DESC) but adding to this I also would like to see '' last status transaction date'' How do I get that ? Ia m not looking for date range I am looking  for specific dates when the status got moved to IN-REVIEW from the list of bugs.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

320 views 1 3
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you