Show related links with Dataview

Summary

Multiple ways to show related links

Code

Unrequited Notes (links in but not out)

dataview
table file.mtime.year + "-" + file.mtime.month + "-" + file.mtime.day as Modified
from [[My Code Snippets]]
and !outgoing([[My Code Snippets]])
sort file.mtime desc

Table
from [[AI Art Debate]]
and !outgoing([[AI Art Debate]])
sort file.mtime desc

Related Unlinked Notes

dataview
LIST
FROM ""
FLATTEN topics as flattenedTopics
WHERE contains(this.topics, flattenedTopics)
AND file.name != this.file.name AND !contains(this.file.outlinks, file.link)

Unlinked Notes

dataview 
Table FROM [[#]] where !contains(this.file.outlinks, file.link) and !contains(topics, this.file.link)

Show tags and tagged notes

dataview
TABLE WITHOUT ID (tag + "(" + length(rows.file.link) + ")") AS Tags, join(rows.file.link, ", ") AS Files
WHERE file.tags 
FLATTEN file.tags AS tag
WHERE contains(tag, "source/")
GROUP BY tag 
SORT rows.tag ASC

These notes have the tag # and are not mentioned above.

dataview
table file.mtime.year + "-" + file.mtime.month + "-" + file.mtime.day as Modified
from #note  
and !outgoing([[My Queries and Code]])
sort file.mtime desc

Explanation

Result

up:: 🧪 Code Diary