References: <87tu3jw20x.fsf@atmarama.ddns.net>
User-agent: mu4e 1.6.10; emacs 28.1
From: Peter Prevos <peter@prevos.net>
To: =?utf-8?B?U2HFoWEgSmFuacWha2E=?= <sjaniska@atmarama.net>
Cc: ~protesilaos/denote@lists.sr.ht
Subject: Re: using Denote with org-roam
Date: Tue, 01 Nov 2022 20:12:56 +1100
In-reply-to: <87tu3jw20x.fsf@atmarama.ddns.net>
Message-ID: <87fsf33tq4.fsf@prevos.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: quoted-printable


Hi Sa=C5=A1a,

I just installed Org Roam and it seems that Denote links are also=20
stored in the database. It just hoovers up any Org Mode links. So=20
as long as your Denote files have a ID tag that Org Roam=20
recognises, you can graph them with one minor modification.

The  org-roam-ui--get-links function fetches the links from the=20
database. If you add (=3D links:type "denote"), then the graph will=20
also show Denote links.

Seems to work pretty easily. Perhaps convince the Org Roam UI=20
designer to add a variable for link types that can be modified so=20
it is easier to include Denote links.

This is my version of the function:

(defun org-roam-ui--get-links (&optional old)
  "Get the cites and links tables as rows from the org-roam db.
Optionally set OLD to t to use the old db model (where the cites
were in the same table as the links)."
(if (not old)
    (org-roam-db-query
     `[:select  [links:source
                 links:dest
                 links:type]
       :from links
       :where (=3D links:type "id")])
  ;; Left outer join on refs means any id link (or cite link=20
  without a
  ;; corresponding node) will have 'nil for the `refs:node-id'=20
  value. Any
  ;; cite link where a node has that `:ROAM_REFS:' will have a=20
  value.
  (org-roam-db-query
   `[:select [links:source
              links:dest
              links:type
              refs:node-id]
     :from links
     :left :outer :join refs :on (=3D links:dest refs:ref)
     :where (or
             (=3D links:type "id")
	     (=3D links:type "denote")
             (like links:type "%cite%"))])))

Regards

Peter

--=20
Dr Peter Prevos
---------------
peterprevos.com


Sa=C5=A1a Jani=C5=A1ka <sjaniska@atmarama.net> writes:

> Hello,
>
> in a recent thread
> (https://org-roam.discourse.group/t/denotes-file-naming-scheme-and-org-ro=
am/2769/22)
> at org-roam group, Noboru Ota (nobiot) helped me to achieve
> interoperability  between Org-roam and Denote...iow. org-roam-ui=20
> can
> handle Denote's notes if the links are created with  with=20
> org-roam.
>
> Now I wonder if I'd continue using Denote (to take advantage of=20
> its
> (re)naming scheme, tagging etc.) with the hyperlinks created=20
> with
> org-roam - in order to make them work with org-roam-ui, what=20
> could I
> possible lose from the sigght of Denote?
>
>
> Sincerely,
> Sa=C5=A1a