Hello to everyone.
I need some help in setting up a specific dataview querie.
Sorry in advance for my bad english.
I would like to visualize all of my “idea” notes based on the number of connections to all of my other notes which i call [[concept notes]] (and group them by number of connections.)
Now i’m using this
TABLE file.inlinks as Backlinks, length(file.inlinks) as Total
FROM "SlipBox"
SORT length(file.inlinks) DESC
but i can’t get rid of notes which are tagged “reference”.i would like to see only my “idea” notes
all of my notes look somethink like this (without actualò content)
Hi @mnvwvnm thank you
I’ve tested,but can’t get i right.I would like to see alla of my [[MOC …]] notes ,which are internally tagged “moc”, on the left side and notes tagged “idea” on right side.practically the most popular MOC notes which are linked from note with “idea” tag
i hope i get the question right.thank you
When in your first post you said “but i can’t get rid of notes which are tagged “reference”.i would like to see only my “idea” notes” you don’t specify which notes in table. So, the first deduction is: they want to filter the “source” notes, i.e., the notes you see in first column.
I started by this query
Now I have no idea about the start point.
you want to filter the source notes? The notes in first column? If yes, the notes with the tag “#moc”? Maybe FROM "SlipBox" AND #moc
you want (also) filter the file.inlinks you see in the second column? filter only file.inlinks tagged with #idea?
now i have this table.on the right i have notes which are tagged both “idea” and “reference” but i would like that the right column showed me only the ones with “idea” tag so i can see the most popular concept notes only for my ideas
1 - with a “bad code” I can suggest something like this (but implies repetitions, repetitions, etc.):
TABLE
filter(file.inlinks, (i) => contains(i.file.etags, "#idea")) AS Backlinks,
length(filter(file.inlinks, (i) => contains(i.file.etags, "#idea"))) AS Total
...
And then I guess you need to do the same in SORT command.
2 - there’s another way, but implies a more structured understanding in how works FLATTEN and GROUP BY commands. Something like:
TABLE rows.IN AS Backlinks, length(rows) AS Total
FROM "SlipBox" AND #moc
FLATTEN file.inlinks AS IN
WHERE contains(IN.file.etags, "#idea")
GROUP BY file.link AS File
SORT length(rows) DESC
thank you
