DATAVIEW-QUERIES

Dataview Query Templates

Copy these into any Obsidian note. Requires the Dataview plugin.

Contractor shortlist (by rating)

TABLE rating, review_count, review_source, contact_phone, status
FROM "entities"
WHERE entity_type = "company"
SORT rating DESC

Contractors covering a specific area

TABLE rating, specialisms, contact_phone, status
FROM "entities"
WHERE entity_type = "company" AND contains(coverage, "leamington-spa")
SORT rating DESC

Contractors by status

TABLE title, rating, contact_phone
FROM "entities"
WHERE entity_type = "company" AND status = "prospect"
SORT rating DESC

All research goals

TABLE goal, status, confidence, date
FROM ""
WHERE note_type = "goal"
SORT date DESC

Open research questions

TABLE goal, topic, date
FROM ""
WHERE note_type = "goal" AND status != "answered"
SORT date DESC

All entities by type

TABLE entity_type, location, rating
FROM "entities"
SORT entity_type ASC, title ASC

---

Capture Inbox

Unprocessed captures (status: inbox)

TABLE category, topic, captured_at
FROM "capture"
WHERE note_type = "capture" AND status = "inbox"
SORT captured_at DESC

Captures by category

TABLE topic, summary, captured_at, status
FROM "capture"
WHERE note_type = "capture" AND category = "url"
SORT captured_at DESC

Change "url" to "idea", "task", or "observation" as needed.

Captures by topic

TABLE category, captured_at, status
FROM "capture"
WHERE note_type = "capture" AND topic = "work"
SORT captured_at DESC

Change "work" to any topic from capture_config.yaml.

All captures (status tracker)

TABLE category, topic, captured_at, status
FROM "capture"
WHERE note_type = "capture"
SORT captured_at DESC