Dhamma Bible

Dataview

1 min read

List of all Sets

list 
from "Dhammas/Sets"
sort number(file.name)
limit 10

Table with relationship

list 
from "Dhammas/Sets"
where length(file.outlinks) != length(items)
sort number(file.name)

With Pali Names

list " (" + file.aliases + ")"
from "Dhammas/Sets"
where length(aliases)>0
sort number(file.name)

List with Pali, Item, Pali

table aliases as Pali, items, flat(items.aliases) as " Pali"
from "Dhammas/Sets"
flatten aliases
where length(aliases)>0
sort number(file.name)

Flattened with full lines

table string(aliases) as Pali, items, string(items.aliases) as " Pali"
from "Dhammas/Sets"
flatten items
where length(aliases)>0
sort number(file.name)

Flattened as string with param as CSV

table string(aliases) as Pali, split(file.path, "/")[1] as Type, string(tags) as Tags, string(items) as Items, string(flat(items.aliases)) as "ItemPali"
from "Dhammas/Sets"
where length(aliases)>0
sort number(file.name)

Flattened with <br>

table string(aliases) as Pali, join(items, "<br>") as Items, join(flat(items.aliases), "<br>") as " Pali"
from "Dhammas"
where length(aliases)>0
sort number(file.name)

Testing

TABLE rows.OUT AS Unresolved FLATTEN file.outlinks AS OUT WHERE !OUT.file AND !(contains(meta(OUT).path, "/")) GROUP BY file.link AS Source

Testing 2

let r = Object.entries(dv.app.metadataCache.unresolvedLinks) .filter(([k,v])=>Object.keys(v).length) .flatMap(([k,v]) => Object.keys(v) .map(x=>dv.fileLink(x))) dv.list([...new Set(r)])

Graph View