Blog

TABLE WITHOUT ID Post, Maturity, file.mday as "Last Edited", file.cday as "Created"
 
WHERE dg-publish = True or dg-publish = 1
AND ((contains(lower(topic), lower(this.file.name))
		AND contains(type, "blog")
		AND !contains(type, "topic"))
	OR contains(lower(theme), lower(this.file.name))
)
	
 
FLATTEN link(file.link, file.name) as Post
 
FLATTEN link(file.link, file.name) as Post
FLATTEN choice(maturity="seed","🫘" ,"") + choice(maturity="sprout","🌱" ,"") + choice(maturity="sapling","🪴" ,"") + choice(maturity="tree","🌲" ,"") + choice(maturity="snag","🪵" ,"") + choice(maturity="signpost","🪧" ,"") + choice(maturity="stone","🪨" ,"") as Maturity
 
SORT file.mday DESC