TaskLite icon indicating copy to clipboard operation
TaskLite copied to clipboard

tasklite webapp cannot list tasks

Open vbmithr opened this issue 1 year ago • 4 comments

image

vbmithr avatar Nov 04 '24 11:11 vbmithr

Mh, interesting. Did you set it up as described here: https://tasklite.org/web_based_guis/web_app#usage ?

ad-si avatar Nov 04 '24 12:11 ad-si

Yep. I'm using latest commit.

vbmithr avatar Nov 04 '24 13:11 vbmithr

Oh, I only created the necessary view in my local database for testing. I created a new tracking issue for this at #93.

As a quickfix you can simply execute this query on your main.db:

CREATE VIEW "tasks_head" AS SELECT *
FROM tasks_view
WHERE closed_utc IS NULL
ORDER BY priority DESC, due_utc ASC, ulid DESC
LIMIT 50

ad-si avatar Nov 05 '24 09:11 ad-si

Works, thanks.

vbmithr avatar Nov 05 '24 09:11 vbmithr