Dataview Retrieve Texts Inside and Outside Lists

Hi everyone,
I have this dataview query, and it works correctly, but it only retrieves texts that are inside lists.

TABLE 
rows.L.text AS "What did I learn today?"
FROM "Journal/Daily"
WHERE date(file.name, "MMM dd , yyyy").month = 2 AND date(file.name, "MMM dd , yyyy").year = 2025
FLATTEN file.lists AS L
WHERE meta(L.section).subpath = "What did I learn today"
GROUP BY file.link

I want to modify the query so that it retrieves texts whether they are inside a list or not.
Screenshot 2025-02-02 224024

What do I need?
I want to retrieve all texts under the section titled “What did you learn today?”, whether they are written inside a list or not.

Current Issue:

  • The query currently uses FLATTEN file.lists AS L, which means it only looks for texts inside lists.
  • I need a way to retrieve texts directly under the section “What did you learn today?”, not just those inside lists.

Is there a way to modify the query to fetch all texts, whether they are inside a list or not?
Any help would be greatly appreciated!

The only non-metadata text which Dataview sees natively are the text within file.lists and file.tasks. It does not see the normal text within a note. If you want to access that you either need to switch to dataviewjs and read the file through javascript, or wait for Datacore (or dynamic views).