You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
10 lines
220 B
10 lines
220 B
#!/bin/bash
|
|
|
|
sqlite3 "$HOME/notes/metadata.db" <<SQL
|
|
.mode list
|
|
.separator ' - '
|
|
SELECT '~/notes/vimwiki/' || page, title FROM pages
|
|
-- WHERE page LIKE 'log/%'
|
|
WHERE datetime IS NOT NULL
|
|
ORDER BY datetime DESC
|
|
SQL
|