JQL To find issues in particular status for specific duration

[Shaikh Moiz]

Hi team,

I need to get a list of issues, which are in certain status for a specific duration, lets say for example,

Status = "In Progress" want to get list of issues which remains in this status for last two weeks,

Any help is appreciated.

Thanks and regards,

<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/ask/&amp;cb=0.7625651301376403"></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>

[JamieA · Accepted solution]

Something like:

status = Open and not status changed after -2w

[Shaikh Moiz]

Thanks Jamie for your quick response , i appreciate your support and quick response.

Regards,

Moiz.

<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/230063/jql-to-find-issues-in-particular-status-for-specific-duration&amp;cb=0.14122157438888128"></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>

[JulianA]

Hey Shaikh,

I don't see a possibillity for this now in standard way ... Maybe the script runner plugin could help you, by adding a jql function to it?

Cheers

Julian