We can do some fun things with our @34d2f004-ca59-4403-b312-d2dcd86d4465 queries, like display it in different ways!

Table Views

Let’s see some tasks, grouped by their status:

TitleStatus
done
📝 Issue with Status Fielddone
📝 Git based Overlay Filesystemdone
📝 Mentiondone
📝 Templatesdone
📝 a templated taskdone
📝 fix night mode colours on ganttdone
📝 Manifest.jsondone
📝 select text + auto-create issues from itdone
📝 Mentionsdone
📝 add function/flag to determine if a grouped result set is emptydone
in-progress
📝 Get it Workingin-progress
📝 block transclude and searchin-progress
📝 need to redo attachments nowin-progress
📝 tags needs to be completely redone (again)in-progress
backlog
📝 A public issuebacklog
📝 data loggingbacklog
📝 a second templated taskbacklog
📝 edit title/project of older entriesbacklog
📝 edit total time (updates end time.) rather than start/endbacklog
📝 hashtags?backlog
📝 customised manifest for form pages backlog
📝 duplicating turned URN refs into links properlybacklog
📝 persist start time of time logs when changedbacklog
📝 Block Propertiesbacklog
📝 RSSbacklog
📝 select tasks which changed from any State to completed within a specific time periodbacklog
📝 metadata for file uploads?backlog
📝 Link backend to the backend's "home" if it exists, in note metadatabacklog
📝 Starting time logging from a page, default to that as the title.backlog
Done
📝 Fix encoding of values into formDone
📝 Prevent circular parentingDone
📝 Custom Emoji / IconsDone
Backlog
📝 separate template tags and regular onesBacklog
📝 attachments deleted when editingBacklog
📝 If no blocks, auto open childrenBacklog
📝 add stars/fav/bookmarks Backlog
📝 What I'm doing automationBacklog
📝 log time should order by end time not update time
📝 Logging: changing the title doesn't get saved
📝 Logging: auto-save title + body field too
📝 maybe do not allow selection of backend for logging time, superfluous, based on project only.

Or formatted as a Kanban board:

Done
In-Progress
Backlog
📝 RSS
backlog
Done
Backlog
Unknown

Kanban

Or heck just show everything in the kanban

ERROR GROUP SELECT title, author, created, assignee, type FROM __all__ GROUP BY type ORDER BY created
no such column: author

Gantt

This is truly cursed :3

select title_plain, created, updated, type from __all__ group by type

the first column is assumed to be the title, the second two are start/end times. they’re auto-formatted as unix for mermaid

Error: list indices must be integers or slices, not NoneType
Traceback
Traceback (most recent call last):
  File "/home/runner/work/penemure/penemure/scripts/penemure/note.py", line 112, in render
    return self._render(oe, path, parent, pen, format=format, form=form)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/penemure/penemure/scripts/penemure/note.py", line 178, in _render
    page_content = render_gantt(res)
                   ^^^^^^^^^^^^^^^^^
  File "/home/runner/work/penemure/penemure/scripts/penemure/table.py", line 127, in render_gantt
    title = row[indexes['title']].replace(":", " ")
            ~~~^^^^^^^^^^^^^^^^^^
TypeError: list indices must be integers or slices, not NoneType

Or if you just want straight up graphs, let’s turn

select type, count(type) from __all__ group by type

into a pie chart

pie title 
    "account" : 1
    "ical" : 2
    "log" : 19
    "milestone" : 3
    "note" : 31
    "page" : 2
    "project" : 13
    "rss" : 1
    "task" : 41
 

Alternative Views

 Version d2be1cc261fb
Updated
Author avatar Helena Doc № PNMR-OSz7disZ