What I’m trying to do
I log meetings and calls in my daily notes and tag the project where they belong. For example, in my Daily note, I could have the following
#ProjectA
- bullet description 1
- bullet description 2
In the actual project note, I want to be able to pull in bullets under all tags of the project. I also want the table to show the file source (in this case it will be a date since its a daily note) and concatenate bullets into a single row if they come from the same file.
I am able to successfully dataview query and show the file link as well as the bullets, but they are in separate rows using the ff query
TABLE WITHOUT ID
link(file.name) as "Date",
C.text as "Movements"
FROM #ProjectA
FLATTEN file.lists as L
WHERE join(L.tags, "") = "#ProjectA"
FLATTEN L.children as C
On the other hand, I am able to successfully query and concatenate the bullets, but it does not show the file link / file name:
TABLE WITHOUT ID
link(file.link, file.name) as "Date",
join(rows.C.text, "<br>") as "Movements"
FROM #ProjectA
FLATTEN file.lists as L
WHERE join(L.tags, "") = "#ProjectA"
FLATTEN L.children as C
GROUP BY file.name
Things I have tried
I’ve tried searching and using GPT for assistance but have remained stuck on being able to BOTH (a) return all bullets from the same file concatenated into one row and (b) show the file link or file name where it came from in another column.
I so far can accomplish either (a) or (b) above, but not both.
Any assistance would be greatly appreciated.