Dataview Queries & Tricks

Up: § My note taking system

Some of the ways of utilizing Dataview within Obsidian for useful queries:

Basic query for a new category

table without id
	file.link as Note
where
	contains(category, link(this.file.link))

Query to show Feedback Log for a team member

table without id
	file.link as Note,
	feedback_date as Date,
	feedback_type as Type,
	url as Link
where
	contains(category, link("Feedback Logs")) and
	contains(team_member, this.file.link)
sort feedback_date desc

Query to show Reflections for a team member

table without id
	file.link as Note,
	date(date) as Date
where
  contains(category, link("Buffer Reflections")) and
	contains(team_member, this.file.link)
sort date desc

Query to show Meetings for a team member

table without id
	file.link as Note,
	attendees as Attendees,
	meeting_type as Type,
	meeting_summary as Summary,
	date(meeting_date) as Date,
	file.link as Note
where
  contains(category,link("Meetings")) and
  !contains(file.name,"Template") and
  contains(attendees,this.file.link)
sort meeting_date desc

Excluding a property from items, without removing items completely

Example from Books category note:

table without id
	file.link as Book,
	filter(row.category, (c) => c != link("Books")) as Category
where
  contains(category,this.file.link) and
  !contains(file.name,"Template")
sort file.name asc