My main use case with Obsidian is to build periodic reports based on the daily notes I write.
My daily notes are written with the Periodic Notes plugin, with the following path:
So for example:
In my Daily note, I have multiple section with bullet points in a hierarchy:
# Thursday, 24th August ## Bugs to Address - Replicate reported UI glitch in the settings menu - Debug API response for the user profile endpoint - Check if it’s an issue with the database query - Data synchronization bug in the mobile app is #done ## New Features to Implement - Design the new user dashboard layout - Code the authentication flow for the new SSO integration
→ How can I create a weekly report and extract the content of the
Bugs to Address section, while keeping the bullet point structure ?
I found the following topics have potential solution: Query bulleted dates and/or tag under a specific header: advice
Which is to combine
meta in order to filter on the heading.
LIST rows.item.text FROM "Journal/2023/08/W34" FLATTEN file.lists as item WHERE meta(item.section).subpath = "Bugs to Address" GOUP BY link(file.name)
However, this will break the bullet points nesting structure.
My question is: how can I do that ?
@kepano 's proposed solution to use the transclude feature would work:
# Weekly report ## Bugs to address - ![[2023-08-23#Bugs-to-Address]] - ![[2023-08-24#Bugs-to-Address]] ...
However you miss the power of the query language to filter on specific tags (for example #done)
So i’m not sure how to address this ?
Thank you in advance !