Viewing all the notes (not a graph of them) linked to this note?

How To
1

Not sure if I understand this right, but is it possible to view the content of all the notes that are linked to a particular note, or some other org-agenda or org-ql-type operation which will construct a buffer containing some set of notes? So for instance, I would like to quickly share all the notes I took on all the references I entered yesterday, or all the references related to topic A. Is this something I can do in a straightforward way, or do I need to write code that will do that for me?

Thanks again!

2

A bit of understanding of the SQL DB will get you pretty far here. Say your topic A is file “topic.org”, then you can run a query as follows (copied from How to create a link to a org-roam search?):

(org-roam-db-query 
  [:select [from] :from links :where (= to $s1)] (expand-file-name org-roam-directory "topic.org"))

That would return you the list of files related to the topic, and you can also then programatically generate a new Org file using the #+INCLUDE syntax for Org to export all those notes.

3

Ah, that is super helpful, thank you. Doubtless some munging will be required but should be straightforward even for me. Thank you!

4

Looking for a way to include backlinks into an export to html I found this used in jethrokuan/dots that way:

  (defun jethro/org-roam--backlinks-list (file)
    (when (org-roam--org-roam-file-p file)
      (mapcar #'car (org-roam-db-query [:select :distinct [from]
                                        :from links
                                        :where (= to $s1)
                                        :and from :not :like $s2] file "%private%"))))
  (defun jethro/org-export-preprocessor (_backend)
    (when-let ((links (jethro/org-roam--backlinks-list (buffer-file-name))))
      (insert "\n** Backlinks\n")
      (dolist (link links)
        (insert (format "- [[file:%s][%s]]\n"
                        (file-relative-name link org-roam-directory)
                        (org-roam--get-title-or-slug link))))))
  (add-hook 'org-export-before-processing-hook #'jethro/org-export-preprocessor))