Bàsics Dataview

List

FROM un tag

list
from #curs 

FROM una carpeta

Important: les majúscules afecten!

list
FROM "Readwise/Articles"

FROM una nota (les que VAN a la nota)

list
FROM [[01 📥 Safata d'entrada]]

FROM OUTGOING (les que SURTEN de la nota)

Important: la sintaxi és from outgoing([[la nota]])

list
FROM outgoing([[Curso Git y Github]])

Combinació de tags

AND

list
from #video and #veu 

OR

list
from #humor or #soft

Combinació de carpetes (es pot fer AND o OR)

list
from "Readwise/Articles" or "templater"

Excloure (-)

Nota: es pot usar sintaxi amb parèntesis; aquí no ho faig, però es pot

list
from #curs and -#curs/web

Pots afegir strings

Exemple: que aparegui “Camí: ” i després el file.path

list "Camí: " + file.path + ""
from #obrapedrell  

Es pot enumerar els camps que es vulguin i anar concatenant.

list " Origen: " + "**" + origen + "**" + ", Professor: " + "**" + professor + "**"
from #curs

Task

Les tasques d’un dia concret:

task from [[2022-07-30]]

Where

Els cursos del hashtag curs que no són “Curs Git y Github”:

list from #curs
where file.name != "Curso Git y Github"

Totes les notes modificades durant l’últim dia:

list
where file.mtime >= date(today) - dur(1 day)

list
where titol-dia

---

task
from #diari
where !completed

Table

TABLE titol-dia, podcast-dia
from #diari
where titol-dia

TABLE titol-dia AS "Títol del dia", file.ctime AS "Creat"
from #diari
where titol-dia

Sort

La mateixa d’abans però ordenada per títol alfabèticament:

TABLE titol-dia AS "Títol del dia", file.ctime AS "Creat"
from #diari
where titol-dia
sort titol-dia asc

Flatten

Quan hi ha més d’un camp per fila, separar. flatten authors

Group By

Agrupar per complet i incomplet:

task from [[2022-07-30]]
group by completed

table file.name as "Curs", professor AS "Professor"
from #curs
group by origen

table origen, professor, completat
from #curs
sort completat desc

Habit Tracker

Sleep:: 9 Reading:: 4
Exercise:: 50
Meditation:: 0
Writing:: 4

TABLE WITHOUT ID  
file.link as Date,  
choice(Sleep > 7, "🟩", "🟥") as 🛌,  
choice(Exercise > 30, "🟩", "🟥") as 🏃,  
choice(Reading > 30, "🟩", "🟥") as 📚,  
choice(Meditation > 10, "🟩", "🟥") as 🧘,  
choice(Writing > 750, "🟩", "🟥") as ✍️  
FROM #diari
WHERE file.day <= date(now) AND file.day >= date(now) - dur(7days)  
SORT file.day ASC