OpenSparrow v3.8 ships a brand-new Roadmap (Gantt) module and gives the record grid a long-overdue new-style facelift. The roadmap module turns any schema table into a read-only Gantt timeline — multiple roadmaps, category color chips, milestone markers — with zero new database objects. The rest of the release polishes what you look at all day: crisper table borders, a relocated sidebar toggle, refreshed branding and better color contrast on enum dropdowns. Below is a breakdown of what changed and why it matters.
Roadmap (Gantt) module
The headline feature lives in Admin → Data Management → Roadmap. You define one or more roadmaps, each bound to a schema table through a set of column mappings: which column holds the title, which ones the start and end dates, optionally a category column, a progress column and card columns for the row details. Everything is configuration in the existing spw_config store — there is no new table, no migration, nothing to run after upgrading.
On the frontend each roadmap renders as a read-only Gantt timeline:
- A month grid with quarter shading and prev/next navigation to scroll through time
- Milestone markers for rows without an end date — one-off deadlines show up as distinct markers instead of phantom bars
- A category filter bar — colored chips with a legend dot per category; click a chip to toggle the whole category on or off, and the filter state is remembered
- A per-roadmap color for the bars, plus configurable card columns showing extra data when you inspect a row
Access control follows the existing per-user scope model rather than inventing a new one. A new roadmaps scope gates the menu entries and the front API, and the bound table must additionally be within the user's table access — the same empty-grant-list-means-unrestricted semantics as every other scope. Granting a user a roadmap does not grant its table.
The CRM demo dataset gained a projects table with sample rows so you can seed a working roadmap in seconds, the UI strings are translated into all 20 locales, and the new endpoints are pinned by guard tests.
The grid now looks like a spreadsheet
If you spend your day inside the record grid, this is the change you'll notice first. The grid and view tables dropped the zebra striping in favor of new style cell borders every cell gets a border, the header row sits on a light background, and hover states highlight individual cells instead of whole rows. The result reads like a spreadsheet: dense, regular, easier to scan column-by-column. All colors come from the existing design tokens, so custom themes keep working.
A static design reference for the new look ships as public/mock.html — it isn't referenced by the application and is safe to delete from production deployments.
Smaller interface changes
- Sidebar toggle relocated — the desktop collapse toggle moved from the header to the bottom of the menu, where it belongs; the hamburger stays in the header on mobile
- Menu-list nav links now render at 14px
font-sans, aligning with the grid typography - Branding assets were refreshed — a new
logo.pngand a favicon that dropped from 207 KB to under 3 KB
Fixed
- Enum dropdowns keep readable text color via YIQ contrast on both the grid and the edit/create form — previously a custom enum color could render white-on-light or dark-on-dark option text. The contrast is computed server-side and applied consistently
-
docs.jsinconsistencies across admin modules were repaired, along with a broken Polish string indocs-strings.js - The cron, anonymization and ETL log docs now describe the status values correctly as
running / success / error(they were documented asok), indocs/DATABASE.mdand in the column comments emitted by the system-tables DDL
Upgrade note
No database migration and no configuration keys are removed by this release. Roadmap configuration lives in the existing spw_config store under the roadmap key; there is nothing to run or clean up after upgrading. For per-user access, remember the roadmaps scope is independent — users also need table access to see any roadmap content.
Following this series?
OpenSparrow v3.7 — Automation Email Queue and a Unified Admin UI
Top comments (0)