Counting Linked Mentions

[andybyte]

I'm still learning Dataview (it's amazing). I found how to create a table of documents (with the tag "code"), and count their backlinks and list the files backlinking them.

TABLE file.inlinks as Backlinks, length(file.inlinks) as Total
where tag = "code"
SORT length(file.inlinks) DESC

What I want to do next is count the Linked Mentions as well. For instance, Document A mentions Document B 3 times. So in the table the Total column would list 3 instead of 1 Linked Mentions for Document B.

I feel like this is possible as this exact data is displayed in the Backlinks panel. But I can't figure out how to show it in a table.

[andybyte]

I see how I would get a list of linked mentions using Obsidian's embedded query:

line: [[TestCode1]]

Is it possible to take the results of an Obsidian Query statement and count those in a dataview block?

[CLocs]

I think you nailed it with file.inlinks and length(file.inlinks). That helped me. Thanks!

[andybyte]

I came up with a temporary solution. It doesn't focus on links but it will do for now. I plan to add brackets to the regex pattern next.

const count = (str, re) => {
  return ((str || '').match(re) || []).length
}

let things = dv.pages('#thing');
let sources = dv.pages('#source');
let myArray = [];
myArray = dv.array(myArray);

// Loop through things and count occurrences in sources

for (let t of things){

	const re = new RegExp(t.file.name,"g");
	
	for (let s of sources){
		let noteText = await dv.io.load(s.file.path);
		let countofmatches = count(noteText, re);
		let obj = { Thing: t.file.link, Source: s.file.link, Occurrence: countofmatches };
		if(countofmatches>0){
			myArray["values"].push(obj);	
		}
	}
}

Feel free to improve it. Javascript is not my primary language so I'm sure there are better/cleaner ways to do it.