DEF-047 — Activity Logs: Filter by Action returns 0 results for all action values

Defect DEF-047 — Severity: High · Status: New

DEF-047 — Activity Logs: Filter by Action returns 0 results for all action values

Summary

The Filter by Action dropdown on the Activity Logs page (/admin/activity-logs) returns “No data available in table” (0 entries) for every selectable action value — Login, Logout, Create, Update, Delete, Status Change. The unfiltered table shows 482 entries including entries of every action type, confirming the data exists. Only the server-side filtering by action is broken. The Filter by Module and Search controls work correctly on the same page.

Environment

• URL: https://project6.dxtserver.com/drivelink_new/public/admin/activity-logs
• Module: Admin Panel — Activity Logs → Filter by Action
• Date Reported: 2026-06-17
• Browser: Chromium (Playwright)
• Testing Phase: Admin Panel — Section 17: Activity Logs (test case AL-07)

Steps to Reproduce

1. Log in to the Admin Panel.
2. Navigate to Activity Logs (/admin/activity-logs).
3. Confirm all 482 entries are visible (including Updated, Deleted, Created actions).
4. Select “Update” from the Filter by Action dropdown.
5. Observe: table shows “No data available in table” — 0 entries.
6. Select “Delete” — same result: 0 entries.
7. Select “Create” — same result: 0 entries.
8. All other values (Login, Logout, Status Change) also return 0 entries.
9. Changing Filter by Module to “Settings” correctly narrows to 13 entries (confirms module filter works).

Root Cause Evidence

The JavaScript passes d.action = $('#action_filter').val() to the server endpoint. The client-side option values are login, logout, create, update, delete, toggle_status. The server likely expects a different format (e.g., capitalised “Updated”, “Deleted”) or the action filter parameter is not implemented in the activity-logs/list endpoint.

Expected Behaviour

Selecting “Delete” from Filter by Action should return all log entries where the action is a deletion. The filter should narrow the 482 total entries to the relevant subset.

Actual Behaviour

Every action filter selection returns 0 results, regardless of which action is chosen. The table shows “No data available in table” — making the Filter by Action control completely non-functional.

Impact

• Administrators cannot filter activity logs by action type (Create, Delete, Update, etc.)
• Investigating suspicious operations (e.g., unexpected deletions) requires scrolling through all 482+ entries
• Only Module filter and text search are usable as filtering tools

Severity

High — A primary filter control on the audit trail page is completely non-functional.

Priority

High

Status

New

Reported By

QA / Testing Team