Hello guys! Thank you for checking out my thread. I appreciate it.
I’m trying to create a book tracker. Here’s my book directory structure:
. ├── Nudge.md ├── The Cancer Code.md └── Why Buddhism Is True.md
For each markdown file, the structure is the same. Examples:
--- title: "Why Buddhism Is True" author: [[Robert Wright]] --- ### chapter:: 1 Taking the red pill status:: read started:: 2022-04-05 finished:: 2022-04-06 ### chapter:: 2 Paradoxes of meditation status:: reading started:: 2022-05-11 finished::
--- title: "The Cancer Code" author: [[Jason Fung]] --- ### chapter:: 1 Trench Warfare status:: read started:: 2022-02-10 finished:: 2022-03-20 ### chapter:: 2 The History of Cancer status:: reading started:: 2022-05-11 finished::
Then for my “MOC Books”, I’m trying to query chapters of books I’m currently reading.
So given the structure and examples above, the result would be the following:
This is because both of them contain
The following is the rough dataview structure that I could think of:
TABLE WITHOUT ID file.link as Book, chapter AS "Chapter" FROM "Books" and -"Books/00. MOC Books" SORT file.name ASC FLATTEN Book
The crux of the problem is that I can’t add
WHERE status = "reading" since it targets the whole file, not any one particular inline field.
I understand that I could create one file for each chapter, and then query each file’s YAML for
status = "reading", but that doesn’t quite suit my workflow, because I want to track everything about a book in one file. I’m open to modifying the md structure in order to achieve this result.
Any help is much appreciated. Thank you again!