---
urn: "urn:penemure:3b1142c2-dfa7-4130-b846-a3f7659ea670"
backend: "pub"
ancestors:
-  <span class="title">📁 Penemure</span>
created: 2025-04-03 07:21:31.396412+00:00
updated: 2025-04-03 07:21:31.396412+00:00

tags:
---

# 📝 maybe do not allow selection of backend for logging time, superfluous, based on project only.



but what if there's no associated task/project? is that likely?

maybe also restrict parents to project/task?

<!-- urn:penemure:gh:hexylena | d7ff3b2a-d3b5-4d3f-a7fc-7e5a29fc5d63 -->


## Work on this Issue

(todo, make this a gantt in the template, and add 'self')

<!-- urn:penemure:gh:hexylena | c17d038f-6aa1-44da-9332-1d1a3bfad6eb -->


```query-table
SQL SELECT
  title,
  CAST(created AS DATE),
  updated - created AS duration
FROM log
WHERE
  parents LIKE '%SELF%'
```

<!-- urn:penemure:gh:hexylena | b86161ea-58d6-4cd3-a4ca-fb53f6e9046a -->