After the issue creation at GitBucket, users can add comments or close it. The details are saved at ISSUE_COMMENT
table.
To determine if it was any operation, you see the ACTION
column. And in the case of some actions, CONTENT
column value contains additional information.
ACTION | CONTENT |
---|---|
comment | comment |
close_comment | comment |
reopen_comment | comment |
close | "Close" |
reopen | "Reopen" |
commit | comment commitId |
merge | comment |
delete_branch | branchName |
refer | issueId:title |
add_label | labelName |
delete_label | labelName |
change_priority | oldPriority:priority |
change_milestone | oldMilestone:milestone |
assign | oldAssigned:assigned |
change_title | oldTitle(CRLF)title [1] |
[1]: (CRLF) is "\r\n"
This value is saved when users have made a normal comment.
These values are saved when users have reopened or closed the issue with comments.
These values are saved when users have reopened or closed the issue. At the same time, store the fixed value(i.e. "Close" or "Reopen") to the CONTENT
column. Therefore, this comment is not displayed, and not counted as a comment.
This value is saved when users have pushed including the #issueId
to the commit message. At the same time, store it to the CONTENT
column with its commit id. This comment is displayed. But it can not be edited by all users, and also not counted as a comment.
This value is saved when users have merged the pull request. At the same time, store the message to the CONTENT
column. This comment is displayed. But it can not be edited by all users, and also not counted as a comment.
This value is saved when users have deleted the branch. Users can delete branch after merging pull request which is requested from the same repository. At the same time, store it to the CONTENT
column with the deleted branch name. Therefore, this comment is not displayed, and not counted as a comment.
This value is saved when other issue or issue comment contains reference to the issue like #issueId
. At the same time, store id and title of the referrer issue as id:title
.
This value is saved when users have added the label.
This value is saved when users have deleted the label.
This value is saved when users have changed the priority.
This value is saved when users have changed the milestone.
This value is saved when users have assign issue/PR to user or remove the assign.
This value is saved when users have changed the title.