Obsidian Dataview queries

Related to:: Obsidian - Obsidian Dataview Examples

We can easily query our Obsidian vault to find precisely what we need and generate views that show our data in simple yet elegant and useful formats.

The formats available are:

  • TABLE - A table with one row per result and multiple columns
  • LIST - A bullet point list with a single piece of information for each result
  • TASK - A list of tasks in a bullet point list
  • CALENDAR - A calendar view with the results shown as a dot on the referred date

Below is the syntax which we need to use to achieve this. If you are familiar with SQL Syntax, you’ll be happy because they are fairly similar.

TABLE | LIST | TASK <field> [AS "Column name"], <field>
FROM <source>
WHERE <expression>
SORT <expression>
GROUP BY <field>

References