gitea icon indicating copy to clipboard operation
gitea copied to clipboard

kanban board notes

Open luwol03 opened this issue 4 years ago • 4 comments

Allow notes in an project board which are not related to an issue, like github have it. IMG_20200817_235150

IMG_20200817_234916

luwol03 avatar Aug 17 '20 21:08 luwol03

Yes, like custom tasks. Not sure if the new Kanban implementation have end date, but custom tasks should have the same level of options as issues in the kanban. (Ability to assign a person, a priority, tags, maybe a "private" options only team member would see)

Extarys avatar Sep 04 '20 00:09 Extarys

I say let's start small with just a comment and then add more functionality to the comment as time goes on. I'm proposing the following table definition for a comment:

Create Table Project_Comment (
  ID bigint primary key,
  Project_ID bigint not null,
  Project_Board_ID bigint not null,
  Comment Text not null,
  creator_id bigint not null,
  created_unix bigint not null,
  updated_unix bigint not null,
  Foreign Key (Project_ID) references Project(ID),
  Foreign Key (Project_Board_ID) references Project_Board(ID)
)

That is mostly SQL, which might contain a syntax error somewhere. Also would like to propose the following flow:

  1. Create a Project Board
  2. On any card, click a plus icon to create a comment
  3. Fill out comment and click save
    • Alternatively, click Cancel to delete the comment.
  4. Move comment (if needed) to any card
  5. Promote comment to issue
    • Remove from comment table and add to issue table.
    • Everything for an issue can be obtained from the foreign key relationships

Definitely open to comments on this, but I think this is a very fair start.

kcbimonte avatar Nov 11 '20 04:11 kcbimonte

Still missing, but hope to be added

Wufus avatar Aug 09 '23 10:08 Wufus

any updates?

zokkis avatar Feb 01 '24 23:02 zokkis