Content Filter Management

The Content Filter management page allows administrators to maintain a blacklist of words and phrases that are automatically filtered from user-submitted content. The system supports multiple filtering categories, severity levels, and match types to provide comprehensive content moderation capabilities.

Quick Start

To add a new filtered word: Enter the word/phrase in the "Add Word/Phrase" section, select the appropriate category and severity level, choose the match type, and click "Add". Use the search box to find specific words, and the category filter to view words by type. Select multiple words using checkboxes to perform bulk operations.

Page Header Information

The header bar displays essential session and system information:

Element Description
User Badge Shows the currently logged-in administrator's username
Page Title Displays "Web CoPilot 2.0 - Content Filter (Word Blacklist)"
Current Date Shows the current date in "Day Month DD, YYYY" format

Toolbar Functions

The toolbar provides navigation and filtering options that change based on the current view:

Normal View Toolbar

Button/Control Function
Close Closes the current page and returns to the Control Panel
Show All Displays all active words without any search or category filters
UnDelete Switches to deleted words view for restoration purposes
Category Filter Dropdown to filter words by category (All, Profanity, Sexual, Hate Speech, Spam, Custom)
Search Box Text input to search for specific words or phrases
Search Executes the search with the entered criteria

Deleted View Toolbar

Button/Control Function
Close Closes the current page and returns to the Control Panel
Back to Words Returns to the normal active words view

Add Word Section

The Add Word section appears only in the normal view and allows administrators to quickly add new words to the blacklist:

Field Description Required
Word/Phrase The word or phrase to be filtered from content Yes
Category Classification: Profanity, Sexual, Hate Speech, Spam, or Custom Yes
Severity Block (auto-reject) or Flag (send to review) Yes
Match Type Contains (partial match), Exact Word (whole word), or Regex (pattern) Yes

After filling in all fields, click the Add button to save the new word to the blacklist.

Words Table

The main data table displays all words with comprehensive filtering and sorting capabilities:

Table Columns

Column Description Features
Checkbox Selection checkbox for bulk operations Click header checkbox to select all visible rows
Word/Phrase The actual word or phrase being filtered Sortable, searchable, displayed in bold
Category Word classification with color-coded badges Profanity (red), Sexual (purple), Hate (black), Spam (orange), Custom (blue)
Severity Action taken when word is detected Block (red badge) or Flag (yellow badge)
Match Type How the word is matched in content Contains, Exact Word, or Regex
Added By Username of the administrator who added the word Sortable, searchable
Date Added When the word was added to the blacklist Formatted as MM/DD/YY
Actions Edit and Delete buttons (active view only) Edit opens modal, Delete requires confirmation
Status Icon Visual indicator of word status Green checkmark (active), Red X (deleted), Gray dash (inactive)
ID Unique database identifier Sortable, used for system operations

Table Controls

Control Location Function
Page Length Top left Select how many records to show per page (25, 50, 100, All)
Bulk Actions Top center Delete Selected (normal view) or Un-Delete/Permanently Delete (deleted view)
Search Filter Top center Real-time search across all visible columns
Pagination Top right, Bottom right Navigate between pages of results
Results Info Bottom left Shows current page range and total count

Word Management Workflows

Adding New Words

  1. Navigate to the Add Word/Phrase section at the top of the page
  2. Enter the word or phrase you want to filter
  3. Select the appropriate category from the dropdown
  4. Choose the severity level (Block for automatic rejection, Flag for manual review)
  5. Select the match type (Contains for partial matches, Exact Word for whole words, Regex for patterns)
  6. Click the Add button
  7. The word will be added and the page will refresh to show the updated list

Editing Existing Words

  1. Locate the word you want to edit in the table
  2. Click the Edit button in the Actions column
  3. The Edit Word modal will open with current values populated
  4. Modify any of the fields (Word/Phrase, Category, Severity, Match Type)
  5. Click Save to apply changes or Cancel to discard
  6. The modal will close and the table will refresh with updated information

Single Word Deletion

  1. Find the word you want to delete in the table
  2. Click the Delete button in the Actions column
  3. Confirm the deletion in the popup dialog
  4. The word will be soft-deleted (moved to deleted status, not permanently removed)
  5. The table will refresh and the word will no longer appear in the active view

