Cheat sheet
The same glossary the lessons underline. Hover a name for the short definition. Print uses two columns on A4 or Letter and hides the navigation. Try this on the board
Fields
- projectThe board a piece of work belongs to. Match the key or the name. project = APP
- issue typeThe kind of work: Epic, Story, Bug, Task, or Sub-task. The field name is still issuetype. issuetype = Bug
- statusWhere the work sits in the workflow, such as To Do, In Progress, or Done. status = "In Progress"
- status categoryA coarser bucket than status: To Do, In Progress, or Done. In Review and Blocked are both In Progress. statusCategory != Done
- priorityHow urgent the work is. This board ranks Highest, Critical, High, Medium, Low, Lowest. priority in (High, Highest)
- assigneeThe person the work is assigned to. Empty means nobody. assignee = currentUser()
- reporterThe person who filed the work. reporter = mina.cho
- resolutionHow closed work was finished. Empty means it is still unresolved. It is not the same as status. resolution is EMPTY
- labelsFree-text tags. Matching is case-sensitive, and an issue can have several. labels = tablet
- componentA product area such as Payments. Equals matches an issue that includes that component among others. component = Payments
- fix versionThe release the work targets. An issue can list more than one. fixVersion = 2.4.0
- sprintA named timebox. openSprints(), closedSprints(), and futureSprints() pick a state. WAS and CHANGED can see a move between sprints. sprint = N14
- due dateA calendar date with no clock time. duedate <= endOfWeek()
- summaryThe title. Use ~ for a word search and = for the whole title. summary ~ "deploy*"
- parentThe direct parent issue. This is not the legacy Epic Link field. parent = APP-1
- epicA large container of work. On this board its children use parent, not Epic Link. parent = APP-1
- Epic LinkA legacy custom field, cf[10014]. It is a different field from parent. cf[10014] = APP-1
- cf[id]The numeric id of a custom field. Required when the same name exists twice, such as Team. cf[10100] = Platform
- filterA named search. filter = "Name" and savedFilter = "Name" run that filter's JQL. They are not app functions. filter = "Open Field App"
Operators
- emptyThe field has no value. IS EMPTY, IS NULL, and = EMPTY are the same test. assignee is EMPTY
- ANDAND binds tighter than OR. Wrap an OR group in parentheses when both appear. (status = "To Do" OR status = "In Progress") AND priority = Highest
- not equal!= and NOT IN skip issues where the field is empty. resolution != Done OR resolution is EMPTY
- tildeWord search. A trailing * matches a longer word. A leading * is rejected. summary ~ "deploy*"
- ORDER BYSorts the result. ASC is the default. Empty values come first on ASC. ORDER BY priority DESC, updated ASC
- WASHistory operators. They work on assignee, fixVersion, priority, reporter, resolution, and status. status WAS Blocked
- WAS INWAS IN matches any listed past or current value. WAS NOT matches a different value. CHANGED FROM and TO name one changelog row. status CHANGED FROM "To Do" TO "In Progress" DURING (-90d, now())
Functions and dates
- current userThe person the sandbox is running as. Lessons use Mina Cho. assignee = currentUser()
- membersOfThe people in a group. Use it with IN, not with =. assignee in membersOf("field-app")
- relative dateA duration uses m, h, d, or w. -7d is seven 24-hour days. days is not a unit. updated >= -7d
- openSprints()Lists of sprints by state. Use them with IN. N14 is open, N12 and N13 are closed, N15 is future. sprint in openSprints()
- endOfMonth()The last millisecond of the calendar month. It is not the same as a rolling -30d. duedate <= endOfMonth()
- now()The clock at the moment the query runs. On this board it is frozen so a due date can be overdue in a repeatable way. A date with no time is midnight UTC, so a due date of today is already before now(). duedate < now() AND resolution is EMPTY
Renamed terms
- work itemThe newer screen name for an issue. JQL still says issuetype and uses issue keys. issuetype = Bug
- spaceThe newer screen name for a project. The query field is still project. project = APP