Hello, everyone. I’m currently using Org Roam for storing articles that I want to publish in my blog.
Every article is stored using the following format (see two examples below)
#+TITLE: Export Org Mode file to PDF using LaTeX
#+TITLE: Table formulas in Org Mode
As you can see above, each article has a STATUS property.
What I’m trying to accomplish is to list all the articles whose STATUS is Published.
I have managed to do this using dolist. However, I don’t find this approach efficient because I have to load all the nodes in memory and, in addition to that, I need to iterate through all nodes linearly. I’m mentioning this so that people don’t suggest me doing this.
Just to show there is a possibility; at least this below works on my end.
I am hoping that there should be a better way, to specify a single property in the vector. I need to leave it to someone with SQL expertise.
@jonathan , org-ql might be a good idea. Org-roam cache database keeps file/heading properties in tables such as nodes in the column named properties. You can see this by looking at the variable org-roam-db--table-schemata.