14 lines
584 B
Bash
Executable File
14 lines
584 B
Bash
Executable File
#!/bin/bash
|
|
|
|
echo "Letzte Änderungen (neueste zuerst):"
|
|
sqlite3 -column -header ~/.local/share/mindwtr/mindwtr.db \
|
|
"SELECT row_number() OVER (ORDER BY updatedAt DESC) AS 'Pos.',
|
|
status AS 'Status',
|
|
(SELECT GROUP_CONCAT(value, ', ') FROM (SELECT value FROM json_each(t.contexts) ORDER BY value)) AS 'Kontext',
|
|
(SELECT GROUP_CONCAT(value, ', ') FROM (SELECT value FROM json_each(t.tags) ORDER BY value)) AS 'Schlagwörter',
|
|
substr(title, 1, 35) AS 'Aufgabe'
|
|
FROM tasks t
|
|
WHERE deletedAt IS NULL
|
|
ORDER BY updatedAt DESC
|
|
LIMIT 20;"
|