Tags and links

[jpedrorossolivares]

Hi! I am using Obsidian to organize some articles for my research. I want to create a table by tag that shows me all the articles that include it and (this is what I have not been able to do) all the articles that they cite related to that tag.

The first two things I achieved using this code:
dataview
TABLE WITHOUT ID tag AS Tags,
(rows.file.link) AS Files
FROM “URL to the folder”
WHERE file.tags FLATTEN file.tags AS tag
GROUP BY tag

But the third one has been complicated. Just to give you an example
In the file @jaesche2024, I have this written
"

• In the last decade HE enrollment has exponentially increased raising a threshold of over 90% in the cohort of students between 18 and 24 years ([Brunner, 2015](link to the file); [Gonzalez, 2018](link to the file)) #Enrollment
  "

And I would like to get a table with a row.

#Enrollment, @jaesche2024, (Brunner, 2015; Gonzalez, 2018)

I understand that the first thing I need to do is link the tag with each paper and then learn how to call them from Dataview. But I do not know how to do any of it. Any idea??

[jpedrorossolivares]

I tried an alternative, I transformed each point of the article into a task, so now I have

• First idea #Tag1
• A second idea #Tag2

And now in my DataView i did this

TABLE WITHOUT ID tag AS Tags,
(rows.file.link) AS Files,
rows.file.tasks.text AS Text
FROM "Reading_notes/299"
FLATTEN file.tags AS tag
FLATTEN file.tasks AS task
WHERE file.tags and contains(task.text,tag)
GROUP BY tag

This work almost fine (I know that includes all the text of the task and not only the references, but that is okay). The problem is that for some reason it is not making the match between the tag in the row, and the task with the tag.

So it’s returning a table that says

Tag 1, file_name, task1 and task2
Tag 2, file_name, task1 and task2

Any ideas??

[jpedrorossolivares]

NVM!! Changing to rows.task.text in the third line it worked!