Dataview Retrieve Texts Inside and Outside Lists

[arkad]

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.

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!

[holroy]

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).