Dataview for reviewing and processing media

[arminta]

I use dataview to help me process and organize all of the media that I go through (books, articles, videos, movies, papers, etc). I also use the Readwise tool and plugin to funnel most of what I consume into my vault. Anything I come across that might be interesting gets saved into Pocket and I either highlight in Pocket which sends to Readwise, or highlight with Hypothesis which goes into Readwise.

Here is a shot of my media review page:

Here’s the markdown:

In Progress

table Category, Workflow, file.mtime
from #inprogress or #highlighted or #summarized 
where file.name != "Media" and !contains(file.name, "emplate")
sort file.mtime asc

Ready

table Category, Workflow, Purpose, Source, knowledge-topic as "Knowledge Topic", file.mtime
from #ready or #downloaded and !#setaside
where file.name != "Media" and !contains(file.name, "emplate")
sort file.mtime asc

Need to Get

table Category, Author, Priority, Purpose, elink(URL, "Link") as URL, file.ctime
from #needtoget 
where file.name != "Media" and !contains(file.name, "emplate")
sort file.ctime asc

Finished

table Category, Workflow, Purpose, Rating, knowledge-topic as "Knowledge Topic", Summary
from #finished  
where file.name != "Media" and !contains(file.name, "emplate")
sort file.ctime asc

Set Aside

table Category, Workflow, Purpose, file.ctime
from #setaside 
where file.name != "Media" and !contains(file.name, "emplate")
sort file.ctime asc

---

Here is an example of what an individual page looks like and how I process through some content:

The pages vary slightly depending on the type of content. Videos have an iframe of the video the reference and books have the cover graphic, for example.

[arminta]

Related posts:

Exercise and workout dataview ideas

I’m still redoing a bunch of metadata for my fitness stuff so some of these aren’t completely filled out with examples, but I wanted to post some ideas for using obsidian and dataview to track workouts. [Screen Shot 2021-04-22 at 15.29.48] name Add Workout type note(New Workout) template action Workout Template class dataview-button table Date, Type, set-type, planned-rpe, Sets, Reps, max-hr, Calories from #workouts sort date desc #databases Area:: Fitness [Screen Shot 2021-04-22 at 1…

Dataview task and project examples

Ok, here are some examples of templates and dataviews for task management: [Screen Shot 2021-04-22 at 14.35.12] name Add Task type note(New Task) template action Task Template class dataview-button Available Tasks table Completed, Priority, Project, defer-date as "Defer Date", due-date as "Due Date", recur-length as "Recur Length", defer-date + recur-length as "Next Date" from #tasks where defer-date < date(now) and completed != 1 sort doDate asc Upcoming Tasks table Completed, Priority, P…

Knowledge Management dataview examples

[Screen Shot 2021-04-22 at 15.11.51] name Add Topic type note(New Topic) template action Knowledge Topic Template class dataview-button table importance, file.mtime as Last_Modified__, pillars as Pillars__________________, habitsRoutines as Habits_and_Routines___, courses-and-training from #knowledgeTopic sort file.mtime desc [Screen Shot 2021-04-22 at 14.42.52] #knowledgeTopic Status:: Active Importance:: Goals:: Pillars:: Habits and Routines:: Courses and Training:: Relevant Reso…

Daily and Weekly Reviews + dataview

I’m a big believer in doing periodic reviews. I do reviews each morning, night, week, month, quarter and year. Using dataview I can easily keep track of metadata that I want to review inline in the page and have it roll up into the bigger timeframes. For example I can track the things I want to improve and use dataview to display the previous day’s value to reflect on. I can also track how well I’m completing my habits each day and see the results and average of those values for the week and mo…

[Daniyal-Ahmed]

Arminta, I think it would be great if you gave a Talk on how you customize your workflow in Obsidian to make it minimal and notion-like. If you are not busy.

[davecan]

Once again we seem to have a similar approach at least conceptually, though it differs in several specifics.

For example, instead of having strings as knowledge categories I have topic: [[Note or MOC name]] so incoming content is tied to at least one if not more hub notes or MOCs somewhere in my system.

My front matter is also much shorter. Instead of putting URL/etc in variables like that I pull items into Zotero and then run an Alfred workflow that executes a script to pull the referenced citekey out of Zotero, runs an API call against Zotero to generate the bibliography reference, then puts that at the top of the templated note it creates in my inbox.

Ex:

---
topic: [[✧ Systems Thinking]]
citekey: hosu2019
status: unstarted
---

Hosu, George. A Better Way of Understanding Systems. https://cerebralab.com/A_Better_Way_of_Understanding_Systems. Accessed 5 Apr. 2021.

... (rest of template)

What I had been meaning to do but just hadn’t gotten around to was building a dashboard view of my content inbox. Your post is spurring me to do that and drawing from your examples.

So, thanks again!!

[arminta]

Hi Dave, we’re more similar than you think as my Knowledge Topics are links (not plain strings). Knowledge Topic:: [[Psychology]] is an example. Then here is my Psychology page:

Here’s more about my Knowledge Management part of my workflow:

Knowledge Management dataview examples

[Screen Shot 2021-04-22 at 15.11.51] name Add Topic type note(New Topic) template action Knowledge Topic Template class dataview-button table importance, file.mtime as Last_Modified__, pillars as Pillars__________________, habitsRoutines as Habits_and_Routines___, courses-and-training from #knowledgeTopic sort file.mtime desc [Screen Shot 2021-04-22 at 14.42.52] #knowledgeTopic Status:: Active Importance:: Goals:: Pillars:: Habits and Routines:: Courses and Training:: Relevant Reso…

I will admit my frontmatter/dataview fields are not short lol. But I link everything together in my vault in one way or another via dataview so it’s worth it to me. It could be hidden under a header if someone wanted to (I like to see it).

[gasofin44]

Thank you for sharing. I was searching something for listing in a note my books and articles depend on the status. But I think I’m a super beginner in obsidian (just making my first notes after watching some YouTube tutorials). Do you know if I can learn dataview, the very first steps, just from the scratch?

[ocWavean]

Hey! Loving these views!

Was wondering if it’s possible to pull all frontmatter variables from a certain date? For instance, can I see all new variables for a file created within the last 30 days?

[debora]

How did you leave the Knowledge Topic as a list?

[Outis]

It’s a dataview thing. Multiple [[keywords]].