Examples

A small collection of simple usages of the dataview query language.

Show all games in the games folder, sorted by rating, with some metadata:

Query

TABLE
  time-played AS "Time Played",
  length AS "Length",
  rating AS "Rating"
FROM "games"
SORT rating DESC

Output

File	Time Played	Length	Rating
Outer Wilds	November 19th - 21st, 2020	15h	9.5
Minecraft	All the time.	2000h	9.5
Pillars of Eternity 2	August - October 2019	100h	9

List games which are MOBAs or CRPGs.

Query

LIST FROM #games/mobas OR #games/crpg

Output

List all tasks in un-completed projects:

Query

TASK FROM "dataview"

Output

List all of the files in the books folder, sorted by the last time you modified the file:

Query

TABLE file.mtime AS "Last Modified"
FROM "books"
SORT file.mtime DESC

Output

List all files which have a date in their title (of the form yyyy-mm-dd), and list them by date order.

Query

LIST file.day WHERE file.day
SORT file.day DESC

Output