SqueakQL examples

My open Work Items

assignee = CURRENT_USER
AND status <> 'done'
ORDER BY priority DESC, updated_at DESC

Urgent Work Items

priority = 'urgent'
AND status <> 'done'
ORDER BY updated_at DESC

Recently updated

updated_at >= CURRENT_TIMESTAMP - INTERVAL '7 days'
ORDER BY updated_at DESC

Unassigned work

assignee IS NULL
AND status <> 'done'

Bugs that still need work

type = 'bug'
AND status <> 'done'
ORDER BY priority DESC, created_at ASC

Top-level planning work

parent IS NULL
AND status IN ('backlog', 'todo')

API or webhook work

(title ILIKE '%webhook%' OR description ILIKE '%webhook%')
AND status <> 'done'