Skip to content

Instantly share code, notes, and snippets.

@mweagle

mweagle/JIRABootstrap.md

Created February 24, 2020 23:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mweagle/fa8f114f291ec32747c1fcd190ab36e1 to your computer and use it in GitHub Desktop.
Save mweagle/fa8f114f291ec32747c1fcd190ab36e1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
JIRABootstrap.md

Overview

Queries to save as JIRA filters to bootstrap a new project.

JIRA queries

Kanban board query:

project = _YOUR-PROJECT-NAME_ AND status != Closed AND issuetype = Epic ORDER BY priority DESC, updatedDate DESC

Favorite filters:

  • All Epics
    • project = _YOUR-PROJECT-NAME_ AND status != Closed AND issuetype = Epic ORDER BY priority DESC, updatedDate DESC
  • All non-Epics
    • project = _YOUR-PROJECT-NAME_ AND status != Closed AND issuetype in (Story, Task, Sub-task) ORDER BY updated DESC, priority DESC
  • All Stories
    • project = _YOUR-PROJECT-NAME_ AND status != Closed AND issuetype = Story ORDER BY priority DESC, updatedDate DESC
  • All Tasks
    • project = _YOUR-PROJECT-NAME_ AND status != Closed AND issuetype in (Task, Sub-task) ORDER BY priority DESC, updated DESC
  • All unassigned
    • project = _YOUR-PROJECT-NAME_ AND status != Closed AND assignee is EMPTY
  • Epics inbox
    • project = _YOUR-PROJECT-NAME_ AND issuetype = Task AND status = Open AND (labels is EMPTY OR labels in (Inbox)) ORDER BY priority DESC, Rank ASC
  • Open Stories
    • project = _YOUR-PROJECT-NAME_ AND issuetype = Story AND status = "In Progress" ORDER BY Rank ASC
  • Open Sub/Tasks
    • project = _YOUR-PROJECT-NAME_ AND issuetype not in (Epic, Story) AND status != Closed
  • Recently finished Epics
    • project = _YOUR-PROJECT-NAME_ AND issuetype = Epic AND status = Closed AND updated >= -2w AND resolution = Done
  • Recently finished Stories
    • project = _YOUR-PROJECT-NAME_ AND issuetype = Story AND status = Closed AND updated >= -2w AND resolution = Done
  • Recently finished sub/tasks
    • project = _YOUR-PROJECT-NAME_ AND issuetype not in (Epic, Story) AND status = Closed AND updated >= -2w AND resolution = Done
  • Recently finished unplanned work
    • project = _YOUR-PROJECT-NAME_ AND issuetype not in (Epic, Story) AND status = Closed AND updated >= -2w AND resolution = Done AND labels in (unplanned)
  • Stale open stories
    • project = _YOUR-PROJECT-NAME_ AND issuetype = Story AND NOT Status changed during (startofDay(-7d), endofDay()) AND status = Open AND created <= startOfWeek(-2w)
  • Stale open Sub/Tasks
    • project = _YOUR-PROJECT-NAME_ AND issuetype in (Story, Sub-task) AND NOT Status changed during (startofDay(-7d), endofDay()) AND status = Open AND created <= startOfWeek(-2w)
  • Stories and Sub/Tasks WIP
    • project = _YOUR-PROJECT-NAME_ AND status != Closed AND issuetype in (Story, Sub-task) OR project = _YOUR-PROJECT-NAME_ AND issuetype = Story AND status = Closed AND updated >= -2w AND resolution = Done ORDER BY Rank ASC
  • Stories backlog
    • project = _YOUR-PROJECT-NAME_ AND status not in (Closed, "In Progress") AND issuetype = Story ORDER BY priority DESC, Rank ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment