TABLE WITHOUT ID link(file.name) AS “Session Date”, Status, players
from “1-Session Journals”
where (type = “Session Journal”)
SORT file.name DESC
TABLE WITHOUT ID link(file.name) AS "Character Name", Player, Class, Race, level, Role from "1-Party" where (Role = "Player") where (Status = "Active")
Recently Modified NPCs
TABLE WITHOUT ID link(file.name) AS "NPC Name", Gender, Race, Age, Location, AssociatedGroup FROM "3-Mechanics/NPCs"WHERE (NoteIcon = "npc") SORT file.mtime DESCLIMIT 10
Recently Modified Locations
TABLE WITHOUT ID link(file.name) AS "Location Name", type, Government, Community-Size, size, population FROM "2-World"WHERE (NoteIcon = "Settlement") SORT file.mtime DESCLIMIT 10
Recently Modified Notes
TABLE WITHOUT ID link(file.path, file.folder + " / " + file.name) AS "Note", file.mtime AS "Last modified"FROM "/"WHERE file.mtime >= date(today) - dur(30 days)AND file.name != this.file.name AND !contains(file.path, "z_Assets") AND !contains(file.path, "Inline Scripts") AND !contains(file.path, "z_Templates") AND !contains(file.path, "daily notes") AND !contains(file.path, "BRAT")SORT file.mtime DESCLIMIT 10
Vault Report
const pages = dv.pages() // maybe narrow down to a subset of pages .groupBy(p => p.NoteIcon) .filter(p => !!p.key); // filter out pages without noteType property// Labelsconst noteTypes = pages.map(p => p.key).values;// Dataconst noteTypesCount = pages.map(p => p.rows.length).values;const chartData = { type: 'bar', data: { labels: noteTypes, datasets: [{ label: 'Count', data: noteTypesCount, backgroundColor: [ 'gold' ], }] }}window.renderChart(chartData, this.container)