List all bullet points that contain a specific word
List all list items with a certain word¶
Basic¶
List all bullet points that contain the word "ipsum"
LIST L.text
FROM "10 Example Data/dailys"
FLATTEN file.lists AS L
WHERE icontains(L.text, "ipsum")
Variants¶
list without file link¶
LIST WITHOUT ID L.text
FROM "10 Example Data/dailys"
FLATTEN file.lists AS L
WHERE icontains(L.text, "ipsum")
list - grouping by file¶
LIST rows.L.text
FROM "10 Example Data/dailys"
FLATTEN file.lists AS L
WHERE icontains(L.text, "ipsum")
GROUP BY file.link