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.

