connect log data tags to task names

connect log data tags to task names

task id: connect-logs-to-tasks

2024-05-27 11:44: Attempt to aggregate logs of a certain tag #connect-logs-to-tasks

If the tag belongs to a task, then this is a comment history.

This seems to work: 

SELECT day, time, title, comment from logs
INNER join logtags ON
logs.rowid = logtags.logid
WHERE logtags.tag is "add-tag-parser"
ORDER BY logs.rowid ASC;

2024-05-27 12:06: Creating "hist" tool #connect-logs-to-tasks

This will allow me to view a timeline of logs given a task name id.

2024-05-27 12:27: All core ingredients acquired for HTMLized task views #connect-logs-to-tasks