List all bullet points under a certain heading

Show all list items under a specific heading¶

Basic¶

All lists inside the section "Research"

TABLE L.text AS "My lists"
FROM "10 Example Data/dailys"
FLATTEN file.lists AS L
WHERE meta(L.section).subpath = "Research"

Variants¶

grouping by file¶

TABLE rows.L.text AS "My lists"
FROM "10 Example Data/dailys"
FLATTEN file.lists AS L
WHERE meta(L.section).subpath = "Research"
GROUP BY file.link

Using flatten/filter instead of group-by¶

TABLE WITHOUT ID "<nobr>" + file.link + "</nobr>" AS Page, Research
FROM "10 Example Data/dailys"
FLATTEN list(filter(file.lists, (x) => meta(x.section).subpath = "Research").text) as Research
WHERE Research

Using flatten to make multiple columns based on different headings¶

TABLE WITHOUT ID "<nobr>" + file.link + "</nobr>" AS Page, Research, Topics
FROM "10 Example Data/dailys"
FLATTEN list(filter(file.lists, (x) => meta(x.section).subpath = "Research").text) as Research
FLATTEN list(filter(file.lists, (x) => meta(x.section).subpath = "Topics").text) as Topics
WHERE Research OR Topics