SciDEX — Task: [UI] Add /experiments listing page with filterable

Create a browsable /experiments page showing all 188 experiments with filtering by type, target gene, and disease. Cards should show title, score, cost, and linked hypothesis count. ## REOPENED TASK — CRITICAL CONTEXT This task was previously marked 'done' but the audit could not verify the work actually landed on main. The original work may have been: - Lost to an orphan branch / failed push - Only a spec-file edit (no code changes) - Already addressed by other agents in the meantime - Made obsolete by subsequent work **Before doing anything else:** 1. **Re-evaluate the task in light of CURRENT main state.** Read the spec and the relevant files on origin/main NOW. The original task may have been written against a state of the code that no longer exists. 2. **Verify the task still advances SciDEX's aims.** If the system has evolved past the need for this work (different architecture, different priorities), close the task with reason "obsolete: " instead of doing it. 3. **Check if it's already done.** Run `git log --grep=''` and read the related commits. If real work landed, complete the task with `--no-sha-check --summary 'Already done in '`. 4. **Make sure your changes don't regress recent functionality.** Many agents have been working on this codebase. Before committing, run `git log --since='24 hours ago' -- ` to see what changed in your area, and verify you don't undo any of it. 5. **Stay scoped.** Only do what this specific task asks for. Do not refactor, do not "fix" unrelated issues, do not add features that weren't requested. Scope creep at this point is regression risk. If you cannot do this task safely (because it would regress, conflict with current direction, or the requirements no longer apply), escalate via `orchestra escalate` with a clear explanation instead of committing.

Last Error

worker_exit_unclean exit_code=0

Git Commits (20)

[UI] api.py add experiments target gene filter [task:f605325e-dd96-42a7-b964-2a3b2f8f9ddb]2026-04-20

Spec File

[UI] Add /experiments listing page with filterable experiment cards

ID: f605325e-dd9 Priority: 88 Type: one_shot Status: open

Goal

Create a browsable /experiments page showing all 188 experiments with filtering by type, target gene, and disease. Cards should show title, score, cost, and linked hypothesis count.

Acceptance Criteria

☑ Concrete deliverables created

☑ Work log updated with timestamped entry

Work Log

2026-04-20 20:16 PDT — Slot 44

Started from a stale worktree assignment and selected the open one-shot task f605325e-dd9.
Reviewed the existing /experiments implementation and found the listing page and JSON endpoint already present, with type and disease filters but no target-gene filter.
Plan: add target-gene filtering to /experiments and /api/experiments, keep the query read-only, then verify the page and API route return filtered data.

2026-04-20 20:18 PDT — Slot 44

Implemented target-gene filtering for /api/experiments and /experiments, including preserving the selected target across type/sort/pagination controls.
Switched the /experiments listing query to get_db_ro() because the route is read-only.
Tested: python3 -m py_compile api.py; FastAPI TestClient GET /api/experiments?limit=5&target_gene=AQP4, /experiments?target_gene=AQP4, and /experiments?target_gene=AQP4&ajax=1 all returned 200.
Result: Done — /experiments now supports filtering by type, target gene, and disease.

Payload JSON

{
  "_reset_note": "This task was reset after a database incident on 2026-04-17.\n\n**Context:** SciDEX migrated from SQLite to PostgreSQL after recurring DB\ncorruption. Some work done during Apr 16-17 may have been lost.\n\n**Before starting work:**\n1. Check if the task's goal is ALREADY satisfied (run the relevant checks)\n2. Check `git log --all --grep=task:YOUR_TASK_ID` for prior commits\n3. If complete, verify and mark done. If partial, continue. If not done, proceed.\n\n**DB change:** SciDEX now uses PostgreSQL. `get_db()` auto-detects via\nSCIDEX_DB_BACKEND=postgres env var.",
  "_reset_at": "2026-04-18T06:29:22.046013+00:00",
  "_reset_from_status": "done"
}