tasks and dates

[amitu]

NOTE: To appreciate this feature proposal, read about Org-Mode Workflow for Task Management first. I am huge fan of org-mode btw. One of reasons I created this startup was to create a real modern org mode for everyone.

Continuing from this idea in fpm db discussion, what if in fpm.headings we added task-status, tags, datetime and deadline fields.

CREATE TABLE [fpm.sections]:
    TEXT document-id,
    TEXT section-name, -- will be full name eg fifthtry.github.io/doc-site#h1
    INTEGER section-index;  -- index in the document is this first section or second and so on
    INTEGER level, -- if a ft.warning contains a ft.info, the level of ft.warning would be 0, and ft.info 1.
    TEXT kind,  -- record definition | record construction | component definition | component construction | variable creation | variable - updated

    TEXT caption,
    JSON arguments,  -- will not include other sections?
    TEXT body,


    -- universal arguments
    TEXT term NULL,
    TEXT id,
    TEXT task-status,
    TEXT tags,
    INTEGER datetime,
    INTEGER deadline,

task-status

In any heading what if we can add task: PENDING | WAITING | BLOCKED | DONE:

-- ft.h1: implement proxying
task: PENDING

This was we can convert any heading in any document into a todo item. The entire package can become a big todo list.

tags

Tags can be used to filter out tasks:

-- ft.h1: implement proxying
task: PENDING
tags: proxy, fpm

Tags would be available for filtering.

datetime

We can put datetime on any heading, even if they are not task, so that we can show a link to that heading in the calendar view. This way a single document can have any number of headings that show up in a package timeline.

If this is on a task, datetime can be considered sort of a when you want to work on a task vs deadline, which is when a task is due.

deadline

This is to capture some external deadline. For example to file tax you may have a datetime as the date when you want to work on the tax filing, and deadline be the last date you must finish before.