Large Work Order Lists Timing Out

Summary: Users with large work order databases experience timeouts when loading unfiltered list views containing 10,000 or more records.

Symptoms

• The Work Orders list displays a loading spinner indefinitely or returns an error after 30–60 seconds
• Browser console shows 504 Gateway Timeout or Request aborted
• Issue occurs most frequently on initial page load with no filters applied
• Smaller filtered subsets (e.g., "This Week") load normally

Affected Versions

FieldPulse 3.2.0 – 3.2.4. Reported primarily on web dashboard; mobile impact minimal due to default pagination.

Cause

The list view performs aggregation queries (count by status, total value calculations) across the full dataset before applying pagination. With large datasets, these queries exceed the 30-second query timeout threshold.

Resolution

Engineering has identified the root cause. Fix targeted for 3.3.0 (release scheduled late May 2026).

Workaround

Until the fix is deployed:

1. Navigate to Work Orders > List View
2. Before the timeout occurs, apply a date filter (e.g., "Last 30 Days") via the Filter panel
3. Bookmark this filtered URL for faster subsequent access
4. For bulk operations on large datasets, use the API pagination workaround or export via Reports > Work Order Export

Status: Under investigation. Fix targeted for 3.3.0.