Exportable “All services” detailed report (flat extract)

Description

Central Ops need a single long-form report that lists every service and all relevant fields in a flat, exportable format (CSV/XLSX). This enables downstream pivoting/filtering for external reporting without having to build bespoke views each time.

User story

As a Central Ops analyst, I want to export a detailed flat list of all services and their reporting fields, so I can pivot/filter the data for different reporting needs and remove anything not required.

Acceptance criteria

• A new report view exists: All services (detailed export).
• The view includes one row per service and includes all agreed service/reporting fields (including: division, directorate, portfolio, ownership/delivery, RAG/confidence, path to green, priorities, delivery type, dates, etc.).
• The view can be exported to CSV (minimum) and ideally XLSX.
• Export respects the user’s access scope (Central Ops exports everything; divisional viewers export their scope only).
• Exported files contain stable column headers (suitable for repeated use in pivots).
• Performance is acceptable for the current number of services (no timeouts / no partial exports).

Tasks

• Confirm the complete field list for the extract (map to DB fields / computed fields).
• Build the report query (including taxonomy joins).
• Add export endpoint/service for CSV (and XLSX if supported).
• Add basic filters (optional but useful): date range, status, division, directorate.
• Add audit/telemetry: who exported, when, and what scope.

Start by confirming the complete field list and mapping each item to database or computed fields, including taxonomy joins. Then define the report view and CSV export, with XLSX and filters as applicable. Done means stable headers, one row per service, access-scoped exports, acceptable performance, and audit/telemetry for exports.