Uploaded image for project: 'Apache Roller'
  1. Apache Roller
  2. ROL-1329

Improve comment tracking with new [backend] status field

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.0
    • Component/s: Comments
    • Labels:
      None
    • Customer(s):
      blogs.sun.com
    • Level of effort:
      1 day

      Description

      The comment data for Roller tracks comments in up to 4 states and currently does so by using a combination of 3 boolean attributes (approved, pending, spam). This is a confusing way of tracking the state of a comment and is also less performant for database queries because the queries contain more criteria and it becomes harder to index the table.

      A simple suggested improvement is to add a new 'status' column to the roller_comment table (similar to the one for weblogentry) and use that as a way to track the comment status. this is both easier to understand and more performant for queries against the comment table.

        Attachments

          Activity

            People

            • Assignee:
              agilliland Allen T. Gilliland IV
              Reporter:
              agilliland Allen T. Gilliland IV
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: