Quick note to whom it may concern: Dataview didn't pick up his dates as date types but as strings. So when sorting by date, dataview sorted them alphabetically (Aug, Feb, Jan, Jun, May). To make sure dates are sorted correctly use ISO formating (YYYY-mm-DD). (Although I think Dataview understand other numerical date formats as well and reads them as date type automatically.)
been sifting through peoples blogs for a day or two trying to troubleshoot while i learn dataview and this is the video that properly answered my questions. thanks!
Extremely helpful, I know nothing about coding or YAML and have been struggling to wrap my head around Dataview. Thanks for taking the time to make this!
Thanks for the helpful tutorial. I will watch it a second time because of its high information density. It's a good introduction to the use of Dataview in Obsidian.
When using template, you instead of having to change the authors name in the query, try to put {{title}} in between your "" and it will automatically pull the file title and put it there.
I had to come back to this video when I started my own book vaulting. Your Dataview WHERE line for the Author template around the 14 minute mark I added... WHERE contains(author, "") So that once you create a new author, you just hit he hotkey to replace with Tempalter, and it will autopopulate the filename which you should have as the author. Someone probably already posted that somewhere, but I just wanted to share. Thanks for the informative videos, as always.
Thank you very much, Sergio! Great job! I just started learning Obsidian a few days ago, and your video is just what I was looking for! I will definitely spend some time reviewing it again in detail, and check your other videos!
Thanks! I'm new to Obsidian and found your channel. As an IT professional this is just what I was looking for. You even demo'd the query for notes with no tags, which is something I was wondering how to do. 😊
Thank you for spending time making this helpful video. I am trying to learn DataView and I learn a lot from this video. Will keep reviewing this. Appreciate.
@fromsergio I am new to Obsidean, I am still using Notion but decided to try Obsidean...I tried a number of YT training materials and then landed on yours and I have to thank you as yours have been by far the best for me in comparison, I like your style, simple, clear, and to the point, great job and huge thank you!... enjoy the coffee 🙂
Well structured explanation. Starts at the beginning with probably the best plain speak explanation of Dataview I have seen. Go as long as needed - prefer deep, methodical Obsidian content like this.
Great content and clear explanation which allows immediate application of what was taught and demoed. I share your view of task managers and have used and still use Todoist as my task manager for years and added the Todoist plugin to my vault. Thank you for this video.
@@FromSergio OK. I might ask a bit of advice. In the code below, I’m trying to to use dataview to produce a table of all records in a sub folder. I get nothing returned. ```dataview TABLE title AS "Title" FROM "Aviation/Airports/NZ-NewZeaLand" SORT title ASC ``` But if I use #tags it works
Hi Anton, your comment ended up in spam, and was held for review, unsure why youtube thought it was spam. Anyway you've probably figured it out by now but that has to do with your directory not being labeled correctly, could be something as simple as a capital letter or a wrong spacing. I'm referring to the FROM section. Just need to make sure Aviation/Airports/NZ-NewZeaLand exists just like you typed it out. Hopefully this helps!
With the "Metadata Menu" plugin you can create your own menus to incerte YAML or Field:: data automatically. This plug in give you a lot of options to edit your metadata. You could easily set it up to select the rating for your books without needing to create commands.
I made just one template for the stars. 5 full stars followed by 5 empty stars. Always insert 10 stars and take half a second to delete the ones you don't want. Uses up fewer hotkeys. :)
Excellent video, this will surely help me a lot! I already know SQL, so it is a breeze to query notes like this and creating my own metadata. The documentation on DQL (Dataview Query Language) is well organized, so I might indeed replace notion for this
Great video thanks! Have you had time to make the vault maintenance video? I'd be really interested in this to help build strong Obsidian habits! Thanks!
Good stuff. Thanks. BTW - I know lots of people like dark mode while working at their computer but it can sometimes make viewing a video difficult. I had to maximize the resolution to see everything clearer, especially the red text in the metadata - and even then it was kind of fuzzy. Maybe it is my old eyes.
Thanks Ken, I 100% understand. In my latest videos I have fixed this issue by increasing the resolution of my screen even further and zooming in even closer. :)
TNice tutorials was an amazing video! you really Nice tutorialt all the key points for the basics without ever over complicating anytNice tutorialng. A hard job and you did
I have been using the minimal theme for many months now and i believe it's the theme that you can easily customize to your needs (it's also the most popular theme for a reason!) especially since it has a companion plugin.
I watch all of your episode and my Obsidian skill improve real fast. May I ask where did you learn all of these? from official document? the question arise when specific WHERE with file.name, how do I know that specific syntax
There is a Todoist plugin that renders your tasks within Obsidian, and you can apply filters as necessary. You can use quick capture for Todoist (CTRL+Cmd+A) or use Raycast, and the flow works perfectly.
@@FromSergio de nada! Eu também uso o Todoist separadamente, mas achei interessante falar sobre o plugin. Tens um novo suscritor (sou espanhol vivendo em Portugal). Feliz Natal. :)
i don't really know when i started watching this video Maybe 2/3h ago idk anymore, i guess learning qwerty at the same time wasnt the smartest move of my life BUT the only thing i know is that my head hurt, that i discovered a whole new world and that i finally understand why i struggled that much to orgranize my vaults My head is about to explode but at least i took notes OF EVERYTHING and made sure to create personal examples out of it to understand it to the best of my ability, at 19:20 something you asked if this video was useful As someone that never used stuff like that before i can tell you that YES it was, now im kinda thinking about how im gonna reorganize all the shit i already have in my vault but i guess ill make it can wait and keep on moving forward and deal with them if i come across them Almost forgot: THANKS a lot :D
That's amazing! I'm glad I was able to help so much in your journey! The personal examples part tells me you're an experienced learner and I'm sure you'll pick all of this up in no time!
@@FromSergio i gotta say "thanks" to my ADHD for that 😂 if I don't do it that way ain't no way I remember a single word That's also why i love obsidian so much ... And the new found potential motivate me even more to learn because I'm less afraid of organization thanks to you 🙏 I've been digging your entire playlist, and like mentioned before your content is top tier, you manage to explain complex stuff in a way that make sense and that shows that you really know what you are talking about so again thanks for the hard work 🙏
Learning so much from you. Also just realized all my imported Kindle "metadata" doesn't show up on tables. Wondering do I have to retype the metadata on each of those imported notes, to get them to show up, or is there something easier I'm missing?
Great video. Question please... I noticed that you can search with [Command] + [F] on your Mac and find strings on the rendered results of LIST. I cannot do that, neither LIST nor TABLE. I wonder if you could tell me what the trick is. Thanks!
On a British keyboard, use the key in the top left (it also has ¬ and the pipe symbol on it) and sits to the immediate left of the 1 key to get `. It is not the key with the @ symbol, which will give you ' instead.
📚 *Dataview Overview - 🔑 Automates note management in Obsidian. - ⚙️ Two key parts: metadata and querying. 📝 Output Formats - 📋 Three types: table, list, task. 🔍 Queries - 🔄 Use `FROM` to specify note sources. - 📏 `WHERE` filters based on criteria. - 🔢 `SORT` organizes results. 📖 Use Cases - 🔖 Book tracking with star ratings. - 📂 Vault maintenance via empty note checks. 💡 Extra Tips - 📅 Use natural language dates for efficiency. - 🔑 Templater plugin for rating shortcuts. 🔗 Resources* - 📄 Official documentation and related links provided.
1) Is there a way to copy the result of a Dataview query from obsidian and paste it into Notepad/MS Word/Excel etc. Any plugin which can help us in doing this? 2) If i have text in obsidian with formatting like [[ ]], bold etc.., how can i copy the text without formatting/[[]] and paste it into notepad/MS Word as plain text? Thanks in advance for your help.
Thank you for these very relevant videos. Very useful. For some reason nothing displays for me in Data view. Not sure what I am doing wrong? Thank you!
@@FromSergio No big deal. Many make videos about Obsidian but you're best in my opinion as a new user. Clean, informative and focused. I hope you're still coming with more contents in the future.
Your videos are really amazing. I have a question, can we replace dataview plugin with notion database formula feature. If I want my personal finance setup in obsidian can I do that? Is it possible anyhow in obsidian to make our database and also able to calculate just like notion. I was using notion for tracking my finances such as budgeting, income and expenses. So there when I put value of any field it then automatically include that new value in previous calculations and generate new calculations by formula setup. So, what I looking for in obsidian, if i put my expenses or income in daily note so it automatically add to the previous calculation and generate a new calculation in a seperate finance dashboad(that we create for tracking finances). Personal finance is just an example but I am looking for such kind of stuff.
@@krackr8089 Yeah i know that but I gave it as an example. I am looking for this kind of possibitlity in dataview. That's why I asked. Because there is lot more thing to calculate in dynamic way.
This went live this week- github.com/RafaelGB/obsidian-db-folder Not sure if it fits exactly what you are looking for as I haven't had the time to test this out. Keep me posted!
Is there a way to pull up previous days daily note tasks automatically in today's daily note with data view? You can add a date range in data view, but I want it to be added automatically 🤔
I think I've seen this be doable - Danny Hatcher shows daily notes with automatic links to yesterday and tomorrow - and you could presumably embed yesterday's note if you want it right there, or look at doing it in another pane or tab. Caveat: embedding it might result in each day containing all the previous days 🤔
If it's possible, would love to see a video for newbies showing dataview(js) queries that list and sort current, overdue, and upcoming tasks - not at the metadata level but tasks within an Obsidian note.
Thank you for this video, it gives me many ideas how to make Obsidian to me. On that note: is there a way to query paragraphs across notes that include a specific # and collate them?
Thanks Mathieu! You can do that with markdown syntax, I made a video focused on markdown syntax and that’s also covered! Unless of course you mean querying a paragraph or header across 2 or more notes using dataview, I’m not sure if that’s possible :/
Anyway we can pull data from within a note without the actual file name itself? In addition, distilling that list to a distinct list? For example, if I want a distinct list of all the authors found within the Books folder, meaning each author only shows up only once.
@@FromSergio Yep that worked! I'm using PARA so I have my books in a folder "4 Resources/Book Database". I had to update your logic to fit that and it worked like a charm. Still figuring this thing out. I know SQL because of work and am slowly getting used to the dataview language. I love it! Another way for me to nerd out 😂😂😂
Not sure I really understand the difference between "FROM" and "WHERE" (from what I remember when I did some SQL, FROM was just to select the database and WHERE to filter but now it seems you filter using both of them... Can anybody enlighten me ?
Great video! Best explanation I’ve seen. Super helpful. What’s best practice? Should the authors values in the YAML in quotation marks? Thanks for your great channel. Subscribed.
Thanks for that :) Much like everything remotely programming related, there's multiple ways of achieving the same result. You can use quotation marks but you don't have to. Certain themes have a different color for yaml headers with quotation marks so if that's something you enjoy there's no reason not to use them!
I get that you're showing that you can set many hotkeys up with templater, but personally, if I were to create a shortcut for ratings, I'd only do 4-stars and copy/paste/delete as needed.
Thanks for a great video!. I have an improvement suggestion. The text you type is very small and looks blurry, even when playing HD a laptop. It's completely unusable on a mobile device. Why not make your text fill entire screen?
Hi. I watched your video that was helpful but I have a question What should I do for showing tags, Reference, ... etc of a file inside of itself, for examle I have a Yaml header and I want to show a table below it that contains its Yaml header information. Some code like this ? ```dataview TABLE Tags, References, Status FROM this.file.name ```
Hi Amir it appears youtube flagged your comment to spam (probably because of the dataview query) so I hadn't seen it yet. The query you entered would work. You could also add Table tags, references etc. There's an easier way to display the yaml of a certain file which would be using templater. I just made a video on templater, make sure to watch that and once you're done head over to the template documentation in the link and see tp.frontmatter.
I've got my vault open and am following along with this video. When I go into preview mode, it locks up Obsidian and it takes a while to show the table. Any reason you think this would take so long?
It does not create actual links, it simply lists them. A dataview table/list would not be, in my opinion, the best way to go about a MOC for me personally, but if it works for you it works!
@@FromSergio thanks for your response, i just thought that creating and updating and changing the structure of moc's takes time so i could use dataview to automate that, now i know it's just a dynamic view
I don't use nested tags personally but querying emojis is not a problem on dataview. A simple LIST from #[emoji] would do it. As for querying nested tags you can apply the same logic. LIST from #[emoji]/[emoji]
Helpful. So very comprehensive. Thanks so much! Gives a whole Iot of ideas. I could not get it to list out tasks which were preceded by a number bullet. Eg. 1. [ ] TASK 1 It wouldn't show this task in the results. What am I missing here. Once again, thanks!
hummmm so.... you just show us how to query using Dataveiw but you didn't show us what you need to do in your notes to have it populate in Dataview. For example, between 3:12~4:30 where do we specify on our notes "Author" or "Genre" header? Also can we have pagination and result limits to our query results? So the table doesn't have to be this long... Thanks though
"where do we specify on our notes "Author" or "Genre" header?" You use YAML so on top of your file (Search his video titled: YAML in Obsidian - A Prerequisite For Dataview), here's an example: --- Author: J. K. Rowling Genre: Fantasy tag: Books --- About the pagination, I don't if dataview could do that or not, still learning, I'll edit my comment if I find a way
Great content but yes sorry there is a but. before recording your screen you should change resolution or some other setting. It's hard to read your screen.
@@FromSergio No, no. Resolution doesn't help with the visibility of a low contrast background. Maybe you have younger eyes than I do, but I have stopped watching this video for this reason. Your preferred template for daily use isn't always going to be the best template for making a video.
I think I agree, the text could be larger, there is wasted space on the wide of the notes and the dark red ' ```dataview ' is hard to read on the black background.
Thanks, did you try watching them in 4k? Also, if you check my latest video (templater) is it also blurry to you? Thanks for letting me know, I can't change what's already uploaded but can always do better in upcoming ones!
@@FromSergio Thanks for the message. I found the issue-for some reason, my TH-cam keeps setting playback quality to a very low setting. I'm not sure why this is happening, but after changing to 4K, your video looks fine. Thanks again!
Subscribe to my monthly newsletter: fromsergio.substack.com
This is the most straightforward and easy-to-understand explanation of dataview! Awesome job as always!🎉
Awesome, thanks a lot! Glad it was helpful!
that was the easiest ? are you telling me that i struggled so much on the easiest video ?
@@kannonfps I believe its a complicated subject
lots of people using it are already programmers
Quick note to whom it may concern: Dataview didn't pick up his dates as date types but as strings. So when sorting by date, dataview sorted them alphabetically (Aug, Feb, Jan, Jun, May). To make sure dates are sorted correctly use ISO formating (YYYY-mm-DD). (Although I think Dataview understand other numerical date formats as well and reads them as date type automatically.)
Nice tip. thanks
been sifting through peoples blogs for a day or two trying to troubleshoot while i learn dataview and this is the video that properly answered my questions. thanks!
Glad it helped! :)
Best explanation of Dataview I’ve seen - so helpful, thanks so much!
Thanks for watching :)
Extremely helpful, I know nothing about coding or YAML and have been struggling to wrap my head around Dataview. Thanks for taking the time to make this!
Thanks for the helpful tutorial. I will watch it a second time because of its high information density. It's a good introduction to the use of Dataview in Obsidian.
Glad it was helpful! :)
When using template, you instead of having to change the authors name in the query, try to put {{title}} in between your "" and it will automatically pull the file title and put it there.
I had to come back to this video when I started my own book vaulting. Your Dataview WHERE line for the Author template around the 14 minute mark I added...
WHERE contains(author, "")
So that once you create a new author, you just hit he hotkey to replace with Tempalter, and it will autopopulate the filename which you should have as the author.
Someone probably already posted that somewhere, but I just wanted to share.
Thanks for the informative videos, as always.
Great video thanks for sharing. I was intimidated by Dataview at first but you make it sound so easy.
Absolutely, glad it was helpful!
@@FromSergioI'm having a hell of time trying to get this to work
I'm gonna have to watch this video a couple times more to be able to use this plugin, but I finally begin to undersand it.
It takes some time to get used to it for sure :)
Right?!
Incredibly straightforward resource. Thanks!
Thanks Riley :)
Thank you very much, Sergio! Great job! I just started learning Obsidian a few days ago, and your video is just what I was looking for! I will definitely spend some time reviewing it again in detail, and check your other videos!
Thanks Yuriy, very kind of you! I appreciate it!
Thanks! I'm new to Obsidian and found your channel. As an IT professional this is just what I was looking for. You even demo'd the query for notes with no tags, which is something I was wondering how to do. 😊
Thank you for spending time making this helpful video. I am trying to learn DataView and I learn a lot from this video. Will keep reviewing this. Appreciate.
Glad it was useful! :)
Happy to see that there are other people interested both in philosophy and programming 😅
Very helpful video. Here before your channel blows up been watching all your videos
Appreciate the kind words! Hard to imagine a niche as specific as this blowing up but you never know! :)
@fromsergio I am new to Obsidean, I am still using Notion but decided to try Obsidean...I tried a number of YT training materials and then landed on yours and I have to thank you as yours have been by far the best for me in comparison, I like your style, simple, clear, and to the point, great job and huge thank you!... enjoy the coffee 🙂
Thanks for the coffee! :) Thanks for letting me know, I'm glad you enjoy my content!
Absolutely the best video on Dataview so far. Keep up the awesome content!
Thanks Joseph! Glad you enjoyed it, have a great one!
Well structured explanation. Starts at the beginning with probably the best plain speak explanation of Dataview I have seen. Go as long as needed - prefer deep, methodical Obsidian content like this.
Thanks Ryan, truly appreciated :)
Especially considering the number of channels going twice as long and still not getting the message across... 🤭
Thanks very much! New to Obsidian, but loving it, and loving the community resources like this video. So helpful!
Great content and clear explanation which allows immediate application of what was taught and demoed. I share your view of task managers and have used and still use Todoist as my task manager for years and added the Todoist plugin to my vault. Thank you for this video.
Thanks! We are most definitely in the minority but yes todoist is irreplaceable as a task manager in my view as well!
That was great, Sergio! Keep up the good work!
Thanks! uploading the first dataview workflow this week, hope you guys enjoy!
The best intro and easiest to understand.
Thanks Sergio. Very helpful. You have a good way of presenting you videos and a great understanding of Obsidian
Thanks Anton, much appreciated!
@@FromSergio OK. I might ask a bit of advice. In the code below, I’m trying to to use dataview to produce a table of all records in a sub folder. I get nothing returned.
```dataview
TABLE
title AS "Title"
FROM "Aviation/Airports/NZ-NewZeaLand"
SORT title ASC
```
But if I use #tags it works
Hi Anton, your comment ended up in spam, and was held for review, unsure why youtube thought it was spam. Anyway you've probably figured it out by now but that has to do with your directory not being labeled correctly, could be something as simple as a capital letter or a wrong spacing. I'm referring to the FROM section. Just need to make sure Aviation/Airports/NZ-NewZeaLand exists just like you typed it out. Hopefully this helps!
Venerable Sergio I bow to thee! 3 Gentle requests 1) Increase resolution font size, for old tired eyes;
Hi Sanjay, you're very right. I have since fixed this issue and increased the resolution, wish I had done it sooner!
Very helpful and informative, like all of the rest of your videos.
Especially at this time for me, it's just what I needed!
Thank you, good job !
Thanks Tomer, glad you enjoyed it!
Thanks. All the videos I've seen are absolutely brilliant. I learned a lot of things. Some are particularly complex but that's how we progress.
With the "Metadata Menu" plugin you can create your own menus to incerte YAML or Field:: data automatically. This plug in give you a lot of options to edit your metadata. You could easily set it up to select the rating for your books without needing to create commands.
Neat, thanks!
This was really good because you started at square zero. Thanks for what you do.
Thanks for the kind words Dave! Have a great weekend!
I made just one template for the stars. 5 full stars followed by 5 empty stars. Always insert 10 stars and take half a second to delete the ones you don't want. Uses up fewer hotkeys. :)
Excellent video, this will surely help me a lot! I already know SQL, so it is a breeze to query notes like this and creating my own metadata. The documentation on DQL (Dataview Query Language) is well organized, so I might indeed replace notion for this
Yeah if you know SQL DQL is a walk in the park! :)
Great video thanks! Have you had time to make the vault maintenance video? I'd be really interested in this to help build strong Obsidian habits! Thanks!
thanks bro regards from Syria
Thanks! :)
Wow, this video is amazing, liked and subscribed. Thank you for sharing and teaching.
Thanks! Glad you liked it :)
Based on this video, I'm becoming a subscriber!
I’m glad! :)
Good stuff. Thanks. BTW - I know lots of people like dark mode while working at their computer but it can sometimes make viewing a video difficult. I had to maximize the resolution to see everything clearer, especially the red text in the metadata - and even then it was kind of fuzzy. Maybe it is my old eyes.
Thanks Ken, I 100% understand. In my latest videos I have fixed this issue by increasing the resolution of my screen even further and zooming in even closer. :)
TNice tutorials was an amazing video! you really Nice tutorialt all the key points for the basics without ever over complicating anytNice tutorialng. A hard job and you did
Glad it was helpful!
Thank you for your tips about Obsidian, very helpful!
Hi, was away all of last week. Glad they were helpful :)
3) Please suggest an effective light mode theme, for old fashioned folks. Staaaaay Blessed!
I have been using the minimal theme for many months now and i believe it's the theme that you can easily customize to your needs (it's also the most popular theme for a reason!) especially since it has a companion plugin.
Your videos helped me so much, you have a great way of explaining things. Thank you so much for your contribution!
I'm glad I could help! I appreciate the encouragement! I do my best :)
Very helpful, thaks for your work 👍
Glad it was helpful! :)
Wonderful, thank you very much!
glad you enjoyed it!
Thanks!
Thanks for the generosity! Much appreciated :)
Thank you so much. This video helps me a lot.
Thanks Jose!
I watch all of your episode and my Obsidian skill improve real fast. May I ask where did you learn all of these? from official document? the question arise when specific WHERE with file.name, how do I know that specific syntax
TH-cam flagged your comment so I only found it now. Yeah its all in the documentation
There is a Todoist plugin that renders your tasks within Obsidian, and you can apply filters as necessary. You can use quick capture for Todoist (CTRL+Cmd+A) or use Raycast, and the flow works perfectly.
Thanks for sharing. I like to use todoist separately. I also have a video on it if you'd like to check it out!
@@FromSergio de nada! Eu também uso o Todoist separadamente, mas achei interessante falar sobre o plugin. Tens um novo suscritor (sou espanhol vivendo em Portugal). Feliz Natal. :)
@@1b0o0 Que bom! Feliz Natal/Navidad :)
Great videos, Sergio! 👍
Thanks! :)
i don't really know when i started watching this video Maybe 2/3h ago idk anymore, i guess learning qwerty at the same time wasnt the smartest move of my life BUT the only thing i know is that my head hurt, that i discovered a whole new world and that i finally understand why i struggled that much to orgranize my vaults
My head is about to explode but at least i took notes OF EVERYTHING and made sure to create personal examples out of it to understand it to the best of my ability, at 19:20 something you asked if this video was useful
As someone that never used stuff like that before i can tell you that YES it was, now im kinda thinking about how im gonna reorganize all the shit i already have in my vault but i guess ill make it can wait and keep on moving forward and deal with them if i come across them
Almost forgot: THANKS a lot :D
That's amazing! I'm glad I was able to help so much in your journey! The personal examples part tells me you're an experienced learner and I'm sure you'll pick all of this up in no time!
@@FromSergio i gotta say "thanks" to my ADHD for that 😂 if I don't do it that way ain't no way I remember a single word
That's also why i love obsidian so much ... And the new found potential motivate me even more to learn because I'm less afraid of organization thanks to you 🙏
I've been digging your entire playlist, and like mentioned before your content is top tier, you manage to explain complex stuff in a way that make sense and that shows that you really know what you are talking about so again thanks for the hard work 🙏
Can you also query inline information which are in an inline table? So that I can only query information from an inline table that is in one note.
Thanks for your sharing, it is brilliant!
Learning so much from you. Also just realized all my imported Kindle "metadata" doesn't show up on tables. Wondering do I have to retype the metadata on each of those imported notes, to get them to show up, or is there something easier I'm missing?
Great video. Question please... I noticed that you can search with [Command] + [F] on your Mac and find strings on the rendered results of LIST. I cannot do that, neither LIST nor TABLE. I wonder if you could tell me what the trick is. Thanks!
On a British keyboard, use the key in the top left (it also has ¬ and the pipe symbol on it) and sits to the immediate left of the 1 key to get `. It is not the key with the @ symbol, which will give you ' instead.
Great as always! Thanks
Very useful viedo. Thank you.
Glad you enjoyed it!
With the tag looking at author, since Kindle Sync now make "Author" a sub header, how would you get to that?
I typed
```dataview
LIST
```
and it stated "Dataview: No results to show for list query"
WHY?😭
📚 *Dataview Overview
- 🔑 Automates note management in Obsidian.
- ⚙️ Two key parts: metadata and querying.
📝 Output Formats
- 📋 Three types: table, list, task.
🔍 Queries
- 🔄 Use `FROM` to specify note sources.
- 📏 `WHERE` filters based on criteria.
- 🔢 `SORT` organizes results.
📖 Use Cases
- 🔖 Book tracking with star ratings.
- 📂 Vault maintenance via empty note checks.
💡 Extra Tips
- 📅 Use natural language dates for efficiency.
- 🔑 Templater plugin for rating shortcuts.
🔗 Resources*
- 📄 Official documentation and related links provided.
1) Is there a way to copy the result of a Dataview query from obsidian and paste it into Notepad/MS Word/Excel etc. Any plugin which can help us in doing this?
2) If i have text in obsidian with formatting like [[ ]], bold etc.., how can i copy the text without formatting/[[]] and paste it into notepad/MS Word as plain text?
Thanks in advance for your help.
Thank you for these very relevant videos. Very useful. For some reason nothing displays for me in Data view. Not sure what I am doing wrong? Thank you!
Thank you for your excellent series of videos. One question, how do you remove rows if the result of a single cell is empty?
Not done easily and really not worth the effort in my opinion!
Thanks, finally I can understand
Very helpful. Thank you. Already liked & subscribed but still want to show my appreciation.
Thanks for the kind words :) Appreciate it!
@@FromSergio No big deal. Many make videos about Obsidian but you're best in my opinion as a new user. Clean, informative and focused. I hope you're still coming with more contents in the future.
Your videos are really amazing. I have a question, can we replace dataview plugin with notion database formula feature. If I want my personal finance setup in obsidian can I do that?
Is it possible anyhow in obsidian to make our database and also able to calculate just like notion. I was using notion for tracking my finances such as budgeting, income and expenses. So there when I put value of any field it then automatically include that new value in previous calculations and generate new calculations by formula setup.
So, what I looking for in obsidian, if i put my expenses or income in daily note so it automatically add to the previous calculation and generate a new calculation in a seperate finance dashboad(that we create for tracking finances).
Personal finance is just an example but I am looking for such kind of stuff.
Theres a ledger plugin. Just search for it. The dashboard feature doesn't work on an Android though. But give it a try.
@@krackr8089 Yeah i know that but I gave it as an example. I am looking for this kind of possibitlity in dataview. That's why I asked. Because there is lot more thing to calculate in dynamic way.
This went live this week- github.com/RafaelGB/obsidian-db-folder
Not sure if it fits exactly what you are looking for as I haven't had the time to test this out. Keep me posted!
@@FromSergio thanks
Is there a way to pull up previous days daily note tasks automatically in today's daily note with data view?
You can add a date range in data view, but I want it to be added automatically 🤔
I'd probbaly use templater for that use case!
@@FromSergio Ok, I've heard about it, will check it out. Thanks!
I think I've seen this be doable - Danny Hatcher shows daily notes with automatic links to yesterday and tomorrow - and you could presumably embed yesterday's note if you want it right there, or look at doing it in another pane or tab. Caveat: embedding it might result in each day containing all the previous days 🤔
@@bc4198 Thanks, I'll check it out!
Thank you, you’re amazing
That's very kind Ryan thank you!
If it's possible, would love to see a video for newbies showing dataview(js) queries that list and sort current, overdue, and upcoming tasks - not at the metadata level but tasks within an Obsidian note.
Hi Benjamin, Sorry I just got back to you, was on break :) thanks for letting me know!
shadow fight how do you open the channel rack?
Thank you for this video, it gives me many ideas how to make Obsidian to me.
On that note: is there a way to query paragraphs across notes that include a specific # and collate them?
Thanks Mathieu! You can do that with markdown syntax, I made a video focused on markdown syntax and that’s also covered! Unless of course you mean querying a paragraph or header across 2 or more notes using dataview, I’m not sure if that’s possible :/
Great tutorial🎉 but can you create a Table for each author? So like each author is in each row and have certain amount of notes
Yes absolutely
Anyway we can pull data from within a note without the actual file name itself? In addition, distilling that list to a distinct list?
For example, if I want a distinct list of all the authors found within the Books folder, meaning each author only shows up only once.
Try this:
```dataview
TABLE WITHOUT ID author
FROM "books"
GROUP BY author
FLATTEN author
```
@@FromSergio Yep that worked! I'm using PARA so I have my books in a folder "4 Resources/Book Database". I had to update your logic to fit that and it worked like a charm. Still figuring this thing out. I know SQL because of work and am slowly getting used to the dataview language. I love it! Another way for me to nerd out 😂😂😂
Not sure I really understand the difference between "FROM" and "WHERE" (from what I remember when I did some SQL, FROM was just to select the database and WHERE to filter but now it seems you filter using both of them... Can anybody enlighten me ?
Great video! Best explanation I’ve seen. Super helpful. What’s best practice? Should the authors values in the YAML in quotation marks? Thanks for your great channel. Subscribed.
Thanks for that :) Much like everything remotely programming related, there's multiple ways of achieving the same result. You can use quotation marks but you don't have to. Certain themes have a different color for yaml headers with quotation marks so if that's something you enjoy there's no reason not to use them!
@@FromSergio thanks!!! Looking forward to your Templater video!
I get that you're showing that you can set many hotkeys up with templater, but personally, if I were to create a shortcut for ratings, I'd only do 4-stars and copy/paste/delete as needed.
Thanks for a great video!. I have an improvement suggestion. The text you type is very small and looks blurry, even when playing HD a laptop. It's completely unusable on a mobile device. Why not make your text fill entire screen?
I have since improved on that aspect!
nice tutorial. and nice arms!
lol Thanks Alex!
Hi. I watched your video that was helpful but I have a question What should I do for showing tags, Reference, ... etc of a file inside of itself, for examle I have a Yaml header and I want to show a table below it that contains its Yaml header information.
Some code like this ?
```dataview
TABLE Tags, References, Status
FROM this.file.name
```
Hi Amir it appears youtube flagged your comment to spam (probably because of the dataview query) so I hadn't seen it yet.
The query you entered would work. You could also add Table tags, references etc.
There's an easier way to display the yaml of a certain file which would be using templater. I just made a video on templater, make sure to watch that and once you're done head over to the template documentation in the link and see tp.frontmatter.
I've got my vault open and am following along with this video. When I go into preview mode, it locks up Obsidian and it takes a while to show the table. Any reason you think this would take so long?
Unsure, make sure everything is updated, both obsidian itself and the plugins.
@@FromSergio We're good to go. Thanks for your help and for your quick replies. I'm loving your content!
how do you say not from a certain folder? -"folder" isn't working
does dataview list creates actual links that would be visible on the graph? can i use dataview list to create map of content?
It does not create actual links, it simply lists them. A dataview table/list would not be, in my opinion, the best way to go about a MOC for me personally, but if it works for you it works!
@@FromSergio thanks for your response, i just thought that creating and updating and changing the structure of moc's takes time so i could use dataview to automate that, now i know it's just a dynamic view
It does for me as at 2024-04-28!
How to query nested tags?
I have tag system like #📚/📝/🌱
For my evergreen notes
So how to query only those notes who has this tag #📚/📝/🌱
I don't use nested tags personally but querying emojis is not a problem on dataview. A simple LIST from #[emoji] would do it. As for querying nested tags you can apply the same logic. LIST from #[emoji]/[emoji]
Helpful. So very comprehensive. Thanks so much! Gives a whole Iot of ideas.
I could not get it to list out tasks which were preceded by a number bullet.
Eg.
1. [ ] TASK 1
It wouldn't show this task in the results. What am I missing here. Once again, thanks!
Assuming you have tasks somewhere in your vault (CMD or CTRL +Enter) when you input
```dataview
TASK
```
Should return all tasks inside your vault
hummmm so.... you just show us how to query using Dataveiw but you didn't show us what you need to do in your notes to have it populate in Dataview. For example, between 3:12~4:30 where do we specify on our notes "Author" or "Genre" header? Also can we have pagination and result limits to our query results? So the table doesn't have to be this long... Thanks though
"where do we specify on our notes "Author" or "Genre" header?"
You use YAML so on top of your file (Search his video titled: YAML in Obsidian - A Prerequisite For Dataview), here's an example:
---
Author: J. K. Rowling
Genre: Fantasy
tag: Books
---
About the pagination, I don't if dataview could do that or not, still learning, I'll edit my comment if I find a way
Watch the YAML vid of his, he says this is a prerequisite!
it makes is as a quote in my vault
Thank you!
thanks a lot sir
Great content but yes sorry there is a but. before recording your screen you should change resolution or some other setting. It's hard to read your screen.
Make sure to watch at higher resolutions. I record in 4k precisely so this is not an issue.1080/1440p should be enough but 4k for extra clarity.
@@FromSergio No, no. Resolution doesn't help with the visibility of a low contrast background. Maybe you have younger eyes than I do, but I have stopped watching this video for this reason. Your preferred template for daily use isn't always going to be the best template for making a video.
@@FromSergio its about fontsize
I think I agree, the text could be larger, there is wasted space on the wide of the notes and the dark red ' ```dataview ' is hard to read on the black background.
Very helpful
my dumb self was sorting things out manually 2 weeks ago before I discovered this mighty plugin😭😡
Great content, but all of your videos are a bit blurry. Anyone else having this issue? I do not encounter this on other TH-cam videos.
Thanks, did you try watching them in 4k? Also, if you check my latest video (templater) is it also blurry to you? Thanks for letting me know, I can't change what's already uploaded but can always do better in upcoming ones!
@@FromSergio Thanks for the message. I found the issue-for some reason, my TH-cam keeps setting playback quality to a very low setting. I'm not sure why this is happening, but after changing to 4K, your video looks fine.
Thanks again!
Génial❤
Thank you...
Tell us how it been!!
I've found easier to add 5 stars to the template, and erase those I don't want, than create 5 more shortcuts to do it.
endorsent of the second option but it does exist.
Let's go!
That was my fastest comment yet! Hope you enjoy the video :)
@@FromSergio very interesting video. As my Vault populates dataview will become very handy.
Thanks for sharing!
Once you get used to dataview it feels native to obsidian and not a third party plugin!
2) SLOW down, for aged minds and ....
This is a problem I'm actively working on. It's surprisingly difficult to fix :/
I watched this whole video for the information about the stars. 🤣 Does anyone know if there's a half-star symbol available?
sa