Recent searches
Search options
![#+begin_src emacs-lisp :tangle no
(defun nickanderson/org-roam-db-TODO-files-CREATED-2023()
(seq-uniq
(seq-map
#'car
(org-roam-db-query
[:select [file]
:from nodes
:where (like properties '"%CREATED%2023%")
]
))))
(setq org-agenda-custom-commands
'(("z" todo "TODO" ;; (1) (3) (4)
((org-agenda-files (nickanderson/org-roam-db-TODO-files-CREATED-2023)))
)))
#+end_src](https://cdn.fosstodon.org/media_attachments/files/109/979/921/002/818/819/original/f908c8a594f423e7.png "#+begin_src emacs-lisp :tangle no
(defun nickanderson/org-roam-db-TODO-files-CREATED-2023()
(seq-uniq
(seq-map
#'car
(org-roam-db-query
[:select [file]
:from nodes
:where (like properties '\"%CREATED%2023%\")
]
))))
(setq org-agenda-custom-commands
'((\"z\" todo \"TODO\" ;; (1) (3) (4)
((org-agenda-files (nickanderson/org-roam-db-TODO-files-CREATED-2023)))
)))
#+end_src")
@nickanderson Interesting! The idea being you have a streamlined list of todos w/o parsing all files??
Is that your goal here?
@awws Yes, exactly! Long ago Agenda piqued my interest, made me think that I could put these TODOs in any org file anywhere on my file-system. But, in practice it was painful to have all files part of the agenda list, and directory structures weren't a great fit for me either, still pulling in too much or too little. But, with org-roam-db-query I think I can get a reasonable set of files for Agenda to parse with low maintenance.
@awws It can also allow me a time based cliff where for example I didn't get that TODO done in 3 months, just fall out of scope and stop. Clearly it wasn't that important, or if it is, it will certainly come up again. I'm excited about it. Time will tell if it changes my workflow I guess.
@nickanderson I have a complex system which archives all files that have no active TODOs every few months to an .org_archive extension which is visible to search but not to the agenda-files build.
So, very curious how your db querying goes.
Blog post?
@awws perhaps someday. I spend way more time using my system than tweaking it. It often takes me quite a while to integrate changes. I have yet to publish things I have written about my history with org-mode and emacs and how I org.
@awws I typically use archive tag but leave things where they are. Org-roam has helped me avoid my previous problem with multi-megabyte individual files. I've not yet gotten agenda to stick in my workflow but I keep trying from time to time.