JQL query for stories moved and stories stuck

[Ayan.Basu]

Hi Team - For our Jira board we have more than 250 stories which will start from Requirement till Deployment in 8 phases as per our workflow. I need help to create a JQL query to filter out stories moved in last 7 days and stories stuck for more than 30 days. 

Any suggestion what the query should be helpful !

Thank You ,

Ayaan 

[Sanjog Sigdel]

Hi @Ayan.Basu ,

You can use following query to fulfil your requirements:-

project = "Project Name" AND issuetype in standardissuetypes() AND status changed to "In Progress" AFTER -7d

This filter alone gives you tickets that were changed to In Progress in last seven days. You can add your required status.

project = "Project Name" AND issuetype in standardissuetypes() AND status = "In Progress" AND updatedDate <= -30d

This filter checks a ticket stuck in In Progress state for thirty days. If you want any Paused or Blocked status, replace it with In Progress. and if you want to combinely run this query do the following:-

(project = "Project Name" AND issuetype in standardissuetypes() AND status changed to "In Progress" AFTER -7d) OR (project = "Project Name" AND issuetype in standardissuetypes() AND status = "In Progress" AND updatedDate <= -30d)

The OR statements lists the tickets which meets any one requirement.