Incident Dossier

Count that missed the where clause

The 'Open orders this week' KPI on the operations dashboard is wildly wrong — it always matches the total orders in the database. The helper that powers it receives a list of allowed statuses but never uses it.

Initial failing signalOpen orders count is the total table countExpected behavior: countOrdersByStatus(["open"]) returns 6 · actual behavior: countOrdersByStatus(["open"]) returns 10 (the whole table)

Progress

1Reproduce the bugRun checks

2Edit the fixOpen

3Pass checksOpen

4Submit fixOpen

Reproduction Steps

Run npm test.
Notice the count is always 10 regardless of the statuses filter.
Inspect countOrdersByStatus in src/orders.js.
Add a WHERE clause equivalent that filters by status before counting.

Focus Mode

Start

src/orders.js

Likely area

src/orders.js

Challenge Coach

Hints reveal broad direction first, then narrow toward the suspect path without showing hidden tests or exact solution code.

TopicDatabase

DifficultyEasy

Est. time12 min

Workspacepreparing

Explorer

Loading files

Evidence Map

Failing signal loaded from challenge API
Workspace files loaded from workspace API
Results rendered only after API run/submit

Autosaved

workspace

Outputread-onlyready$ prepare workspace

Preparing workspace