regexmatch on file.outlinks

[adueck11]

Hi, I would like to perform a query with regexmatch on outgoing links, but I always receive all notes which do have outgoing links.

This my query:

table file.outlinks
from #BibleVerseNote 
where regexmatch("Joh \d+,\d+", file.outlinks.name) 

These are all files in my test vault:

I would expect to get the green marked notes only, excluding the red marked ones.

Is this an error with Dataview or do I miss something?

Thank you for this great plugin!

[blacksmithgu]

1. Use file.name instead of name to get the proper file name of a file, since file.outlinks is a list of links.
2. regexmatch(, file.outlinks) produces a list of true/false values, one for each outlink. Dataview considers this to be a match if the list is non-empty, which is not what you want. Instead, use any(regexmatch(...)), which checks that at least one outlink matched.

I think this will work, or at least get closer to what you want:

table file.outlinks
from #BibleVerseNote 
where any(regexmatch("Joh \d+,\d+", file.outlinks.file.name))

[adueck11]

Thank you very much! This is exactly what I was looking for!