References: <87tu3jw20x.fsf@atmarama.ddns.net> <87fsf33tq4.fsf@prevos.net>
User-agent: mu4e 1.6.10; emacs 28.1
From: Peter Prevos <peter@prevos.net>
To: Peter Prevos <peter@prevos.net>
Cc: =?utf-8?B?U2HFoWEgSmFuacWha2E=?= <sjaniska@atmarama.net>,
 ~protesilaos/denote@lists.sr.ht
Subject: Re: using Denote with org-roam
Date: Tue, 01 Nov 2022 20:52:04 +1100
In-reply-to: <87fsf33tq4.fsf@prevos.net>
Message-ID: <87bkpr3sqt.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 and Prot,

I just added a feature request to the Org Roam UI list to include=20
the ability to add Denote links to the graph.

https://github.com/org-roam/org-roam-ui/issues/272

regards

P:)

Peter Prevos <peter@prevos.net> writes:

> Hi Sa=C5=A1a,
>
> I just installed Org Roam and it seems that Denote links are=20
> also
> stored in the database. It just hoovers up any Org Mode=20
> links. So 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
> database. If you add (=3D links:type "denote"), then the graph=20
> will 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 it is=20
> 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'
>     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