Hi, I have a working query that I would like to extend. I have on every journal page a section in which I want to write down ideas for certain topics using hashtags. So it would look something like this:
# Notes
- #hastagone This is a note
- #hastagtwo this is another note
I have a query which gives me a nice list of all notes, but I would like it to only extract the bullets with a certain hashtag. Here is my current query.
TABLE
rows.bullets.text as Journal
FROM #journal
FLATTEN file.lists as bullets
WHERE meta(bullets.section).subpath = "Notes" AND file.ctime.year = 2024
SORT file.ctime DESC
GROUP BY file.link as "Day"
How can I add the condition to only extract the bullets from ```rows.bullets.text```` that contain a defined hashtag?
I have some questions regarding cosmetics. Now it does what it should do, but it shows now the dates when they are “empty”. So when no #hashtagone is there, it shows nothing. Is there a way to add a condition to only show it if isn’t empty? Thanks