Hmm, I don't see any effort values in the headlines table; they're all NULL.
Trivial test file:
* Test
:PROPERTIES:
:Effort: 1h
:END:
Result after running M-x org-sql-user-update:
sqlite> select headline_text, effort from headlines;
Test|
(I've configured only org-sql-files and org-sql-db-config to be the input org-mode file and the output sqlite file, respectively; no other changes to org-sql variables. Emacs 27.1 on Mac.)
Hmm, I don't see any
effort
values in theheadlines
table; they're allNULL
. Trivial test file:Result after running
M-x org-sql-user-update
:(I've configured only
org-sql-files
andorg-sql-db-config
to be the input org-mode file and the output sqlite file, respectively; no other changes toorg-sql
variables. Emacs 27.1 on Mac.)