filtering outlinks

[dandobos]

Hi. I have a dataview table with file.outlinks
As expected, it shows all the out links to the file.
But, I want it to ONLY show links to notes which have the word "(Concept)" in the title.
How do I do this?
I have tried searching but couldn't make it work.
Thank you so much for your help.

[blacksmithgu]

TABLE 
  filter(file.outlinks, (o) => contains(string(o), "(Concept)")) AS "Outlinks",
  ...

[dandobos]

Amazing! Thank you!

[dandobos]

Hi. I am now trying to do 2 types of filters

1. file outlinks that exclude a specific note eg [[Book title]].
2. file outlinks that only include notes which have the word "(Concept)" in the title OR notes which have the word "(Topic)" in the title.

Thank you again for your help!

[AB1908]

When you say filter, do you want to exclude the row itself entirely or do you want to exclude that note from the existing results?

2 is relatively simple, filter(file.outlinks, (o) => contains(string(o), "(Concept)") || contains(string(o), "(Topic)")) AS "Outlinks"

[dandobos]

Thank you for the code.

I want to exclude the link to the specific note. So the row is still there, just the file outlinks exclude the link to that specific note.

[dandobos]

The code provided produced an error: filter(file.outlinks, (o) => contains(string(o), "(Concept)") || contains(string(o), "(Topic)") AS "Outlinks"

[AB1908]

I missed a closing paren. Updated the original

[dandobos]

Still getting an error :(

[dandobos]

I played around and figured it out... there should be just one | not two

[dandobos]

Are you able to assist with how I can exclude a specific link so that file outlinks include all links except, eg, [[book name]] ?

That would be super-appreciated.

[AB1908]

You'd need to add another condition to your filter: filter(file.outlinks, (o) => contains(string(o), ("(Concept)") | contains(string(o), "(Topic)") & !contains(o, [[your file]])) AS "Outlinks". Hope this works.

[dandobos]

Thank you so much. All sorted. Is there a course or youtube video that I can use to learn all of this stuff more systematically? I'm really just interested in using it for obsidian.