Skip to content

Instantly share code, notes, and snippets.

@tyrcho

tyrcho/README.md

Last active December 1, 2022 15:48
Show Gist options
  • Save tyrcho/d7ea98864f0b7d33f2012a87240f5805 to your computer and use it in GitHub Desktop.
Save tyrcho/d7ea98864f0b7d33f2012a87240f5805 to your computer and use it in GitHub Desktop.
Download ZIP
JIRA JQL tricks
Raw
README.md

Search for issues

project = Deepsky and "Business Value">0 AND cf[10953]>0 and 
issueFunction in aggregateExpression("bv","BusinessValue.average()","sp","StoryPoints.average()")

Quick filter

 issueFunction in expression("", "BusinessValue / (StoryPoints+0.01) > 5")

To show non resolved task which are likely to slip

project = "projectKey" AND issueFunction in expression("resolution is empty", "timespent + remainingestimate > originalestimate")

To show non resolved task which are likely to slip by 5 days or more

project = "projectKey" AND issueFunction in expression("resolution is empty", "timespent + remainingestimate > originalestimate + 5*d")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment