Only show rows where filtered field returns data

Help
1

Hi,

I have the following query:

TABLE
filter(rows.bullets, (b) => contains(b.tags, "#random")).text as Notes
FROM #journal
FLATTEN file.lists as bullets
WHERE meta(bullets.section).subpath = "Notes" AND file.ctime.year = 2024
GROUP BY file.link as Day
SORT Day DESC
LIMIT 10

which gives he following result:

image
image759×148 3.42 KB

Question: How can I add the condition to only show days that are not empty. I tried adding the condition length(filter(rows.bullets, (b) => contains(b.tags, "#random")).text) > 0, but without any luck.

2

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.