ToDo List in JQL


JQL functions

Three JQL functions find issues by the state of their ToDo List checklist. They work in any query, with in and not in.

Function Finds issues whose checklist…
issue in allItemsDone() is not empty and has every item resolved (done or skipped).
issue in allItemsUndone() is not empty and has no item started yet: every item is still in the first status of the set (To do by default).
issue in todoItem("text", "state") has an item with exactly this text in this state.

States for todoItem:

State Matches an item that is…
done, +, true resolved, whatever its status (done or skipped).
undone, -, false not resolved.
todo, in_progress, skipped in exactly that status.
any other text in the status with exactly this id (the ids of custom statuses are shown in the field context).

These keywords are not case-sensitive; a status id is. An empty text or an empty state is an error.

Several ToDo List fields. Each function takes the field name as an optional last argument: allItemsDone("Definition of done"), todoItem("Write docs", "done", "Release checklist"). Without it, the function searches across all ToDo List fields of the site.

An empty checklist matches neither allItemsDone() nor allItemsUndone(). Use "<field name>" is EMPTY to find issues without a checklist.

If the site has no ToDo List field, the functions answer “No ToDo List field is configured on this site.”; an empty item text answers “Item text must not be empty.”

issue not in allItemsDone() also finds issues that have no checklist at all.

Jira may keep the answer of a function for up to 7 days before asking the app again.


Searchable properties

Each ToDo List field also has searchable properties. Write them as one quoted string, "<field name>.<property>", for example "ToDo List.TodoProgress" >= 50.

Property Type Meaning
TodoTotal Number Items in the checklist, section headers excluded.
TodoDone Number Resolved items.
TodoProgress Number Percentage of resolved items, 0–100.
TodoOpenMandatory Number Mandatory items that are not resolved yet.
TodoAllDone true / false Every item resolved.
TodoAllUndone true / false No item started yet.
TodoHasNotes true / false At least one item has a note.
TodoItem Text tokens Used by todoItem().
TodoOpen Text Text search over the items that are not resolved.
TodoDoneText Text Text search over the resolved items.
TodoAssignee User Users assigned to items.
TodoDueMin Number Earliest due date of the items, as yyyymmdd (for example 20261115). Empty when no item has a due date.
TodoDueMax Number Latest due date of the items, as yyyymmdd.

Examples:

"ToDo List.TodoOpenMandatory" > 0
"ToDo List.TodoAssignee" = currentUser() AND "ToDo List.TodoAllDone" = false
"ToDo List.TodoDueMin" < 20261101
"ToDo List.TodoOpen" ~ "deploy"

Notes are not searchable as text; only TodoHasNotes says whether there are any.