Quartz 4

Tasks by Project

1 min read

Tasks by Project

Project-Based View

All tasks organized by which project they belong to.

Project Overview

TABLE WITHOUT ID
	Project,
	Incomplete,
	Complete,
	Total
FROM "content/_Tasks/Projects"
FLATTEN file.tasks as task
WHERE task
FLATTEN 
	choice(
		contains(task.text, "#star-sailors") OR contains(task.text, "#SS") OR contains(task.text, "#telescope"), 
		"Star Sailors",
		choice(
			contains(task.text, "#bumble") OR contains(task.text, "#BUMBLE"),
			"Bumble",
			choice(
				contains(task.text, "#roving"),
				"Roving",
				choice(
					contains(task.text, "#station"),
					"Station-198",
					"Other"
				)
			)
		)
	) as Project
GROUP BY Project
FLATTEN length(filter(rows.task, (t) => !t.completed)) as Incomplete
FLATTEN length(filter(rows.task, (t) => t.completed)) as Complete
FLATTEN length(rows.task) as Total
SORT Project ASC

Star Sailors

Current Sprint

TASK
FROM "content/_Tasks/Projects"
WHERE file.name = "star-sailors"
AND !completed

All Tasks

TASK
FROM "content/_Tasks/Projects"
WHERE file.name = "star-sailors"
AND !completed
LIMIT 50

Bumble

Current Sprint

TASK
FROM "content/_Tasks/Projects"
WHERE file.name = "bumble"
AND !completed

All Tasks

TASK
FROM "content/_Tasks/Projects"
WHERE file.name = "bumble"
AND !completed
LIMIT 50

Roving

TASK
FROM "content/_Tasks/Projects"
WHERE file.name = "roving"
AND !completed

Station-198

Current Sprint

TASK
FROM "content/_Tasks/Projects"
WHERE file.name = "station-198"
AND !completed

All Tasks

TASK
FROM "content/_Tasks/Projects"
WHERE file.name = "station-198"
AND !completed
LIMIT 50

Shared/Infrastructure

TASK
FROM "content/_Tasks/Projects"
WHERE file.name = "general"
AND !completed
LIMIT 50

Graph View

Backlinks