BMO/Comment Tagging

From MozillaWiki
< BMO
Revision as of 06:02, 23 July 2012 by Glob (talk | contribs)
Jump to navigation Jump to search

Comment Tagging

Overview

allow users with editbugs to add tags to individual comments.

one item of work is to add tags to individual comments. this will give users the ability to thread conversations, mark comments as spam, identify important comments, etc, without a large reworking of the bugzilla ui.

Brain Dump

  • add a new line within the comment box between the comment header and content which shows tags for that comment.
 +---
 | Byron Jones   2012-07-24 ...
 | tag_blue.png (x tag) (x another)
 | ...
  • clicking on the tag icon tag_blue.png will show a text box which
    • uses yui's autocomplete to assist the user to select a tag
    • refreshes the list of current tags for the comment (via ajax)
    • is cancelled when the text box loses focus
  • tags can not contain spaces, and have a limited range of valid characters - [\w\d\._-]
  • min tag length: 3 character; max tag length: 24 characters
  • editbugs is required, just being able to edit a bug is not sufficient (ie. reporters without editbugs will not be able to add tags)
  • tags are visible to any account, except anon (ie. you must be logged in to bugzilla for the tags to show)
  • anyone with editbugs can add or remove tags without restriction
  • tags can only be added to a bug once, adding an existing tag is a no-op
  • tags which match Regexp::Common::RE_PROFANITY will not be allowed
  • clicking on the "x" to the left of the tag will immediately remove the tag
  • tags are added and removed via ajax, changes are immediately visible to the changer without refreshing the page
  • tags added by other users (or on other tabs) will not be visible without a page refresh, or clicking on the tag [icon]
  • tags changes are added to bugs_activity, however they will not alter a bug's last-updated timestamp, trigger bugmail, or be exposed by inline-history
  • add a ui below the comment collapsing controls to collapse/expand by tag:
 Collapse All Comments
 Expand All Comments
 --
 Comment Tags:
   spam
   important
   ..
 (Click on a tag to only show comments with that tag)
 --
 Show CC Changes
  • add a admin configuration panel which lets you set which tags are collapsed by default (eg. 'spam')
  • add a report of tag usage

Schema

comment_tag

one(comment) to many(tags) table containing a comment's tags

comment_tag_id AUTOINC PK
comment_id FK --> longdescs.comment_id
tag VARCHAR(24)

comment_tags

quick lookup for autocomplete, updated when tags are added or removed from comments. the 'weight' is the count of instances of the tag; autocomplete will sort most frequently used tags first.

this is to avoid doing a GROUP BY against the whole comment_tag table with each keypress while someone is adding a tag.

comment_tags_id AUTOINC PK
tag VARCHAR(24)
weight integer