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

7 answers

1 accepted

17 votes
Accepted answer

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.

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

4 votes

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"

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>

Ogon!

This what I need!

Thanks! 

This was helpful.

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

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.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

978 views 3 9
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you