Filters Management
The Filters Management page provides comprehensive tools for managing filter records within the system. This interface allows administrators to search, view, edit, delete, and restore filter entries. Filters are used throughout the application to organize and categorize content, making this a critical administrative function for maintaining system organization.
Quick Start
To quickly find a filter: Use the search box in the toolbar and press Enter. To add a new filter: Click the "Add" button. To delete filters: Select checkboxes next to desired filters and click the red "X" button. To view deleted filters: Click "UnDelete" to switch to deleted items view.
The toolbar provides essential navigation and action buttons for managing filters:
| Button |
Function |
Description |
| Add |
Create New Filter |
Opens the record creation form to add a new filter entry |
| Back |
Browser Navigation |
Returns to the previous page in browser history |
| Search Box |
Filter Search |
Enter search terms and press Enter or click Search button |
| Search |
Execute Search |
Performs search based on text entered in search box |
| Show All |
Clear Search |
Displays all active filters by clearing search criteria |
| UnDelete |
View Deleted Items |
Switches view to show deleted filters with restoration options |
Data Table Structure
The main data table displays filter records with the following columns and functionality:
Table Columns
| Column |
Content |
Functionality |
| Checkbox |
Selection Control |
Individual record selection for bulk operations. Header checkbox selects/deselects all |
| Filter |
Filter Name |
Clickable column header for sorting. Displays filter name in uppercase |
| Delete |
Individual Delete |
Red "Delete" link with confirmation prompt for single record deletion |
| Calendar |
Calendar Link |
Opens calendar interface filtered by this filter name in new window |
| Edit |
Edit Icon |
Pencil icon that opens the record edit form in new window |
| AddLink |
Link Management |
Opens link editing interface for this filter |
| ID |
Record ID |
Clickable column header for sorting. Displays unique record identifier |
Bulk Action Controls
The bulk action controls appear in the leftmost column header and provide:
| Control |
Normal View |
Deleted View |
| Master Checkbox |
Selects/deselects all visible records |
Selects/deselects all deleted records |
| X Button (Red) |
Soft delete selected records |
Not available |
| + Button (Green) |
Not available |
Restore selected records to active status |
| Permanently Delete |
Not available |
Permanently removes selected records from database |
Search Functionality
The search system provides flexible filtering capabilities:
Search Methods
- Text Input Search: Enter search terms in the search box and press Enter or click Search button
- Partial Matching: Search uses wildcard matching, finding filters containing your search terms
- Case Insensitive: Search is not case-sensitive
- Persistent Search: Search terms are remembered in client variables between sessions
Search Results Display
The system displays search feedback in a black banner above the data table:
- No Results: "No records found matching [search term]"
- Single Result: "Your search of [search term] returned 1 result"
- Multiple Results: "Your search of [search term] returned X results"
- Show All Results: When no search term is active, shows total count
Sorting System
The data table supports sorting on key columns with visual indicators:
Sortable Columns
| Column |
Sort Behavior |
Visual Indicator |
| Filter |
Alphabetical sort by filter name |
Arrow icon showing ascending/descending direction |
| ID |
Numerical sort by record ID |
Arrow icon showing ascending/descending direction |
Sort Behavior
- First Click: Sorts column in ascending order
- Second Click: Reverses to descending order
- Different Column: Clicking a different column resets to ascending
- Persistence: Sort preferences are maintained in client variables
Deletion Workflows
The system implements a three-tier deletion system for data safety:
Soft Deletion (Normal View)
Tip: Soft deletion marks records as deleted but preserves them in the database for potential recovery.
Individual Record Deletion:
- Click the red "Delete" link next to any filter record
- Confirm the deletion in the popup dialog
- Record is marked as deleted (Private = 2) and hidden from normal view
- Page refreshes and shows deleted items view
Bulk Record Deletion:
- Select checkboxes next to desired records
- Click the red "X" button in the header
- Confirm bulk deletion in the popup dialog
- All selected records are soft deleted
- Page refreshes and shows deleted items view
Deleted Items View
When viewing deleted items (indicated by Showing Deleted badge):
| Action |
Button |
Result |
| Restore Records |
Green "+" Button |
Selected records restored to active status |
| Permanent Delete |
Red "Permanently Delete" Button |
Selected records completely removed from database |
| Return to Normal |
"Back to Filters" Button |
Returns to normal active records view |
Permanent Deletion
Warning: Permanent deletion cannot be undone. Records are completely removed from the database.
Permanent Deletion Process:
- Switch to deleted items view using "UnDelete" button
- Select records to permanently delete
- Click red "Permanently Delete" button
- Confirm the irreversible action in popup dialog
- Records are completely removed from database
Record Management
Creating New Filters
- Click the "Add" button in the toolbar
- System redirects to the record creation form
- Fill in required filter information
- Save the record to return to the main listing
Editing Existing Filters
- Locate the desired filter record
- Click the pencil edit icon in the Edit column
- Record edit form opens in a new window/tab
- Make necessary changes and save
- Close the edit window to return to main listing
| Function |
Access Method |
Purpose |
| Calendar View |
Click "Calendar" link |
Opens calendar filtered by this filter name |
| Link Management |
Click "AddLink" link |
Manage links associated with this filter |
Permissions & Security
Access Requirements
- Administrative Access: Users must have admin privileges to access this page
- Database Permissions: Requires read/write access to Filters table
- Session Management: Uses client variables for persistent settings
Security Features
- SQL Injection Protection: All database queries use parameterized statements
- Sort Direction Validation: Sort parameters are validated against whitelist
- Confirmation Dialogs: All destructive actions require user confirmation
- Soft Delete Protection: Initial deletion is reversible
Technical Details
URL Parameters
| Parameter |
Purpose |
Values |
| Action |
Specifies action to perform |
Delete, DelSel, UnDelSel, HardDelSel |
| query |
Search term |
Any text string |
| sort |
Column to sort by |
Filter, ID |
| showdeleted |
Show deleted records |
true/false |
| ID |
Record ID for single actions |
Numeric ID |
Client Variables
The system maintains user preferences through client variables:
- Client.Filters_query: Stores last search term
- Client.Filters_sort: Remembers last sorted column
- Client.Filters_sort_indic: Stores sort direction (ASC/DESC)
Summary
The Filters Management page provides comprehensive tools for managing filter records with search, sort, and three-tier deletion capabilities. The interface supports both individual and bulk operations while maintaining data safety through soft deletion and confirmation dialogs. All user preferences are preserved through client variables, and the system includes robust security measures against SQL injection and unauthorized access.
