I was on my phone when I posted but would like to post the variations and error results I have unsuccessfully tried for any insights.
What I am doing is looking for any text under the “Thoughts and Notes” subsection which is where I place items that don’t rise to a task/todo level, or are fleeting thoughts, etc. As they are in my daily notes but not referenced easily, I am trying to make a single page where these are gathered so I don’t forget. If the note get’s moved, then obviously it’s not in the subsection anymore but others, I want to keep around just in case for now so I strikeout the text. As I work through the process of building my PKM, I may simply just delete them.
TABLE L.text AS "Thoughts and Notes"
FROM "01_Daily_Notes"
FLATTEN file.lists AS L
WHERE meta(L.section).subpath = "Thoughts and Notes"
WHERE !match(file.content, /~\~(.*?)\~\~/gm)
TABLE L.text AS "Thoughts and Notes"
FROM "01_Daily_Notes"
FLATTEN file.lists AS L
WHERE meta(L.section).subpath = "Thoughts and Notes"
WHERE NOT meta(L.text).(file.content, /~\~(.*?)\~\~/gm)
TABLE L.text AS "Thoughts and Notes"
FROM "01_Daily_Notes"
FLATTEN file.lists AS L
WHERE meta(L.section).subpath = "Thoughts and Notes"
WHERE NOT file.content.contains("~~")
