Skip to content

Instantly share code, notes, and snippets.

@silversonicaxel

silversonicaxel/jql-filters

Last active March 21, 2018 10:59
Show Gist options
  • Save silversonicaxel/4f8bfb6320494fae1ea94a7c706abbd7 to your computer and use it in GitHub Desktop.
Save silversonicaxel/4f8bfb6320494fae1ea94a7c706abbd7 to your computer and use it in GitHub Desktop.
Download ZIP
JQL #jira #sql
Raw
jql-filters
// current assignee
project = "PROJECT_NAME" AND assignee is not EMPTY
// last created tickets
project = "PROJECT_NAME" ORDER BY id DESC
// blocked tickets on a status for the last X days
project = "PROJECT_NAME" AND
(status = "In Progress" AND status changed to "In Progress" before -[X]d OR status = "Review" AND status changed to "Review" before -[X]d)
ORDER BY status ASC
// resolved without resolution
project = "PROJECT_NAME" AND status = Resolved AND resolution is EMPTY
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment