Content Moderation Queue

The Content Moderation Queue is a comprehensive administrative tool for reviewing and managing flagged content across your platform. This page allows moderators to review content that has been automatically flagged by content filters, user reports, or automated systems, and make decisions to approve, reject, or permanently remove flagged items. The system maintains a complete audit trail of all moderation actions.

Quick Start

Navigate to the Content Moderation Queue to see pending flagged items. Use the status filter to switch between pending, approved, rejected, or all items. Select items using checkboxes and use bulk actions to approve or reject multiple items at once. Individual items can be acted upon using the action buttons in each row.

Toolbar Functions

Button Function Description
Close Navigation Closes the moderation queue and returns to the control panel
Word List Configuration Opens the content filter word list management page
Status Filter Filtering Dropdown to filter items by status: Pending Review, Approved, Rejected, or All
Search Field Search Search across content text, filter reasons, and submitted by fields
Approve Selected Bulk Action Approves all selected pending items (only visible when viewing pending items)
Reject Selected Bulk Action Rejects all selected pending items (only visible when viewing pending items)
Permanently Delete Bulk Action Permanently removes selected reviewed items (only visible when viewing approved/rejected items)

Data Table Columns

Column Data Type Description
Checkbox Selection Select individual items for bulk actions. Header checkbox selects all visible items
Content Text Preview First 80 characters of the flagged content. Hover to see full text in tooltip
Source Reference Database table name and record ID where the content originated
Category Classification Content filter category that triggered the flag (profanity, sexual, hate, spam, etc.)
Reason Explanation Specific reason or trigger words that caused the content to be flagged
Submitted By User Username or identifier of the person who submitted the flagged content
Date Timestamp Date and time when the content was flagged and submitted for review
Status Badge Current status: pending approved rejected
Reviewed By Moderator Username of the moderator who reviewed the item (empty for pending items)
Actions Buttons Individual action buttons: Approve, Reject (pending only), and View (all items)
ID Number Unique database identifier for the flagged content record

Content Filter Categories

The system automatically categorizes flagged content based on the type of filter that was triggered. Each category is displayed with a colored badge for easy identification:

Category Badge Color Description
profanity Red/Pink Content containing profanity or inappropriate language
sexual Purple Content with sexual themes or explicit material
hate Dark Blue Hate speech or discriminatory content
spam Orange Spam content or unwanted promotional material
purgomalum Light Blue Content flagged by the PurgoMalum profanity filter service
custom Blue Content flagged by custom filters or manual reports

Moderation Workflows

Reviewing Pending Content

  1. Navigate to the Content Moderation Queue (default view shows pending items)
  2. Review the flagged content in the table - hover over content text to see the full text
  3. Check the Category and Reason columns to understand why the content was flagged
  4. Use the "View" button to see the complete content in a modal dialog
  5. Make a decision to approve or reject the content
  6. Use individual action buttons or select multiple items for bulk actions

Individual Item Actions

  1. Approve: Click the green "Approve" button to approve a single pending item
  2. Reject: Click the red "Reject" button to reject a single pending item
  3. View: Click the blue "View" button to see the complete content in a popup modal
  4. The page will refresh automatically after individual actions to show updated status

Bulk Actions Workflow

  1. Use the header checkbox to select all visible items, or select individual items
  2. For pending items, use "Approve Selected" or "Reject Selected" buttons
  3. For reviewed items, use "Permanently Delete" to remove items from the database
  4. Confirm the action in the dialog that appears
  5. The system will process all selected items and refresh the page

Moderation Tips

  • Review the filter reason carefully - automated systems can sometimes flag legitimate content
  • Consider the context of the content and its source when making decisions
  • Use the search function to find specific content or review items from particular users
  • The pending count badge in the header shows how many items need review
  • Bulk actions are efficient for processing multiple similar items at once

Status Management

Content Statuses

Status Meaning Available Actions
pending Awaiting moderator review Approve, Reject, View
approved Reviewed and approved by moderator View, Permanently Delete
rejected Reviewed and rejected by moderator View, Permanently Delete

Audit Trail

The system maintains a complete audit trail for all moderation actions:

  • ReviewedBy: Records the username of the moderator who made the decision
  • ReviewedDate: Timestamps when the moderation action was taken
  • Status Changes: Tracks the progression from pending to approved/rejected
  • Permanent Deletion: Only available for items that have already been reviewed

Search and Filtering

Status Filtering

Use the status dropdown to filter the content view:

  • Pending Review: Shows only items awaiting moderation (default view)
  • Approved: Shows items that have been approved by moderators
  • Rejected: Shows items that have been rejected by moderators
  • All: Shows all flagged content regardless of status

Content Search

The search function searches across multiple fields:

  • Content Text: Searches within the actual flagged content
  • Filter Reason: Searches the reason or trigger words that caused the flag
  • Submitted By: Searches by username or identifier of content submitter
  • Partial Matching: Uses partial text matching for flexible searches

Data Table Features

Table Controls

  • Pagination: Navigate through multiple pages of results
  • Items Per Page: Choose to display 25, 50, 100, or all items
  • Column Sorting: Click column headers to sort data (ID column sorts by default, newest first)
  • State Saving: Table remembers your sorting and pagination preferences
  • Responsive Design: Table adjusts to different screen sizes

Selection Features

  • Individual Selection: Check boxes next to each item for individual selection
  • Select All: Header checkbox selects all currently visible items
  • Cross-Page Selection: Selections persist when navigating between pages
  • Visual Feedback: Selected items are clearly highlighted

Permissions and Security

Access Requirements

  • Admin Authentication: Requires valid admin session with Client.ID
  • Sponsor Verification: Validates user against Sponsors table
  • Workgroup Permissions: Uses workgroup-based access control
  • Email Username: Tracks actions using email username for audit trail

Security Features

  • SQL Injection Protection: All queries use parameterized statements
  • XSS Prevention: Content is properly HTML-encoded for display
  • CSRF Protection: Form submissions include security tokens
  • Action Confirmation: Destructive actions require user confirmation

Integration with Content Filters

The Content Moderation Queue works in conjunction with the Content Filter system:

  • Automatic Flagging: Content filters automatically create flagged content records
  • Filter Categories: Different filter types create different category classifications
  • Word List Management: Access the word list management page directly from the toolbar
  • Source Tracking: Maintains references to original content location (table and record ID)
  • Multiple Triggers: Content can be flagged by multiple filters simultaneously

Best Practices

  • Review pending items regularly to maintain content quality
  • Consider context and intent when evaluating flagged content
  • Use bulk actions efficiently but review selections carefully
  • Keep the word list updated to improve filter accuracy
  • Document patterns in false positives to refine filter rules
  • Only permanently delete items when you're certain they won't be needed for reference

Summary

The Content Moderation Queue provides comprehensive tools for reviewing and managing flagged content across your platform. Moderators can efficiently process pending items using individual or bulk actions, maintain a complete audit trail of decisions, and permanently remove reviewed items when appropriate. The system integrates seamlessly with content filters and provides powerful search and filtering capabilities to help moderators focus on the most important items requiring attention. Regular use of this tool helps maintain content quality and community standards while providing transparency in the moderation process.