Skip to content

146 — Inquiry export — grouped rows with count column

Description

Creates 3 openings (2 with identical spec + 1 different), exports the inquiry XLSX ("Export poptavky"), and verifies the grouped format: 2 rows, one with Pocet=2 and one with Pocet=1.

Note: Currently blocked by backend bug (Prisma groupBy orderBy id not in by-fields). Ticket created.

Preconditions

  • Clean database
  • User logged in with ADMIN role
  • Backend fix for groupBy query deployed

Steps

  1. Create project, create 2 identical openings + 1 different — Expected: 3 rows in grid
  2. Click "Export poptavky" — Expected: XLSX downloads
  3. Parse XLSX, assert 2 rows — Expected: Grouped by spec
  4. Assert row 1: Pocet=2 (identical spec) — Expected: Merged
  5. Assert row 2: Pocet=1 (unique spec) — Expected: Separate
  • Spec: tests/e2e/tests/doors.spec.ts TC-9
  • Blocked by: Prisma groupBy bug (P2019)