Bulk Operations

Bulk operations allow you to perform actions on multiple words simultaneously:

  1. Use the checkboxes in the first column to select individual words
  2. Use the header checkbox to select all visible words on the current page
  3. Click the appropriate bulk action button:
    • Delete Selected - Soft delete all selected words
    • Un-Delete Selected - Restore selected deleted words
    • Permanently Delete - Hard delete selected words (cannot be undone)
  4. Confirm the action in the popup dialog

Bulk Operations Tip

When using bulk operations with pagination, only the checkboxes visible on the current page will be processed. To select all matching records across all pages, you'll need to navigate through each page and select the desired records.

Deletion and Restoration Workflow

The system uses a three-tier deletion system for data safety:

Soft Deletion (Active = 2)

  1. Words are marked as deleted but remain in the database
  2. Deleted words are hidden from the normal view
  3. They can be restored at any time without data loss
  4. The status icon shows a red X for deleted words

Viewing Deleted Words

  1. Click the UnDelete button in the toolbar
  2. The page switches to show only deleted words
  3. A red "Showing Deleted" badge appears in the results header
  4. The toolbar changes to show restoration options

Restoration Process

  1. In the deleted view, select the words you want to restore
  2. Click Un-Delete Selected
  3. Confirm the restoration action
  4. The words return to active status (Active = 1)
  5. They will reappear in the normal view

Permanent Deletion

  1. Only words in deleted status (Active = 2) can be permanently deleted
  2. In the deleted view, select the words to permanently remove
  3. Click Permanently Delete
  4. Confirm the irreversible action in the warning dialog
  5. The words are completely removed from the database
  6. This action cannot be undone

Category Filtering

The category dropdown in the toolbar allows filtering by word type:

Category Description Badge Color
All Categories Shows words from all categories without filtering N/A
Profanity Offensive language and curse words profanity
Sexual Sexually explicit or suggestive content sexual
Hate Speech Discriminatory or hateful language hate
Spam Promotional or spam-related content spam
Custom Site-specific or custom filtered words custom

Text Search

Multiple search options are available:

  • Toolbar Search: Searches the Word field using LIKE pattern matching
  • DataTable Search: Real-time search across all visible columns
  • Column Sorting: Click any column header to sort ascending/descending
  • Combined Filters: Category filter and text search work together

Severity Indicators

Severity Action Badge
Block Automatically reject content containing this word block
Flag Flag content for manual review by moderators flag

Permissions and Security

Access to the Content Filter management requires appropriate administrative permissions:

  • Authentication: Must be logged in with valid Client.ID
  • Session Validation: System validates sponsor account and permissions
  • Workgroup Access: User workgroup determines available functions
  • Audit Trail: All word additions are tracked with the adding user's username
  • Data Protection: Soft delete system prevents accidental data loss

Security Tip

The system automatically populates the Email_Username from the sponsor record if not already set in the session. All database operations use parameterized queries to prevent SQL injection attacks.

Match Types Explained

Understanding the different match types helps create effective content filters:

Match Type Description Example
Contains Matches if the word appears anywhere in the content "bad" matches "badword", "rebad", "bad"
Exact Word Matches only complete words with word boundaries "bad" matches "bad" but not "badword"
Regex Uses regular expression pattern matching "b[a@]d" matches "bad", "b@d"

Troubleshooting

Common Issues

Issue Cause Solution
Word not appearing after adding Category filter is active Select "All Categories" or the appropriate category
Cannot see deleted words In normal view mode Click "UnDelete" button to switch to deleted view
Bulk operations not working No items selected Select checkboxes before clicking bulk action buttons
Search returns no results Conflicting filters active Clear category filter and try again

Summary

The Content Filter management page provides comprehensive tools for maintaining a word blacklist to moderate user-generated content. Key features include categorized filtering with severity levels, flexible match types, soft-delete protection, bulk operations, and detailed search capabilities. The system maintains an audit trail of all changes and provides both automatic blocking and manual review options. Regular maintenance of the word list helps ensure effective content moderation while minimizing false positives through precise match type selection.