Docs · TraQL

Query language reference.

TraQL is a structured query language for work items. Field filters, hierarchy traversal, date arithmetic, cross-project queries, aggregations, formatted text output.

Quick start

Open the Queries page from the sidebar. Type a query and press Cmd+Enter to run it.

Find open stories

type:story is:open

Count by status

SELECT count() GROUP BY state

Features with all stories done

type:feature children.state:all(done)

Sprint standup list

SELECT format("- [{title}]({url})") WHERE sprint:active

Filter by any work item property. Fields support equality, comparison, negation, containment, and range operators.

type:story

Stories only

state:in_progress

In-progress items

assignee:Hannes

Assigned to Hannes

title:~"sprint planning"

Title contains text (case-insensitive)

points:>=5

5 or more story points

priority:>2

Priority above 2

id:300..310

ID range (inclusive)

Grammar Summary

query     = filter [ORDER BY sort_list]
          | SELECT func [GROUP BY field] [WHERE filter] [ORDER BY sort_list]

filter    = condition { (AND | OR) condition }
condition = NOT condition | "(" filter ")" | field_expr | was_expr | changed_expr
field_expr= field ":" [operator] value

# History queries
was_expr     = field WAS value [BEFORE date] [AFTER date]
changed_expr = field CHANGED [FROM value TO value] [DURING range]

field     = word { "." word }        # e.g. parent.type, children.state, sprint.health
operator  = "!" | "~" | ">" | ">=" | "<" | "<="
value     = word | quoted_string | word "|" word  | word ".." word | func
          | "empty"                  # null/empty check

func      = word "(" [args] ")"      # count(), sum(points), all(done), last(7d)
sort_list = field [ASC|DESC] { "," field [ASC|DESC] }

# Shortcuts: is:open, is:closed, is:unassigned, is:stale, my:items
# Special values: none, me, active, current, open, future, closed, last, empty, all, today, now
# Sprint health: clean, incomplete, added_late, spilled, carried
# Link values: any, none, blocks, blocked_by
# Keywords: WAS, CHANGED, FROM, TO, BEFORE, AFTER, DURING

TraQL is read-only — it cannot modify work items.