Is this doable?

[Nehrert]

I just started using Obsidian and watched some youtube tutorials. I'm not a coder. This is a new world for me. This seems to be the place to go for some help. I've tried to figure some out on my own and I managed to create a table from my list of books but I want more out of it. It looks like this:

Table author as Författare, ("![|100](" + coverUrl + ")") as Omslag, totalpage as Sidor, category as Kategori
From "Böcker"

But I want a fifth column where I can see if I have referenced that particular book in any of my articles that are also in Obsidian. Each article has its own .md file but in a different folder. I want the column to show the name of the article in which I have a reference to that book. All articles have a bibliography at the end where the book name is. Can I do another FROM argument inside a column and maybe create a LIST inside it?

Is this doable? Please reply in the most simple way you can :-) Think of me as a small child.

[AB1908]

This is somewhat difficult as you're trying to list file.outlinks and filter it down to show items from a specific folder. It should look something like this:

filter(file.outlinks, (p)=>contains(meta(p).path, "your article folder name here")) as Articles

Not very pretty, I know. This will be another column definition before your from statement in the existing query.

[Nehrert]

Thanks! It created a fifth column and I changed the folder path to match my folders containing my articles. Is there anything else I need to do to populate that column? For instance do I need to place som meta data into either my articles or my books. I'm using the plugin Book Search by anpigon to collect data about the books. Do I need to do anything to the expression
(p)=>contains(meta(p).path ?