| NAV-001 |
Direct link to a table list renders seeded rows |
n/a |
pass |
browser shell; TUI: qqq ui table query ; :table query |
| NAV-002 |
Sidebar lists every permitted top-level app once, by label, in backend order, with nested apps only under thei |
n/a |
pass |
browser shell; TUI: Apps tree, backend order |
| NAV-003 |
Apps nested deeper than two levels render as nested sidebar groups; deep links expand every enclosing group |
n/a |
pass |
browser shell; TUI: nested apps in the tree |
| NAV-004 |
Sidebar click navigation to app homes, tables and processes with active-entry highlighting and collapse/expand |
n/a |
pass |
browser shell; TUI: Enter opens; current entry marked; arrows expand and collapse |
| NAV-005 |
Declared icons (QIcon name, color, path) render on navigation surfaces |
n/a |
n/a |
browser shell; TUI: icon glyphs are a browser icon font; the TUI marks processes and reports and shows the icon name on app cards |
| NAV-006 |
Hidden tables and processes never appear in navigation; direct links to hidden objects the user may not access |
pass |
pass |
hidden tables and processes are not listed; direct use is refused by the server; TUI: hidden tables and processes are not listed |
| NAV-007 |
A hidden table the user may access opens by direct link (hidden is not denied) |
pass |
pass |
qqq table get on a hidden table the user may read; TUI: :table query and :record open hidden tables the user may read |
| NAV-008 |
App home sections list processes (Actions), reports (Reports) and tables (Data) by label with icons, and each |
pass |
pass |
qqq apps show : sections of processes, reports, tables and child apps, then widgets; TUI: app home: sections with tables, processes, reports |
| NAV-009 |
App home table entries show the backend record count |
pass |
pass |
qqq apps show counts each table with TABLE_COUNT (--no-counts skips); TUI: record counts beside tables |
| NAV-010 |
App homes of apps with child apps, only processes, or nothing render without errors |
n/a |
pass |
app home rendering |
| NAV-011 |
A dashboard app (widgets only) opens from navigation and shows one labelled container per permitted declared w |
pass |
pass |
qqq apps show --widgets: one labelled section per permitted declared widget, loaded once each; verified live on SampleWidgetsDashboard; TUI: dashboard apps draw their widgets |
| NAV-012 |
Branding: sidebar logo (Material parity), app name, favicon from the icon, accent color, and partial branding |
n/a |
n/a |
browser shell; TUI: logo, favicon and accent images are browser-only; the app name is in the title bar and on Home |
| NAV-013 |
Branding banners render in their slots (top of site, top of body, side nav under logo) with text or sanitized |
n/a |
n/a |
browser shell |
| NAV-014 |
Breadcrumbs show the full app hierarchy for tables, processes, records, create and edit pages, and each crumb |
n/a |
pass |
browser shell; TUI: title-bar path: apps, table, record or form |
| NAV-015 |
Document title names the page, its enclosing apps and the application (Material parity) |
n/a |
n/a |
browser shell |
| NAV-016 |
The site root redirects to the dashboard |
n/a |
n/a |
browser shell |
| NAV-017 |
Dashboard landing page: counts, quick actions and application cards derived from navigable, permitted metadata |
pass |
pass |
qqq home: counts of what you may open, quick actions (permitted processes in your apps, with the command) and one card per app; verified live; TUI: Home: greeting, counts, recents, quick actions, app cards, work |
| NAV-018 |
Direct (hard-loaded) links open every route shape with the shell, sidebar state and breadcrumbs |
n/a |
pass |
browser shell; TUI: qqq ui |
| NAV-019 |
Browser refresh keeps the route, its query string and the rendered content |
n/a |
n/a |
browser shell |
| NAV-020 |
Browser back and forward traverse navigation history with the right content |
n/a |
n/a |
browser shell |
| NAV-021 |
An unknown /app/{name} shows an in-shell not-found state with a link to the dashboard |
n/a |
n/a |
browser shell |
| NAV-022 |
Unknown deeper or top-level paths return the 404 page with a working home link |
n/a |
n/a |
browser shell |
| NAV-023 |
Record lookup by key: /app/{table}/key?{field}={value} opens the single matching record |
pass |
pass |
qqq table get --key field=value: one match shows the record, none exits 5, several exit 2; TUI: g: primary key or a configured unique key (kernel gotoKeys) |
| NAV-024 |
Command palette (Ctrl+K and '.') lists navigable apps, tables and processes by label with type and app context |
pass |
pass |
qqq find [--type]: apps, tables, processes and reports by label with type, app and the command that opens each (the terminal's palette); verified live; shell completion covers names; TUI: F2, /, ., Ctrl+K palette with type and app context |
| NAV-025 |
Header search, '/' search dialog and search page jump to navigation targets and recently viewed records by lab |
pass |
pass |
qqq search; TUI: the palette (F2, /, ., Ctrl+K) jumps to navigation targets and recently viewed records; live |
| NAV-026 |
Mobile navigation drawer opens from the header, navigates and closes |
n/a |
n/a |
browser shell |
| NAV-027 |
Developer page reports the backend metadata counts and the running framework versions |
pass |
pass |
qqq whoami: apiVersion, features, counts; TUI: F9 › Connection: UI API version, features, extensions, metadata generation and age, client build; live |
| NAV-028 |
Reports in the app tree are listed under their app (sidebar and app home Reports group) and open the report pa |
pass |
pass |
qqq report list (with app) and apps show list reports in the app's Reports group, report run opens them; unit-tested and stub-server tested (the sample has no reports); TUI: reports listed under their app and in the tree, palette and F9; Enter runs one (format chosen, process screens, file saved) (unit-tested only; the sample has no reports) |
| NAV-029 |
A user who may access no apps sees the Dashboard entry and the no-apps message (Material NoApps parity) |
n/a |
n/a |
browser shell |
| NAV-030 |
Global search (header box, '/' dialog, search page) lists the records a backend record search (POST /qqq/v1/se |
pass |
blocked |
qqq search over POST /search; TUI: the palette calls POST /search; the sample lists recordSearch with no provider (server finding 21); live on fix branch 8bf6a5a66: recordSearch is no longer advertised and the palette says so; POST /search still has no provider (finding 21) |
| NAV-031 |
Record search respects table read permissions and record security locks, in the UI and the API |
pass |
pass |
server-enforced; refusals shown; TUI: server-enforced; the palette shows only what the server returns |
| NAV-032 |
Without searchable tables (the backend declares no searchFields) global search stays local and never calls a s |
n/a |
n/a |
browser shell |
| NAV-033 |
Login branding before sign-in: logo, app name, accent color, favicon and title from GET /qqq/v1/metaData/authe |
n/a |
n/a |
browser shell |
| NAV-034 |
Material table-scoped URLs: /app/{table}/{process} opens the table process (or an instance process); /app/{tab |
n/a |
n/a |
browser shell |
| NAV-035 |
Process runs launched from a record view or a filtered query return there (Return and Cancel honor returnTo) |
n/a |
pass |
browser shell; TUI: Esc returns to the record or query, cursor kept |
| NAV-036 |
Material app settings (MaterialDashboardAppMetaData): showAppLabelOnHomeScreen and includeTableCountsOnHomeScr |
n/a |
n/a |
browser shell |
| NAV-037 |
Mobile navigation drawer is a keyboard-usable modal dialog: focus moves in on open, Tab stays inside, and Esca |
n/a |
n/a |
browser shell |
| NAV-038 |
Shell on phones and tablets: skip link, header controls, breadcrumbs, navigation entries, user menu, app homes |
n/a |
n/a |
browser shell |
| NAV-055 |
Material Dashboard CSS and test hooks remain available on navigation, banners, app homes, forms, record views |
n/a |
n/a |
browser shell |
| NAV-056 |
The Material Dashboard theme from versioned QQQ metadata changes Next UI tokens, application CSS and the brand |
n/a |
n/a |
browser shell |
| PRF-001 |
large table: a 10,000-row, 40-column table opens with every column and the exact first page within budget |
pass |
pass |
10,000 rows with --all and --page-size; TUI: fake big server 10,000 rows x 40 columns at 160x45 (scripts/perf-large-table.sh): first page 95-100 ms with col 1/40, End to record 10,000 in 39-45 ms, to column 40 in 343-364 ms; budget 2,000 ms per step |
| PRF-002 |
large table: 250-row pages of 40 columns render, page and reach the last page within budget |
pass |
pass |
--limit/--skip paging; TUI: server-paged grid, page = visible rows |
| PRF-003 |
large table: sorting and filtering 10,000 rows return exact results within budget |
pass |
pass |
server sort and filter; TUI: server sort and filter |
| PRF-004 |
heavy dashboard: 24 widgets (statistics, bar, line and pie charts, 100-row tables) load once each within budge |
pass |
pass |
apps show --widgets loads every widget once, all at once, in declared order: 24 widgets (statistics, charts, 100-row tables) answering in 150 ms each finish well under 3 s; stub-server tested; TUI: dashboards load widgets as they come into view, 4 at a time (fake 3000-widget instance) |
| PRF-005 |
long process: a 10-second job over 10,000 rows reports progress, polls at a bounded rate and shows its result |
pass |
pass |
process run polls every 500 ms and prints progress; TUI: progress N/M, elapsed, 250 ms polling |
| PRC-001 |
Selected-record run: record ids reach the backend, screen values are submitted, mixed view and record-list res |
pass |
pass |
process run -r ids; TUI: grid selection or record, ids sent |
| PRC-002 |
All-records run from a filter selection with no criteria |
pass |
pass |
--filter-json; TUI: without a selection: the grid filter |
| PRC-003 |
Zero-record runs from a filter that matches nothing |
pass |
pass |
TUI: a filter that matches nothing runs as the server decides (zero records) |
| PRC-004 |
Processes launched from an app (no records) |
pass |
pass |
|
| PRC-005 |
Process launched from selected rows of a table query |
n/a |
pass |
grid selection; use -r; TUI: Space selects, b runs a table process |
| PRC-006 |
Minimum and maximum input records |
pass |
pass |
checked before init (filters counted); the sample declares no limits, verified by tests; TUI: kernel checkInputRecords before init |
| PRC-007 |
Every declared component renders on one screen, in declared order, with one action bar |
pass |
pass |
every component in order as text (kernel screen model); bulk load forms belong to qqq bulk; TUI: kernel screen blocks: forms, view, records, review, summary, help, HTML, widgets, downloads |
| PRC-008 |
HELP_TEXT with line breaks and previewText toggle |
pass |
pass |
text with line breaks; previewText printed above it; TUI: HELP_TEXT and its preview from the kernel screen |
| PRC-009 |
EDIT_FORM field subsets (includeFieldNames), section labels and persisted input values |
pass |
pass |
includeFieldNames and values kept across steps; TUI: includeFieldNames via the kernel runner |
| PRC-010 |
Required input validation on screens and in the backend |
pass |
pass |
required checked locally and by the server; TUI: required checked by field before submit |
| PRC-011 |
Process possible-value fields |
pass |
pass |
labels or ids, prompts list choices; TUI: picker |
| PRC-012 |
VIEW_FORM labels and backend values |
pass |
pass |
label: value on every step; TUI: summary shows view fields |
| PRC-013 |
HTML component renders the step html value, sanitized |
pass |
pass |
{step}.html as text (tags stripped); TUI: HTML component as text from the kernel screen |
| PRC-014 |
DOWNLOAD_FORM delivers the generated file |
pass |
pass |
GET /download/{file} saved to --out-dir, else the download directory; no sample process offers one, verified by tests; TUI: w saves the DOWNLOAD_FORM file through the save dialog (unit-tested only) |
| PRC-015 |
Step help content for process screens |
pass |
pass |
step helpContents shown on the screen, process help at start and in describe; none in the sample; TUI: step and process help in the screen |
| PRC-016 |
Back to the backend back step with entered values |
pass |
pass |
b at a prompt when the step reports backStep (isStepBack=true); verified live: bulk insert -i back from the mapping to the upload and from the review to the mapping; TUI: F4 goes back to the backend back step (process screen and bulk wizard); live |
| PRC-017 |
Dynamic step list from processMetaDataAdjustment.updatedFrontendStepList |
pass |
pass |
updatedFrontendStepList followed; TUI: kernel runner |
| PRC-018 |
Updated field metadata from processMetaDataAdjustment.updatedFields |
pass |
pass |
updatedFields applied; TUI: kernel runner |
| PRC-019 |
Async job progress in the live job view (message, N / M, determinate progress bar, elapsed) then continue |
pass |
pass |
message, N/M, elapsed on stderr; TUI: bar, N/M, message, elapsed |
| PRC-020 |
Cancel from a screen and mid-job runs the cancel step and leaves |
pass |
blocked |
Ctrl-C during a job or a prompt calls POST …/cancel, exit 130; TUI: Esc asks, then POST cancel; the sample accepts the cancel and keeps the run (server finding 13); still blocked on the fix branch (finding 13) |
| PRC-021 |
Step errors: user-facing messages directly, internal errors behind a detail toggle, Close |
pass |
pass |
userFacingError shown; TUI: failure message shown; F5 re-runs |
| PRC-022 |
Retry after an error restarts with the original record selection |
n/a |
pass |
retry is re-running the command; TUI: F5 or r runs again with the same records |
| PRC-023 |
Completion: Next/Submit labels, Return on the last screen or when noMoreSteps |
n/a |
pass |
screen labels; TUI: Ctrl+S continues; the last screen closes with Enter or Esc |
| PRC-024 |
Linear stepper and step position |
n/a |
pass |
stepper; step names printed; TUI: step list with marks |
| PRC-025 |
RECORD_LIST paging and page size over process records |
pass |
pass |
GET …/records paged into a table, --record-limit; TUI: RECORD_LIST pages with n / p through getProcessRecords (unit-tested only) |
| PRC-026 |
Validation review: input count, validate-or-skip choice, Next/Submit label, record preview |
pass |
pass |
count and preview; asks validate or skip on a terminal, --validate / --skip-validation; Submit? after validation; TUI: validate or skip, then run |
| PRC-027 |
Full validation summary lines (OK, WARNING, ERROR) with record links |
pass |
pass |
status, count, message lines; TUI: summary lines colored by status |
| PRC-028 |
Process summary results after execution and persisted effects |
pass |
pass |
|
| PRC-029 |
Bulk edit: switched-on fields only, review and result |
pass |
pass |
qqq table bulk-edit -r ids/-w ... --set f=v --clear f (-i chooses fields): only the switched-on fields are sent (bulkEditEnabledFields), review, result; verified live on person; TUI: bulk edit: Space switches fields on, Enter sets typed values (picker, yes/no), review, result; live on person |
| PRC-030 |
Bulk delete: review, validation and result |
pass |
pass |
qqq table bulk-delete -r ids/-w ...: review with count and preview, validation, result; asks unless --yes (exit 2 without a terminal); verified live; TUI: bulk delete: review with count and preview, validation choice, confirm, result; live on person |
| PRC-031 |
Bulk insert: upload, column mapping, value mapping, profile, review preview and result |
pass |
pass |
qqq table bulk-insert --file x.csv: upload, column mapping (server suggestion cleaned per finding 26, --mapping document, --column/--default, -i), value mapping, review preview and validation, result; FLAT and TALL verified live; TUI: bulk insert: file navigator upload, column mapping grid, value mapping, review preview, result; live: 2 person rows from CSV (then deleted) |
| PRC-032 |
Bulk load mapping validation and Back through mapping and upload |
pass |
pass |
mapping checked before submit (unmapped field, unknown column, layout, WIDE repetition, key fields, repeated header); Back from mapping to upload and from review to mapping verified live with -i; TUI: mapping checked before Ctrl+S (kernel checkMapping), F4 back through mapping and upload (unit-tested only) |
| PRC-033 |
Bulk edit with a file matched by key fields |
pass |
pass |
qqq table bulk-edit --file x.csv --key id [--mapping]: rows matched by the key, value mapping; verified live on person; TUI: bulk edit with a file: key fields (k) from the server, mapping, review, result (unit-tested only) |
| PRC-034 |
Upload instructions HTML with downloadable template |
pass |
pass |
upload instructions printed as text; --template [flat/tall/wide] [--out] saves the data: templates; verified live; TUI: a: save the bulk insert template file(s) from the upload instructions; live on person (3 templates) |
| PRC-035 |
Named WIDGET fetched with the process UUID and values |
pass |
pass |
named widget with the process UUID and values, kernel render model; none in the sample, verified by tests; TUI: named WIDGET fetched with the process UUID and values, drawn from the kernel screen (unit-tested only) |
| PRC-036 |
Named composite WIDGET seeded from process values |
pass |
pass |
seeded from the process value of the widget name; TUI: composite widget blocks seeded from process values drawn as text (kernel screen; unit-tested only) |
| PRC-037 |
Ad hoc composite WIDGET: interpolation, conditional blocks, action buttons, submit-on-enter inputs |
pass |
pass |
ad hoc composite: ${} interpolation, conditional blocks left out, INPUT_FIELD blocks asked as step fields (submitOnEnter submits), BUTTON actionCodes offered as a choice (-v actionCode=…), controlCode buttons change only what shows; unit-tested (the sample has no ad hoc widget); TUI: ad hoc composite widgets: interpolation, conditional blocks hidden, INPUT_FIELD inputs (Enter submits when asked), BUTTON actionCode sent with the step (unit-tested only) |
| PRC-038 |
GOOGLE_DRIVE_SELECT_FOLDER screen keeps its other components working |
n/a |
n/a |
Google Drive is web-only |
| PRC-039 |
Google Drive folder selection through the Google Picker |
n/a |
n/a |
Google Drive is web-only |
| PRC-040 |
Reload mid-process starts a fresh run |
n/a |
n/a |
no reload; TUI: no reload in a terminal; F5 re-runs |
| PRC-041 |
Expired session mid-process returns to sign-in |
pass |
pass |
UNAUTHENTICATED exits 3 with the sign-in hint; TUI: a 401 shows the error; :signout and F9 sign in again |
| PRC-042 |
Process permission enforcement |
pass |
pass |
server-enforced; TUI: hidden processes are not offered; the server refuses the rest |
| PRC-043 |
Default process values from the link (defaultProcessValues) |
pass |
pass |
-v values seed every step; TUI: :process run P -v name=value seeds the values |
| PRC-044 |
Scanner-format screens: no heading or action bar, input blocks submit |
n/a |
pass |
scanner screens are interactive; TUI: scanner-format steps: no heading or step list, Enter in the input submits (unit-tested only; no sample scanner process) |
| PRC-045 |
State-machine step flow: repeated screens, no linear stepper |
pass |
pass |
the runner follows nextStep whatever the flow; TUI: the runner follows nextStep whatever the flow |
| PRC-046 |
Saved bulk load profiles: save, choose for a later load, delete |
pass |
pass |
qqq bulk-profile list/show/save/rename/delete [--edit], bulk-insert --saved and --save-profile; unit-tested and stub-server CLI tests: the sample has no saved-profile processes; TUI: P on the mapping screen: use, save, update, delete saved profiles (unit-tested only; the sample has none) |
| PRC-047 |
A run with no frontend screens completes with a completion screen |
pass |
pass |
completes on init |
| PRC-048 |
Process-field possible values load and search through the v1 API |
pass |
pass |
searchProcessPossibleValues |
| PRC-049 |
Processes run on the v1 process routes (upload, step, back step, records, metadata) |
pass |
pass |
v1 routes only; TUI: v1 process routes through the kernel |
| PRC-050 |
Processes the instance adds to every query and record screen (Material processNamesToAddToAllQueryAndViewScree |
n/a |
pass |
Material-specific; TUI: every process the metadata gives the table is in the bulk bar and F9 |
| PRC-051 |
Dependent possible values on a process screen: the choices follow the screen's other values |
pass |
pass |
dependent choices narrow after each answer; TUI: contingent picker narrows |
| PRC-058 |
Saved bulk load profile menu (Material SavedBulkLoadProfiles): new profile, update after the confirm, rename, |
pass |
pass |
bulk-profile save --replace prints the changes and asks (--yes), rename, delete; stub-server CLI tests (the sample has no saved-profile processes); TUI: update a saved profile after a confirm listing the changes (kernel diffMappings), new profile, delete (unit-tested only) |
| PRC-059 |
Saved bulk load profile ownership: yours vs shared with you, and only the owner may save, rename or delete a p |
pass |
pass |
profiles listed as yours, then shared by their owner; save over, rename and delete refused for a profile you do not own; stub-server CLI tests; TUI: profiles listed as yours or shared by their owner; update and delete only for the owner (unit-tested only) |
| PRC-060 |
Bulk load file mapping form fidelity: field help, column tooltips, repeated-header warning, header-row toggle |
pass |
pass |
-i lists columns with preview values and the step's field help, asks for the header row (--no-header), warns on repeated headers (only the first is read); header toggle and previews verified live, help and repeated headers unit-tested; TUI: mapping grid: field help of the row, column previews, required marks, repeated-header warnings, header row toggle h; live |
| PRC-061 |
Typed bulk load default values, searchable value mapping and the grouped, searchable Add Fields menu (Material |
pass |
pass |
defaults typed per field (--default f=label resolves possible values; yes/no booleans), value mapping by label or id with choices listed, -i add-fields list grouped by table; verified live (Dog/Cat to species ids, yes/no to booleans); TUI: typed defaults (picker for possible values, yes/no), searchable value mapping picker, searchable field source menu (unit-tested) |
| PRC-062 |
Composite INPUT_FIELD metadata editors share process validation and multipart submission |
n/a |
pass |
composite editors; TUI: composite INPUT_FIELD editors are step fields: required checks before sending, a BLOB input goes as a multipart file (unit-tested only) |
| PRC-063 |
INPUT_FIELD autofocus and trimmed Enter values on subsequent process screens |
n/a |
pass |
TUI: the first field has focus; behaviors trim on set |
| PRC-064 |
DATE_TIME process inputs display local time and submit UTC instants |
pass |
pass |
process values typed local, sent UTC; screens show the local zone; TUI: step DATE_TIME inputs edited in the local zone, sent as UTC (kernel datetime) |
| PRC-065 |
Configured Google Drive shared-folder selection and process submission |
n/a |
n/a |
Google Drive |
| PRC-066 |
INPUT_FIELD case behaviors preserve caret and submitted process values |
pass |
pass |
field behaviors applied before submit; TUI: field behaviors via FormSession |
| QRY-090 |
Column menu sorts, pins, opens a field filter and hides a column |
n/a |
pass |
saved views and column UI; TUI: s sorts, v hides, orders, sizes and pins columns, F6 filters; live on person |
| QRY-091 |
Column menu copies page or full query values in backend sort order |
n/a |
n/a |
saved views and column UI; TUI: clipboard copy of column values |
| QRY-092 |
Column chooser searches, groups, counts and marks changed layouts |
n/a |
pass |
saved views and column UI; TUI: v: / searches, columns grouped by table and join with shown counts, * marks changes; live |
| QRY-093 |
Last saved view and unsaved edits survive reopening and reload |
n/a |
pass |
no screen state to keep: views are opened by name; TUI: view settings (columns, widths, sort) persist per table |
| QRY-094 |
Counted quick views render and open their saved-view route |
pass |
pass |
saved-view list counts quick views with doCount (--counts counts all); unit-tested (no sample saved views); TUI: doCount views show their record counts in F9 Saved views (unit-tested only; no sample saved views) |
| QRY-095 |
A new query defaults to fifty rows per page |
n/a |
n/a |
saved views and column UI; TUI: page size follows the terminal height |
| QRY-096 |
A saved view reconciles removed fields and warns the user |
pass |
pass |
opening a view drops removed fields with Material's warnings on stderr; unit-tested (no sample saved views); TUI: opening a view drops removed fields and flashes the kernel warnings (unit-tested only) |
| QRY-001 |
Record list renders metadata labels and all records in the default primary-key-descending order |
pass |
pass |
default order by primary key |
| QRY-002 |
Pagination with Material page sizes and URL state |
pass |
pass |
--limit, --skip, --all; TUI: PgUp/PgDn, Ctrl+F/B, Home/End across pages |
| QRY-003 |
Column header sort cycles ascending, descending and default; sort kept in the URL |
pass |
pass |
--order, -field for descending; TUI: s cycles asc, desc, default |
| QRY-004 |
Column visibility and order persist per table |
pass |
pass |
qqq table columns [fields…/--reset]: kept per table in the config the TUI column chooser uses; table query defaults to them, --fields wins; verified live; TUI: v: columns on/off and order, kept per table in the config file |
| QRY-005 |
Column widths, density and card view |
n/a |
pass |
grid presentation; TUI: v: widths, fit or fill, zebra, density |
| QRY-006 |
Opening a record and returning keeps the query; refresh shows backend changes |
n/a |
pass |
TUI: Esc lands on the row last viewed, filter and page kept |
| QRY-007 |
A failed query reports the backend error with a retry |
pass |
pass |
error with code, status and trace id; TUI: error shown in the grid; F5 retries |
| QRY-010 |
Text operators match Material labels and backend semantics |
pass |
pass |
all operators and shorthand; text matches (~, CONTAINS, STARTS_WITH, …) carry CASE_INSENSITIVE by default, ~= / OPERATOR:CS / --case-sensitive match case (finding 11 is by design; the v1 route drops the option until finding 27, qqq#1358); TUI: operators by field type in the filter dialog; text matches ignore case (CASE_INSENSITIVE), Match exact case on request (live on fix branch 8bf6a5a66) |
| QRY-011 |
Number operators including ranges and lists |
pass |
pass |
BETWEEN, IN lists |
| QRY-012 |
Date operators and relative date expressions |
pass |
pass |
now(), now(-7d), thisPeriod(), startOf(); TUI: date presets: now(-7d), thisPeriod(month) … |
| QRY-013 |
Date-time operators convert local input to UTC and support relative values |
pass |
pass |
--where/--group DATE_TIME values local to UTC (a date is local midnight); expressions as before; TUI: DATE_TIME criteria typed in the local zone go out as UTC instants; expressions pass through (unit-tested) |
| QRY-014 |
Boolean, blob and long-text operators |
pass |
pass |
IS_BLANK, TRUE, FALSE; TUI: TRUE/FALSE/EQUALS on booleans, blank tests, text operators on long text |
| QRY-015 |
Possible-value selectors for table and enum sources show labels and send ids |
pass |
pass |
labels in --where/--group for possible-value fields resolved to ids (speciesId = Cat sends 2; unknown or ambiguous labels exit 2 with the choices); verified live; TUI: labels in the picker, ids sent; typed labels resolved |
| QRY-016 |
AND/OR and nested groups combine as declared |
pass |
pass |
--group with parentheses; TUI: AND/OR and groups, guided and advanced |
| QRY-017 |
Filters live in the URL: reload, back/forward and Material-style JSON links |
pass |
n/a |
--print-filter gives the JSON the web links accept; TUI: URL state is browser-only; the TUI shows the grammar and the CLI command, and qqq ui accepts the command as a route |
| QRY-018 |
Backend-only operators from links render and filter correctly |
pass |
pass |
any operator in --where; TUI: More operators… offers every operator |
| QRY-019 |
Quick search combines with the advanced filter |
pass |
pass |
--search on query, count and export: CONTAINS over the shown text fields, ORed, ANDed with the filter; sent with CASE_INSENSITIVE (--case-sensitive to match case; the v1 route drops the option until finding 27, qqq#1358); TUI: q quick search ANDed onto the filter (kernel); q avery finds Avery (CASE_INSENSITIVE); =Text matches exact case (live on fix branch 8bf6a5a66) |
| QRY-020 |
One-side exposed join: labelled columns, filters and sorts match SQL |
pass |
pass |
--join and table.field in --fields/--where/--order, labelled "Join: Field"; verified live through an association join (person to pet); exposed joins unit-tested (the sample exposes none); TUI: joined columns and filters, labelled "Join: Field", joins planned by the kernel (unit-tested only; the sample exposes no joins) |
| QRY-021 |
Many-side exposed join repeats rows and reports the distinct count |
pass |
pass |
a many-side join repeats rows; count and --count add the distinct count (person --join pet: 21 rows, 16 distinct); TUI: many-side join: rows repeat and the status shows the distinct count (unit-tested only) |
| QRY-022 |
Column statistics aggregate the filtered rows |
pass |
pass |
qqq table stats [-w …] through the columnStats process when offered (unit-tested; the sample has neither QUERY_STATS nor the process); --local computes the same figures and was verified live; TUI: S: kernel column statistics of the column under the cursor with the filter (unit-tested only; no sample QUERY_STATS table) |
| QRY-023 |
Tables without QUERY_STATS offer no column statistics |
pass |
pass |
without QUERY_STATS (or the process) table stats exits 2 with the reason; --local is an explicit opt-in; TUI: the refusal says why |
| QRY-030 |
Selection menu: this page, full query result, first N, clear |
pass |
pass |
-r ids, --filter-json, --limit; TUI: Ctrl+A: this page, the full result, the first N, clear (unit-tested) |
| QRY-031 |
Bulk Edit launches with the checked record ids |
pass |
pass |
table bulk-edit -r ids; verified live; TUI: bulk edit on the checked records sends their ids; live: 2 person records edited and verified |
| QRY-032 |
Bulk Delete of the full query result sends the whole filter |
pass |
pass |
table bulk-delete -w ... (or --filter-json, --all-records) sends the whole filter; verified live; TUI: bulk delete of the selected/full result sends the filter; live: 2 person records deleted |
| QRY-033 |
First-N selection under a filter launches with that limit |
pass |
pass |
process run --filter-json with limit; TUI: run a table process on the first N records of the result (filter with a limit; unit-tested only) |
| QRY-034 |
Actions menu offers bulk load, bulk processes and table processes |
pass |
pass |
qqq table actions : bulk load, bulk edit/delete and the table processes with the command for each; verified live; TUI: a lists bulk insert, bulk edit with a file, bulk edit, bulk delete, the template and the table processes, with each CLI command; live |
| QRY-035 |
Viewers get no create, bulk or process actions and the backend refuses them |
pass |
pass |
server refuses; exit 3; TUI: F-keys and entries hidden without permission; the server refuses |
| QRY-040 |
CSV export has visible columns in order and exactly the filtered, sorted rows |
pass |
pass |
table export: filtered (--where, --group, --search), sorted (--order), --fields in column order, --limit, -o/--out - (-o is the output file on every command); TUI: x: visible columns, filter and sort, file dialog |
| QRY-041 |
XLSX and JSON exports carry the same rows |
pass |
pass |
csv, xlsx, json, tsv; format from --out extension; --no-header; bad format or field exit 2 before the request |
| QRY-042 |
Nothing to export disables the formats |
n/a |
pass |
nothing to disable; TUI: an empty result exports an empty file; the server decides |
| QRY-043 |
Backend refuses exports of unreadable tables |
pass |
pass |
server refuses; TUI: server refuses; the message is shown |
| QRY-050 |
Your saved views are listed and open on their own route |
pass |
pass |
qqq saved-view list , open , table query --view; unit-tested and stub-server tested (the sample has no saved views); TUI: F9 › Saved views lists and opens views (kernel; unit-tested only) |
| QRY-051 |
Saving a new view stores filter, sort, columns and page size |
pass |
pass |
saved-view save --name: filter, sort, columns and page size as the Material RecordQueryView; unit-tested and stub-server tested; TUI: save the current filter, sort, columns and page size as a view (unit-tested only) |
| QRY-052 |
Update, rename and delete your view |
pass |
pass |
saved-view save --replace, rename, delete (asks; --yes); unit-tested and stub-server tested; TUI: rename, update with the current query, delete (unit-tested only) |
| QRY-053 |
Duplicate names and unknown views are reported without changes |
pass |
pass |
a name in use is refused before any change; an unknown view exits 2 with the list; unit-tested and stub-server tested; TUI: server messages shown |
| QRY-054 |
A view shared with you opens read-only and the backend refuses changes |
pass |
pass |
views shared with you are listed as shared by their owner; changes to them are refused by the server, its message shown; unit-tested and stub-server tested; TUI: server refuses changes |
| QRY-060 |
Variant table asks for a variant, queries with it and remembers it |
pass |
pass |
--variant on query, count, get, copy, export, writes and process run; a terminal asks; the chosen variant is remembered per server and table (--variant - forgets it); stub-server tested (the sample has no variant table); TUI: the variant prompt before the first query; tableVariant on query and count (test) |
| QRY-061 |
Dismissing the variant prompt queries nothing; backend requires a variant |
pass |
pass |
no --variant, none remembered and no terminal (or no answer): exit 2, nothing queried; stub-server tested; TUI: dismissing queries nothing |
| QRY-062 |
A table without count, export or write capabilities offers none of them |
pass |
pass |
describe shows capabilities; server refuses; TUI: F-keys hidden without permission |
| QRY-063 |
Enum-backed Pet Species table is read-only |
pass |
pass |
server refuses writes; TUI: no write F-keys without permission |
| QRY-064 |
Backend refuses count and export for a table without those capabilities |
pass |
pass |
TUI: server refuses; shown |
| QRY-065 |
Export streams from the v1 export route |
pass |
pass |
POST /table/{t}/export |
| QRY-066 |
Variant options come from the v1 variants route |
pass |
pass |
GET /table/{t}/variants (called live; the sample lists none; the listing is stub-server tested); TUI: v1 variants route (kernel) |
| QRY-067 |
Go To opens a record by its primary key or a configured unique key (Material gotoFieldNames) |
pass |
pass |
table get --key; the primary key and Material gotoFieldNames are the declared keys, other fields looked up with a note; TUI: g |
| QRY-068 |
Default grid columns follow the table sections (section order, each field once), not the metadata field order |
pass |
pass |
default columns follow sections by tier |
| QRY-069 |
Pagination numbers are locale formatted in the shown range and the total |
n/a |
pass |
locale formatting; TUI: counts with en-US separators |
| QRY-070 |
Query screen keyboard shortcuts n (new record), r (refresh the query), f (open the filter builder) |
n/a |
pass |
shortcuts; TUI: n r f s and the F-keys; off with keyboard.singleKeyShortcuts |
| QRY-071 |
Processes launched from a variant table run with the chosen variant (tableVariant on init and every step) and |
pass |
pass |
process run --variant (or the remembered one): tableVariant on init, every step and status; sent live, unit-tested (no variant table to observe); TUI: processes from a variant grid carry tableVariant through the runner (unit-tested only) |
| QRY-080 |
Basic mode displays default quick filters from table metadata and applies their criteria |
n/a |
pass |
quick filters UI; TUI: the filter dialog starts with the quick filter fields (defaultQuickFilterFieldNames, else T1); live on person |
| QRY-081 |
Add quick filter accepts metadata fields and remembers a chosen field |
n/a |
pass |
TUI: add a quick filter field; kept per table in the local view settings |
| QRY-082 |
Basic mode cannot simplify repeated or nested advanced conditions and explains why |
n/a |
n/a |
TUI: the guided builder shows every condition; no basic mode |
| QRY-083 |
Advanced query shows and removes individual conditions (Next inline editor) |
n/a |
pass |
TUI: guided builder edits and removes conditions |
| QRY-084 |
Sort picker changes field and direction; clearing filters requires confirmation and keeps the sort |
n/a |
pass |
TUI: sort in the builder; c clears |
| QRY-085 |
Weekday criteria use the metadata-enabled date function and ISO weekday values |
blocked |
pass |
weekday(field) IN 1,7 sends the WeekdayOfDate fieldFunction with ISO weekdays (--print-filter); the sample's H2 backend answers 500 (server finding 24, qqq#1355); TUI: weekday(birthDate) IN 1,7 returns its 2 people (live on fix branch 8bf6a5a66; on the released sample it fails, finding 24, qqq#1355) |
| QRY-086 |
Relative date presets expose their evaluated date and filter records |
pass |
pass |
expressions |
| QRY-087 |
Bulk pasted values become a multi-value filter |
pass |
pass |
IN lists; quoted values; TUI: IN takes a pasted comma list |
| QRY-088 |
Instance query help accompanies the bulk paste dialog |
n/a |
pass |
TUI: paste values split on commas, tabs, semicolons, new lines; the instance bulkAddFilterValues help shown (unit-tested only; the sample has no such help) |
| QRY-089 |
String filter input honors field case behavior from v1 metadata |
pass |
pass |
behaviors; TUI: behaviors applied to typed values |
| QRY-008 |
Phone card list: readable records, touch-sized selection, query selections and paging |
n/a |
n/a |
phone layout |
| QRY-009 |
Phone filter sheet fits the viewport, scrolls inside and manages focus |
n/a |
n/a |
phone layout |
| QRY-024 |
Column configuration is reachable and usable by touch on phones and tablets |
n/a |
n/a |
phone layout |
| QRY-036 |
Bulk actions launch from a phone card selection |
n/a |
n/a |
phone layout |
| QRY-055 |
Saved views and export menus fit the phone and are touch-sized |
n/a |
n/a |
phone layout |
| REL-001 |
Possible-value cells show the related record label and link to it |
pass |
pass |
display values; table get shows the target (Avery Sample → person 1), --links lists them, --follow opens one; TUI: labels with ↗ links in the record view; l opens a grid cell's linked record; live |
| REL-002 |
Parent lists exactly its own children; View All opens the filtered child list |
pass |
pass |
table get --associations lists exactly the record's children; table children pages a list with its count (View All); TUI: child lists; F9 Query all opens the filtered list |
| REL-003 |
Adding a child from its parent links it and shows it immediately |
pass |
pass |
table create --parent table=pk; table get --associations shows it at once; TUI: F7 on a child list prefills the parent |
| REL-004 |
Three-level associations: each pet shows only its own notes |
pass |
pass |
person > pets > notes: each pet lists only its own notes; TUI: child lists three levels deep (a pet's notes under the pet); live on person 1 |
| REL-005 |
Editing and deleting a child leaves no stale parent, list or unexpected rows |
pass |
pass |
records are never cached: update or delete a child, the next get/children shows the current rows; TUI: the parent reloads on return |
| REL-006 |
Denied child reads show an unavailable panel without data or actions |
pass |
pass |
unreadable child tables shown as unavailable without data or actions; table children shows the server message; unit-tested (the sample has no denied child table, finding 17); TUI: unavailable panel (kernel associationGroups) |
| REL-007 |
Aliased and composite associations bind to their widgets and list the right members |
pass |
pass |
aliased and composite associations bound to their widget sections, members by every join value; unit-tested (the sample declares none, finding 17); TUI: kernel associationGroups binds aliased associations to their widgets; adornmentLab tags through the composite association (live on fix branch 8bf6a5a66) |
| REL-008 |
Adding through a composite association stores every join value |
pass |
pass |
table create --parent sets every join value of a composite association; unit-tested (the sample declares none); TUI: a new child through a composite association gets every join value; a new adornmentLab tag gets adornmentLabId and labKey (live on fix branch 8bf6a5a66) |
| REL-009 |
Deleting a parent removes associated children and leaves other parents intact |
pass |
pass |
table delete of a parent: its pets are gone, other parents keep theirs; TUI: server cascade; the list reloads |
| REC-001 |
Record view shows the record label, tiered sections and backend-formatted values |
pass |
pass |
table get by section and tier; TUI: sections by tier, two columns when they fit |
| REC-002 |
Empty values render a placeholder; hidden fields and hidden sections are never shown |
pass |
pass |
empty values show --; hidden sections and fields never shown; unit-tested (the sample has none, finding 17); TUI: hidden fields and sections are left out; empty values blank |
| REC-003 |
Record view of a missing record shows Record Not Found and a way back |
pass |
pass |
exit 5; TUI: error shown in the record pane |
| REC-004 |
Record view tabs and list view expose every visible section |
n/a |
n/a |
tabs; TUI: one scrolling view, no tabs |
| REC-005 |
Create form validates required fields in the browser before any request |
pass |
pass |
validated locally before any request; TUI: local validation by field |
| REC-006 |
Create persists the entered values and opens the new record |
pass |
pass |
TUI: new record replaces the form |
| REC-007 |
Backend enforces required fields when the UI is bypassed |
pass |
pass |
TUI: server message by field |
| REC-008 |
Cancel from create and edit, with the unsaved-changes guard |
n/a |
pass |
guard; TUI: Esc asks when there are unsaved changes; F10 warns too |
| REC-009 |
Edit loads stored values, saves only what changed, and shows the updated record |
pass |
pass |
update sends only changed fields; TUI: only changed fields sent |
| REC-010 |
Edit shows non-editable fields read-only and never submits them |
pass |
pass |
non-editable fields excluded; TUI: non-editable fields read-only |
| REC-011 |
Edit of a missing record shows the load failure instead of a form |
pass |
pass |
TUI: the load failure shows instead of the form |
| REC-012 |
Delete asks for confirmation, removes the record and returns to the list without errors |
pass |
pass |
confirm unless --yes; TUI: F8 asks; the grid moves on to the next record |
| REC-013 |
Copy prefills a new record from the source and saves it as a separate record |
pass |
pass |
qqq table copy [--set f=v] [-i] [--dry-run]: primary key, non-editable and file fields dropped; TUI: c: copyRecordValues |
| REC-014 |
STRING and TEXT editors round-trip single and multi-line text |
pass |
pass |
TUI: single-line text inline; multi-line through $EDITOR (Ctrl+E) round-trips |
| REC-015 |
INTEGER, LONG and DECIMAL editors keep exact values |
pass |
pass |
|
| REC-016 |
BOOLEAN editor applies the metadata default and saves true/false |
pass |
pass |
defaults applied; TUI: Space toggles |
| REC-017 |
DATE and TIME editors round-trip values and clearing |
pass |
pass |
|
| REC-018 |
DATE_TIME is entered and shown in the viewer's time zone and stored in UTC |
pass |
pass |
typed and shown in TZ, stored UTC, --utc for raw; DST edges tested; TUI: local zone in and out (kernel datetime) |
| REC-019 |
Zoned DATE_TIME display behaviors (fixed zone and per-record zone) |
n/a |
pass |
display zones; TUI: DATE_TIME through the kernel displayDateTime: server-zoned display values as sent, else the viewer's zone; live on Field Lab |
| REC-020 |
HTML field edits in the rich-text editor and renders sanitized |
pass |
n/a |
HTML fields shown as text (sanitized); table update -e edits the HTML source in $VISUAL/$EDITOR; verified live on fieldLab htmlValue; TUI: the rich-text editor is a browser component; HTML is edited as source in $EDITOR and shown as text |
| REC-021 |
PASSWORD is masked on read and never overwritten by the mask |
pass |
pass |
server masks; TUI: masked |
| REC-022 |
BLOB upload and download without a download adornment |
pass |
pass |
table create/update --upload and table download (base64 BLOB value) verified on fieldLab; default name into the download directory; TUI: BLOB upload through the file dialog and save from the record (Field Lab, live); upload into uploadedFileArchive (text primary key typed on create) and download of the same 22 bytes (live on fix branch 8bf6a5a66) |
| REC-023 |
Dynamic default values (user id, create day, modify day, explicit NONE) |
pass |
pass |
server; TUI: defaults applied by FormSession and the server |
| REC-024 |
Max-length policies: truncate, ellipsis, pass-through and reject |
pass |
pass |
maxLength checked locally; TUI: local check and server policy |
| REC-025 |
Case and whitespace normalization on save |
pass |
pass |
behaviors; TUI: behaviors on save |
| REC-026 |
Numeric range policies: reject, exclusive reject, inclusive clip and exclusive clip |
pass |
pass |
ranges checked locally; TUI: local range check and server policy |
| REC-027 |
Unique keys are enforced with the backend message on create and edit |
pass |
pass |
server message; TUI: server message shown |
| REC-028 |
LINK adornment: record links and URL links |
pass |
pass |
record links name table and key, --follow opens them; URL links show the URL; TUI: links marked, Enter follows (kernel record-view); adornmentLab carrier LINK (live on fix branch 8bf6a5a66) |
| REC-029 |
CHIP adornment colors and icons by value |
pass |
pass |
CHIP as [value] colored by color. (or colorMap) on a terminal, icon named in the record view; unit-tested (none in the sample); TUI: CHIP values bracketed and colored by the adornment color; adornmentLab CHIP [ACTIVE] in the grid and the record (live on fix branch 8bf6a5a66) |
| REC-030 |
SIZE adornment sets the query grid column width |
n/a |
pass |
TUI: saved widths per column; SIZE as text width; adornmentLab SIZE (live on fix branch 8bf6a5a66) |
| REC-031 |
CODE_EDITOR adornment: code view with formatting and a code editor on forms |
pass |
n/a |
CODE_EDITOR values shown verbatim; table update -e opens the code in $EDITOR with the language's extension; unit-tested (none in the sample; -e verified live on an HTML field); TUI: the code editor is a browser component; code is shown as text and edited in $EDITOR |
| REC-032 |
RENDER_HTML adornment renders sanitized HTML |
pass |
pass |
RENDER_HTML shown as sanitized text; unit-tested (none in the sample); TUI: RENDER_HTML shown as text with the markup stripped (kernel htmlToText); adornmentLab RENDER_HTML as text in the grid and the record (live on fix branch 8bf6a5a66) |
| REC-033 |
REVEAL adornment masks, reveals and copies the value |
pass |
pass |
REVEAL masked in the record view, query and child lists until --reveal; table get --copy copies the value (pbcopy/clip/wl-copy/xclip, else OSC 52); masking unit-tested, --copy verified live; TUI: masked; Enter reveals; adornmentLab REVEAL masked in the grid and the record (live on fix branch 8bf6a5a66) |
| REC-034 |
FILE_DOWNLOAD adornment links to the stored file with its name |
pass |
pass |
FILE_DOWNLOAD shows the file name and qqq table download saves it through the field route; unit-tested (none in the sample); BLOB values without the adornment are decoded locally (server finding 16); TUI: Enter saves through the save dialog; adornmentLab FILE_DOWNLOAD (live on fix branch 8bf6a5a66) |
| REC-035 |
FILE_UPLOAD adornment formats, replacing and removing a stored file |
pass |
pass |
create/update --upload field=path replaces the file, --set field= removes it (verified live on a BLOB); FILE_UPLOAD's format (button or drag and drop) is presentation only; TUI: FILE_UPLOAD fields choose a file; Backspace clears |
| REC-036 |
TOOLTIP adornment shows its text on the value |
pass |
pass |
tooltip text in parentheses after the value; unit-tested (none in the sample); TUI: tooltip text appended by valueText; adornmentLab TOOLTIP (live on fix branch 8bf6a5a66) |
| REC-037 |
WIDGET adornment renders the field value as the named widget |
pass |
pass |
the value rendered through the named widget's render model; unit-tested (none in the sample); TUI: a WIDGET-adorned field's value drawn as its widget; adornmentLab WIDGET field with a plain value shows the value (live on fix branch 8bf6a5a66) |
| REC-038 |
ERROR adornment highlights the value |
pass |
pass |
ERROR values marked with !; unit-tested (none in the sample); TUI: marked by valueText |
| REC-039 |
Field help content follows screen roles and formats |
pass |
pass |
table get --help-content: field help by view-screen role, HTML/MARKDOWN as text; qqq help show lists help alone; unit-tested (the sample has no help, finding 17); TUI: field help by screen role in F1 and in the form's field hint (unit-tested only) |
| REC-040 |
Section help content on the record view |
pass |
pass |
section help under the section with --help-content; unit-tested (finding 17); TUI: section help under the section heading and in F1 (unit-tested only) |
| REC-041 |
Table help content slots are delivered in table metadata |
pass |
pass |
table helpContent and helpContents slots printed with --help-content; unit-tested (finding 17); TUI: table help in F1 |
| REC-042 |
Audit history lists who changed what, newest first |
pass |
pass |
qqq audit list [--asc]: newest first with field changes; node tests and a stub server (the sample audits no table); TUI: A: audits newest first, who, when, what, changes (unit-tested only; the sample has no audit source) |
| REC-043 |
Audit history without process permission reads the audit table |
pass |
pass |
without the audit process the audit table is read with its auditTable and auditDetail joins; node tests; TUI: without the audit process the kernel reads the audit table (kernel-tested; the TUI uses it) |
| REC-044 |
Record label format is used for the record's title and dialogs |
pass |
pass |
recordLabel |
| REC-045 |
Possible-value editor shows stored labels, looks up defaults and selects by keyboard |
pass |
pass |
labels resolved, defaults looked up; TUI: picker by keyboard |
| REC-046 |
Read-only persona sees no write actions and the backend refuses writes |
pass |
pass |
server; TUI: write keys hidden without permission; server refuses |
| REC-047 |
Forms are labelled and keyboard operable |
n/a |
pass |
TUI: keyboard only, labels on every field |
| REC-048 |
Server validation errors show the backend message once and keep the form |
pass |
pass |
fieldErrors by field; TUI: fieldErrors by field |
| REC-049 |
pages of a table outside the app tree use the table label in the document title and breadcrumbs |
n/a |
pass |
TUI: breadcrumb uses the table label |
| REC-051 |
Table-field possible values search and resolve through the v1 API |
pass |
pass |
|
| REC-050 |
Record create, view, edit and delete run on the v1 record routes |
pass |
pass |
|
| REC-056 |
Record view hash links: #audit, #/launchProcess={process} and #{section} anchors |
n/a |
n/a |
TUI: hash links |
| REC-057 |
Create presets from links: #/createChild= opens a child create dialog over the record; /create#/defaultValues= |
n/a |
pass |
TUI: :table create T --set parent=… and F7 on a child list |
| REC-052 |
Dependent possible values: a field whose filter uses ${input.otherField} offers only the choices matching the |
pass |
pass |
contingent fields; TUI: contingent fields wait and narrow |
| REC-053 |
Table developer view shows the API Docs & Playground section for the table's application APIs |
pass |
pass |
qqq table apis , api-doc (saved as JSON), api-call [path] (the playground: sends the request with your session, prints status and answer); none in the sample (verified: none listed), api-call stub-server tested; TUI: D on a grid: the table's APIs and their OpenAPI documents, view or save (unit-tested only) |
| REC-054 |
Record developer view manages associated scripts: versions, new versions, test runs, logs, docs and script cre |
pass |
pass |
qqq script list/show [--revision]/store --file/--editor/test -v input=…/logs, and table developer (panels verified live on person 1); scripts and test runs stub-server tested (the sample has no associated scripts or testScript process); TUI: D on a record: panels (live), scripts, revisions, code, logs, store a new version (unit-tested) |
| REC-055 |
Record view keyboard shortcuts n, e, c, d, a (Material) and their help text |
n/a |
pass |
TUI: n e c d; F-keys |
| REC-058 |
Record view on phones and tablets: the title stays readable, the header controls wrap onto their own row, and |
n/a |
n/a |
TUI: phone layout |
| REC-059 |
Record forms on phones and tablets: every editor type fits without sideways scrolling, controls are touch-size |
n/a |
n/a |
TUI: phone layout |
| REC-061 |
An editable dynamicForm widget on a record form validates its fields and persists them in the declared JSON re |
pass |
pass |
qqq table widget-form --set/-i: the dynamicForm's fields validated (required) and saved in its merged JSON field (or as record fields); stub-server tested (the sample has no dynamicForm); TUI: record view: a dynamicForm widget section has "Edit these fields": FormEditor editors, required checked, saved into the named JSON field or record fields (unit-tested only) |
| REC-062 |
Inline enum possible values filter by label prefix without a lookup request; CHIP adornments style options and |
pass |
pass |
inline enums; TUI: inline enums filter locally |
| REC-060 |
Material table and field form adjusters and field rules operate against the real QQQ sample server |
pass |
pass |
form adjusters (onLoad, onChange) and field behaviors run through the kernel FormSession for create, update and copy; unit-tested (the sample declares none); TUI: form adjusters run on change through FormSession (unit-tested only; the sample has none) |
| REC-064 |
Record sections render qualified fields from readable exposed joins |
pass |
pass |
table get --join adds joined fields (queryJoins); verified live through an association join; exposed-join sections unit-tested; TUI: section fields of readable exposed joins read through a joined query (unit-tested only) |
| REC-063 |
Record view, edit and copy load from the table variant selected on the query screen |
blocked |
pass |
get, copy and update -i read with --variant; the v1 insert, update and delete routes ignore it (server finding 19, qqq#1351); TUI: records and forms opened from a variant grid read with tableVariant (unit-tested only; writes ignore it, finding 19) |
| REC-065 |
Unchanged DATE_TIME instants and precision survive edit and copy |
pass |
pass |
an unchanged wall-clock time keeps the original instant and its precision; TUI: DATE_TIME edited in local zone, unchanged instants kept |
| SEC-001 |
Table hidden from a user (DenyBehavior.HIDDEN): absent from navigation, direct link loads nothing, backend ref |
pass |
pass |
TUI: a hidden table is not in the metadata: absent from the tree, palette and index; a direct :table query names no such table and loads nothing (unit-tested only) |
| SEC-002 |
Table disabled for a user (DenyBehavior.DISABLED): listed, but list/record/create/edit links explain the denia |
pass |
pass |
a DISABLED table (permissions false in the metadata) is listed by table list with the reason; query, get, create, edit, delete, export and bulk commands refuse with it (exit 3) before any request; stub-server tested (the sample has no DISABLED table); TUI: a disabled table (hasPermission false) is listed with "(no access)"; opening it explains the denial and requests nothing (unit-tested only) |
| SEC-003 |
Insert permission denied: create not offered, create link refused, backend writes nothing |
pass |
pass |
TUI: F7 hidden without insert permission |
| SEC-004 |
Edit permission denied: edit not offered, edit link refused, backend changes nothing |
pass |
pass |
|
| SEC-005 |
Delete permission denied: delete not offered on record or bulk bar, bulk delete refused, backend deletes nothi |
pass |
pass |
|
| SEC-006 |
Copy requires insert permission: copy not offered and copy link refused |
pass |
pass |
table copy needs insert permission: refused with the reason (exit 3) before reading the record; stub-server tested; TUI: copy disabled with the reason without insert permission; c and :table copy are refused (unit-tested only) |
| SEC-007 |
Process permission denied (hidden): processes not offered in navigation or launcher, links do not start them, |
pass |
pass |
TUI: a hidden process is not offered (tree, palette, actions) and :process run names no such process (unit-tested only) |
| SEC-008 |
Process disabled for a user (DenyBehavior.DISABLED): shown disabled, link explains the denial, backend refuses |
pass |
pass |
a DISABLED process (hasPermission false) is listed by process list and table actions with the reason; process run refuses (exit 3) before init; stub-server tested; TUI: a disabled process is listed "(no access)" and refused with the reason; table actions show it disabled (unit-tested only) |
| SEC-009 |
Widget restrictions: hidden widgets absent, disabled widgets show a permission state without loading data, bac |
pass |
pass |
widget get shows the refusal; TUI: hidden widgets are absent; a disabled widget shows the permission state without a request; children of a parent skip denied ones (unit-tested only) |
| SEC-010 |
App restrictions: hidden apps absent from navigation and unknown by link; disabled apps keep their children ga |
pass |
pass |
TUI: hidden apps are absent and unknown by name; a disabled app explains the denial (unit-tested only) |
| SEC-011 |
Record-level security (sharing demo): users see only their own or shared saved views/reports; direct links and |
pass |
pass |
server-enforced: saved views (and bulk load profiles) are listed as the server returns them, yours first, others as shared by their owner; changing someone else's is refused locally or by the server; stub-server tested; TUI: saved views and reports: the TUI lists what the server returns; sharing through the share dialog; a refused direct link shows the server message; sharing demo: the owner sample:alice shares her saved report (live on fix branch 8bf6a5a66) |
| SEC-012 |
Record security lock on a data table: list filtered to the key, other users' records unreachable, forged owner |
pass |
pass |
server; TUI: record security is server-side: grids show the server's rows; a record the server refuses shows its message (403); adornmentLabLocker 2 answers Permission denied, shown on the record screen (live on fix branch 8bf6a5a66) |
| SEC-013 |
Field protection: hidden fields never shown or returned, password fields masked and never overwritten by the m |
pass |
pass |
server; TUI: hidden fields never shown (grid, record, form); PASSWORD values masked; edits send only changed fields, never the masked value (unit-tested only) |
| SEC-014 |
Capability restrictions: tables without insert/update/delete capabilities offer none of them and refuse direct |
pass |
pass |
TUI: without TABLE_INSERT/UPDATE/DELETE capabilities the F-keys, menu entries and copy are off and n/e/d are refused (unit-tested only) |
| SEC-015 |
Permission revoked mid-session: stale UI actions are refused by the backend with a clear message, nothing is w |
pass |
pass |
TUI: a save refused mid-session keeps the form with what was typed and shows the server message (unit-tested only) |
| SEC-020 |
MOCK sign-in: a deep link establishes the session and shows the session user from manageSession values |
pass |
pass |
qqq login on a MOCK server; TUI: MOCK session, shared with the CLI keyring |
| SEC-021 |
Logout: POST /qqq/v1/logout ends the session, protected pages stay on login, Sign in returns to the page, per- |
pass |
pass |
qqq logout calls POST /logout; TUI: F9 Sign out |
| SEC-022 |
Session expiry: 401 redirects to login with returnTo and re-authenticates back to the page (initial load and m |
pass |
pass |
exit 3 with the sign-in hint; TUI: a 401 mid-use opens sign-in on top of the screens; after signing in the same screen is back and refreshed (unit-tested only) |
| SEC-023 |
Denied sign-in: a 401 from manageSession keeps the user out with an explanation (no silent anonymous fallback) |
pass |
pass |
TUI: a refused sign-in (TABLE_BASED 401) shows the reason, stores nothing, no anonymous fallback (unit-tested only) |
| SEC-024 |
Post-login returnTo is limited to in-app paths (open-redirect guard) |
n/a |
n/a |
|
| SEC-025 |
OAUTH2 authorization code + PKCE sign-in with an owned OIDC provider (discovery, authorize, callback, backend |
pass |
pass |
device flow and --browser (code + PKCE, loopback) verified against a sample on OAUTH2 with qqq-dev-idp; TUI: OAUTH2 sign-in in the browser: discovery, S256 PKCE authorize address shown, loopback callback, code exchanged with the verifier; device flow as the alternative (unit-tested only) |
| SEC-026 |
OAUTH2 sign-in failures: provider denial, tampered state and failed code exchange are reported and create no s |
pass |
pass |
denial, forged state and a refused code exchange exit 3 and save nothing; the token is checked against the server first; TUI: tampered state, provider denial and a refused code exchange are reported and store nothing (unit-tested only) |
| SEC-027 |
OAUTH2 logout: backend session deleted, provider end-session called, next visit requires provider sign-in |
pass |
pass |
logout --provider-logout: refresh token revoked (RFC 7009), end-session URL opened; bearer sign-ins have no server session; TUI: sign out: here, or also revoke the refresh token and open the provider end-session address (unit-tested only) |
| SEC-028 |
OAUTH2 session revoked server-side mid-use: 401 sends the user through the provider and back to the page |
pass |
pass |
a refresh the provider refuses exits 3 with sign in again; refresh before expiry verified; TUI: a 401 after the refresh opens sign-in (browser or device) on top and returns to the refreshed screen (unit-tested only) |
| SEC-029 |
AUTH_0 authorization code + PKCE with an owned Auth0-compatible provider (browser token exchange, backend JWT |
blocked |
pass |
qqq login on an AUTH_0 server: tenant from values.baseUrl, values.nativeClientId (else clientId), the audience sent so the token is a JWT; device flow and --browser (PKCE) unit-tested; no AUTH_0 server to run against: the sample configures only OAUTH2 (server finding 28, qqq#1359); TUI: AUTH_0: authorize at baseUrl with the audience (PKCE), code exchanged at /oauth/token, the token handed to manageSession, the session kept; sign-out offers v2/logout (unit-tested only) |
| SEC-030 |
AUTH_0 against a real Auth0 tenant |
blocked |
blocked |
same sign-in as SEC-029; a real Auth0 tenant needs tenant credentials from James (qqq-cli#10; server finding 28, qqq#1359); TUI: needs a real Auth0 tenant: qqq-cli#10; the sample has no AUTH_0 configuration (qqq#1359, finding 28); the Auth0 protocol path is SEC-029 |
| SEC-031 |
FULLY_ANONYMOUS authentication: session without an identity provider, anonymous identity, logout and sign-in a |
pass |
pass |
|
| SEC-032 |
Unsupported authentication type (a type this UI does not know, as a newer backend could declare) is reported, |
pass |
pass |
unknown type refused; TUI: unknown type refused with a message |
| SEC-033 |
Server-side logout invalidation: v1 logout expires every session cookie it issued and an ended Auth0 session c |
n/a |
n/a |
|
| SEC-034 |
TABLE_BASED sign-in: a deep link asks for username and password under the app branding, POST /qqq/v1/manageSes |
pass |
pass |
qqq login --username (password asked, or QQQ_PASSWORD): HTTP Basic once, the server's sessionId cookie kept, never the password; stub-server tested (the sample uses MOCK, so it cannot exercise TABLE_BASED; finding 8 is the missing manageSession recipe); TUI: TABLE_BASED: username then password (masked) under the app name, POST manageSession with Basic credentials, the session cookie kept, the password never stored (unit-tested only) |
| SEC-035 |
TABLE_BASED sign-in failure: a wrong password or unknown user is refused with one message, stores no session, |
pass |
pass |
a wrong password or unknown user: one message (the server's), exit 3, nothing stored; stub-server tested; TUI: a wrong password or unknown user: one message, no session stored, Enter tries again (unit-tested only) |
| SEC-036 |
TABLE_BASED session expiry: a session idle past the inactivity timeout gets a 401, the user signs in again and |
pass |
pass |
an expired or idle session answers 401: exit 3 with 'Sign in again with qqq login'; stub-server tested; TUI: an expired session gets a 401: sign-in on top, then back to the refreshed screen (unit-tested only) |
| SEC-037 |
TABLE_BASED logout: POST /qqq/v1/logout deletes the stored session and clears both cookies, protected pages st |
pass |
pass |
qqq logout calls POST /qqq/v1/logout with the sessionId cookie and forgets the sign-in; later commands are unauthenticated; stub-server tested; TUI: sign out sends POST /logout with the session cookie, forgets the sign-in and shows sign-in (unit-tested only) |
| SEC-038 |
Dashboard documents carry a strict Content-Security-Policy (script-src self plus the hash of each inline scrip |
n/a |
n/a |
browser security |
| SEC-039 |
The policy allows the configured identity provider origin (OAUTH2 discovery, AUTH_0 browser token exchange) an |
n/a |
n/a |
browser security |
| SEC-040 |
Application override hook and metadata-derived origins: the application adds its own origins (QApplicationJava |
n/a |
n/a |
browser security |
| SEC-041 |
The login page explains known sign-in error codes and never displays text taken from the link |
n/a |
n/a |
browser security |
| SEC-042 |
Rendered HTML (field values, widgets, process steps, help, banners) cannot add forms, form controls, style she |
n/a |
n/a |
browser security |
| SEC-043 |
Per-user browser data (recently viewed records, stored identity) is bound to the signed-in identity |
n/a |
n/a |
browser security |
| SEC-044 |
Session cookies (sessionUUID, sessionId) are SameSite=Lax for the whole site, and Secure when the request arri |
n/a |
n/a |
browser security |
| SEC-048 |
Session cookies (sessionUUID, sessionId) are HttpOnly: script in the page cannot read them, and resuming a ses |
n/a |
n/a |
browser security |
| SEC-049 |
With HttpOnly session cookies the backend ends and replaces sessions: logout expires both cookies, an idle-exp |
n/a |
n/a |
browser security |
| INT-001 |
Keyboard: navigate from the sidebar to a list, open a record, edit and save without a pointer |
n/a |
pass |
browser accessibility and layout; TUI: keyboard only by design |
| INT-002 |
Keyboard: run a process through its steps without a pointer |
n/a |
pass |
browser accessibility and layout |
| INT-003 |
Dialogs trap focus, close on Escape and restore focus to the trigger; confirm by keyboard |
n/a |
pass |
browser accessibility and layout; TUI: modal dialogs, Esc closes |
| INT-004 |
Command menu, search and shortcut dialogs: keyboard open, focus inside, Escape restores focus |
n/a |
pass |
browser accessibility and layout |
| INT-005 |
Automated accessibility scan (axe WCAG 2.1 AA) of login, dashboard, list, record, edit form and process step |
n/a |
n/a |
browser accessibility and layout |
| INT-006 |
Form labels and ARIA: every field has an accessible label, required fields are marked, invalid fields announce |
n/a |
n/a |
browser accessibility and layout |
| INT-007 |
Validation and error messages: client and backend validation name the field and nothing is saved |
pass |
pass |
field named in every message |
| INT-008 |
Responsive layout at phone width (Pixel 7): navigation drawer, list, record and form usable without horizontal |
n/a |
n/a |
browser accessibility and layout |
| INT-009 |
Loading states: a delayed list or record request shows a busy state, then the real data |
n/a |
pass |
browser accessibility and layout; TUI: loading lines |
| INT-010 |
Failed request and recovery: a failed list request shows an error with retry; retry loads the data |
pass |
pass |
exit 4 and a message; rerun; TUI: F5 retries |
| INT-011 |
Delayed save: the submit control is disabled while saving and double submission creates one record |
n/a |
n/a |
browser accessibility and layout |
| INT-012 |
Stale state: changes and deletions made elsewhere are shown after refresh/navigation, not stale cache |
pass |
pass |
no client cache of records; TUI: F5 and on return |
| INT-013 |
Empty state: a query with no results explains it and offers the create action |
pass |
pass |
(no records); TUI: no records explains it and offers F7 when the user may create; live |
| INT-014 |
Backend unavailable at sign-in: the login page explains the failure and recovers with Try again |
pass |
pass |
cannot reach the server; TUI: sign-in screen shows the failure |
| SEC-050 |
Optional QA capture (Jam, qbit-qa-capture qa-capture extension): Jam loads only for enabled users; Report a bu |
n/a |
n/a |
browser security |
| WID-001 |
alert widget: severity from alertType, sanitized HTML and bullet list |
pass |
pass |
rendered as text |
| WID-002 |
barChart widget: one bar per label in backend colors |
pass |
pass |
rendered as text; TUI: bars in block characters |
| WID-003 |
chart output from an untyped widget renders as a bar chart |
pass |
pass |
rendered as text; TUI: a payload with chartData and no type is drawn as a bar chart (unit-tested only) |
| WID-004 |
divider widget renders a rule without card chrome |
pass |
pass |
rendered as text |
| WID-005 |
fieldValueList widget: labels, display values, prefix icons, indentation |
pass |
pass |
rendered as text; TUI: fieldValueList: labels, display values, prefix icon marks, indentation; empty state (unit-tested only) |
| WID-006 |
generic widget renders its common payload fields (sublabel, footer) |
pass |
pass |
generic: its html as text, plus label, sublabel and footer; unit-tested (none in the sample); TUI: generic widget: label, sublabel, text from HTML, footer (unit-tested only) |
| WID-007 |
horizontalBarChart widget: horizontal bars with negative values left of zero |
pass |
pass |
rendered as text; TUI: horizontal bars around a zero axis: negative values left, positive right; live structure in the fake dashboard (unit-tested only) |
| WID-008 |
html widget (no-code) renders sanitized user HTML |
pass |
pass |
rendered as text; TUI: html widget as text: tags and scripts dropped, links kept as text (unit-tested only) |
| WID-009 |
lineChart widget: line with a point per label and description |
pass |
pass |
rendered as text; TUI: sparkline and table |
| WID-010 |
smallLineChart widget: compact line with title and HTML description |
pass |
pass |
rendered as text; TUI: smallLineChart: title, HTML description as the subtitle, sparkline (unit-tested only) |
| WID-011 |
location widget: image, title, description, address and footer |
pass |
pass |
location: image link, title, description, address and footer text; unit-tested (none in the sample); TUI: location: image address, title, description, address, footer (unit-tested only) |
| WID-012 |
multiStatistics widget: groups with icon, header, subheader and statistics |
pass |
pass |
multiStatistics: groups with icon, header and subheader, statisticList values with separators (links shown); verified live on SampleMultiStatisticsWidget |
| WID-013 |
multiTable widget renders each table with its label and rows |
pass |
pass |
rendered as text; TUI: multiTable: each table with its label and rows (unit-tested only) |
| WID-014 |
pieChart widget: colored slices, legend values and subheader |
pass |
pass |
rendered as text; TUI: percentage bars |
| WID-015 |
quickSightChart widget embeds the provider URL (real renderer, owned local provider endpoint) |
pass |
n/a |
prints the URL; TUI: embedding the QuickSight dashboard needs a browser frame; the TUI shows its address to open |
| WID-016 |
statistics widget: count, context, colored percentage change and links |
pass |
pass |
rendered as text |
| WID-017 |
stackedBarChart widget stacks datasets with colors and legend |
pass |
pass |
rendered as text; TUI: segments per dataset |
| WID-018 |
stepper widget: completed, current (with link) and upcoming steps |
pass |
pass |
rendered as text |
| WID-019 |
table widget: headers, rows, alignment and fixed totals row |
pass |
pass |
rendered as text |
| WID-020 |
usaMap widget plots each marker with name and coordinates |
pass |
pass |
usaMap: each marker with name and coordinates as a table, 'No locations to show' when none; unit-tested; TUI: usaMap: each marker with name and coordinates in a table, the count; the map itself is browser-only (unit-tested only) |
| WID-021 |
process widget runs the sample interactive process inline |
pass |
pass |
a process widget names its process; widget get --run runs it here with the widget's default values; stub-server tested (no process widget in the sample); TUI: process widget: Enter runs its process in the process screen with the payload default values (unit-tested only) |
| WID-022 |
parentWidget renders its children in a 12-column grid |
pass |
pass |
parentWidget: children loaded and shown in order, each sized n/12 (gridColumns; TABS as tab headings); unit-tested; TUI: parent widget: children loaded with the parent's selections, stacked (tabs layout: one tab at a time, switch from the menu) (unit-tested only) |
| WID-023 |
composite widget renders QQQ blocks (big numbers, up/down, links, tooltips) |
pass |
pass |
rendered as text; TUI: big numbers, up/down |
| WID-024 |
childRecordList widget without association binding lists joined child records |
pass |
pass |
rendered as text; TUI: childRecordList without an association: its rows and count from the payload (unit-tested only) |
| WID-025 |
customComponent widget loads its bundle and renders the named component |
n/a |
n/a |
customComponent is web-only |
| WID-026 |
cronUI widget shows the record's schedule expression, description and time zone |
pass |
pass |
cronUI: the record's cron expression, the payload's description and the time zone (widget get --record t=pk); 'No schedule set'; unit-tested; TUI: cronUI: the record's cron expression, the server description, the time zone; "No schedule set" (unit-tested only) |
| WID-027 |
dynamicForm widget shows labeled values from the payload |
pass |
pass |
dynamicForm: labeled values (display values first, or the merged JSON field); noFieldsMessage; unit-tested; TUI: dynamicForm: labeled values, required marks, the no-fields message (unit-tested only) |
| WID-028 |
dataBagViewer widget lists versions and shows the selected version contents |
pass |
pass |
dataBagViewer: the bag's versions newest first (current marked) and the current version's data as JSON; unit-tested; TUI: dataBagViewer: versions newest first (sequence, message, when, author) and the chosen version's contents pretty-printed (unit-tested only) |
| WID-029 |
pivotTableSetup widget shows, edits and clears the saved report's pivot definition |
pass |
pass |
qqq saved-report show prints the pivot definition (rows, columns, 'Sum of Total'); saved-report pivot sets it (--rows/--columns/--values FUNCTION:field) or --clear clears it; stub-server tested; TUI: pivotTableSetup: rows, columns, values shown; add rows/columns/values from the report columns; clear (unit-tested only) |
| WID-030 |
filterAndColumnsSetup widget shows the saved report's filter, sort and columns |
pass |
pass |
qqq saved-report show: filter (match all/any), sort and visible columns as the setup widget words them; stub-server tested; TUI: filterAndColumnsSetup: table, filter, sort and visible columns of the saved report (unit-tested only) |
| WID-070 |
filterAndColumnsSetup edits a saved report's filter, sort, columns and variable values through the host form |
pass |
pass |
qqq saved-report set: filter and sort (--where/--group/--order, ${variable.x} filter variables), visible columns (--columns), name; written to queryFilterJson/columnsJson as the setup does; stub-server tested; TUI: edit the report filter and sort in the TUI filter dialog and the columns in a chooser; saved to the record (unit-tested only) |
| WID-071 |
a WIDGET-adorned process form field renders filter setup and writes its own value |
pass |
pass |
a process field drawn by a filterAndColumnsSetup widget takes the filter grammar (-v field="a = 1 AND b > 2") and writes its QueryFilter JSON; stub-server tested; TUI: a WIDGET-adorned process field with a filter setup: Enter opens the filter dialog for the form's table and writes the filter JSON (unit-tested only) |
| WID-072 |
API-versioned report setup loads table metadata and previews through the application API |
pass |
pass |
qqq saved-report preview --api-path/--api-version queries and counts through the application API, as API-versioned setups preview; stub-server tested; TUI: API-versioned setup: fields from the application API metadata, preview rows and count through its query (unit-tested only) |
| WID-073 |
report setup editor uses the full server-backed grid for paging, sorting and column sizing |
pass |
pass |
qqq saved-report preview pages, sorts and counts on the server (-l, --skip, -o); columns fit their content (dragging widths is a browser grid control); stub-server tested; TUI: Preview opens the report filter in the full grid (server paging, sort, view settings) (unit-tested only) |
| WID-031 |
rowBuilder widget without association binding shows its rows read-only |
pass |
pass |
rowBuilder without association binding: its rows read-only in a table (declared fields, display values); unit-tested; TUI: rowBuilder without an association: rows read-only as a table (unit-tested only) |
| WID-032 |
scriptViewer widget lists script revisions and shows the selected revision's files |
pass |
pass |
scriptViewer: the script's revisions (current marked) and the current revision's files; unit-tested; TUI: scriptViewer: Enter opens the developer view of the script (revisions, files, logs) (unit-tested only) |
| WID-033 |
quickSightChart against a real AWS QuickSight account and dashboard |
n/a |
n/a |
QuickSight; TUI: a real AWS QuickSight dashboard is an embedded browser page |
| WID-040 |
dashboard renders app widgets in declared order sized by gridColumns (twelfths) |
pass |
pass |
apps show --widgets: app widgets in declared order, each marked with its width in twelfths (gridColumns); verified live; TUI: widgets in declared order, laid out side by side by gridColumns on wide terminals, v reorders; live |
| WID-041 |
widget chrome: card vs plain (isCard=false), sublabel, metadata and payload footer HTML |
pass |
pass |
chrome: a card widget's title framed (== label ==), plain (isCard=false) without; sublabel; payload or metadata footer HTML as text; unit-tested and verified live; TUI: label, sublabel, footer text or footer HTML as text; card vs plain is drawing only (unit-tested only) |
| WID-042 |
header icons (topLeftInsideCard/topRightInsideCard) with metadata colors |
n/a |
n/a |
card chrome |
| WID-043 |
widget label tooltip from metadata on hover and keyboard focus |
n/a |
n/a |
card chrome |
| WID-044 |
widget help content (HTML) on the label |
n/a |
n/a |
card chrome |
| WID-045 |
reload button re-renders the widget from the backend |
n/a |
n/a |
card chrome |
| WID-046 |
export button downloads the widget's csvData as CSV |
pass |
pass |
rendered as text; TUI: Export as CSV: the payload csvData (else the table rows) through the save dialog (unit-tested only) |
| WID-047 |
PVS dropdown from the widget payload: selection is sent as a parameter and re-renders |
pass |
pass |
--input name=value; TUI: payload dropdowns in the widget menu: the choice is sent as a parameter and the widget reloads (unit-tested only) |
| WID-048 |
DATE_PICKER dropdown sends the chosen date |
pass |
pass |
--input; TUI: DATE_PICKER dropdown: a date typed as YYYY-MM-DD is sent as the web sends it (M/D/YYYY) (unit-tested only) |
| WID-049 |
required dropdowns: the parent waits with the backend message until selections are made |
pass |
pass |
a widget waiting for a required dropdown shows the server's dropdownNeedsSelectedText in place of its body; selections given with --input name=id; unit-tested; TUI: required dropdowns: the server message shows until a choice is made, then the data loads (unit-tested only) |
| WID-050 |
storeDropdownSelections persists selections across reload; stale stored options are dropped |
n/a |
pass |
TUI: storeDropdownSelections: choices kept per widget in the shared config; a stale stored option is dropped (unit-tested only) |
| WID-051 |
failing widget renderer shows a contained error with the backend message and retry |
pass |
pass |
rendered as text; TUI: error contained to the widget |
| WID-052 |
empty payloads show descriptive empty states for every display type |
pass |
pass |
every display type shows the web's empty state (No rows found, No chart data available, No statistics available, …); unit-tested; TUI: empty states: no rows, no data to chart, no value, no values, no child widgets, no dashboard, no schedule (unit-tested only) |
| WID-053 |
malformed payloads are contained to their own widget |
pass |
pass |
unknown shapes shown raw |
| WID-054 |
widget permissions: a denied widget is absent from metadata, not rendered and not requested; the API denies it |
pass |
pass |
rendered as text; TUI: a denied widget is drawn with the permission state and never requested (unit-tested only) |
| WID-055 |
parent widget TABS layout switches tabs and remembers the selected tab |
n/a |
n/a |
card chrome |
| WID-056 |
parent widget skips denied and unknown children without requests |
pass |
pass |
parent widgets skip unknown and denied (hasPermission false) children without a request and say which; unit-tested; TUI: a parent widget skips denied and unknown children without requests (unit-tested only) |
| WID-057 |
composite renders every block type with its values and styles |
pass |
pass |
composite: TEXT (icons, alert/banner), NUMBER_ICON_BADGE, UP_OR_DOWN_NUMBER, TABLE_SUB_ROW_DETAIL_ROW, PROGRESS_BAR, DIVIDER, BIG_NUMBER, INPUT_FIELD, BUTTON, AUDIO, IMAGE, ICON, nested COMPOSITE, tooltips; unit-tested, BIG_NUMBER and UP_OR_DOWN verified live; TUI: composite blocks: TEXT, BIG_NUMBER, NUMBER_ICON_BADGE, UP_OR_DOWN_NUMBER, PROGRESS_BAR, DIVIDER, TABLE_SUB_ROW_DETAIL_ROW, INPUT_FIELD, BUTTON, IMAGE, AUDIO, ICON (unit-tested only) |
| WID-058 |
composite layouts and slot links/tooltips |
n/a |
n/a |
card chrome |
| WID-059 |
unsupported block type shows a contained warning |
pass |
pass |
rendered as text; TUI: an unsupported block type shows a contained warning (unit-tested only) |
| WID-060 |
record-view section widgets receive the record context (id, tableName) |
pass |
pass |
--input id=…; TUI: record section widgets get the record id and table (unit-tested) |
| WID-061 |
process widget for a persona without process permission is contained |
pass |
pass |
rendered as text; TUI: a process widget whose process the user may not run offers Run disabled with the reason (unit-tested only) |
| WID-062 |
custom component whose bundle cannot load shows a contained error |
n/a |
n/a |
card chrome |
| WID-063 |
alerts with hideWidget or without HTML render nothing |
pass |
pass |
TUI: an alert with hideWidget or without content draws nothing (unit-tested only) |
| RPT-001 |
TABLE report runs through its process and downloads CSV matching the database |
pass |
pass |
report run : through the report's process (reportName, reportFormat), the file from GET /download saved (--out-dir); stub-server tested (the sample has no reports); TUI: a report with a process runs its screens and saves the file it produces (CSV chosen) (unit-tested only) |
| RPT-002 |
TABLE report downloads XLSX with the same rows |
pass |
pass |
report run --format xlsx: the same process, the XLSX file as the server writes it; stub-server tested; TUI: XLSX chosen from the report formats; the server's file saved as is (unit-tested only) |
| RPT-003 |
TABLE report downloads JSON with the same rows |
pass |
pass |
report run --format json: the same process, the JSON file; stub-server tested (format path shared with csv/xlsx); TUI: JSON chosen from the report formats; the server's file saved as is (unit-tested only) |
| RPT-004 |
SUMMARY report groups rows with counts and a totals row |
pass |
pass |
SUMMARY reports: the server's grouped rows with counts and totals saved as sent (process or report route); stub-server tested; TUI: SUMMARY reports: the grouped file with totals is the server's; the TUI runs and saves it (unit-tested only) |
| RPT-005 |
PIVOT report produces a native pivot table in XLSX |
pass |
pass |
PIVOT reports: the server writes the native XLSX pivot; the CLI saves the file unchanged; stub-server tested; TUI: PIVOT reports: the XLSX pivot is the server's; the TUI runs and saves it (unit-tested only) |
| RPT-006 |
report input fields: required validation and the value filters the rows |
pass |
pass |
report input fields asked on a terminal or given with -v; a missing required one exits 2 naming it before the report runs; the value is sent to the step; stub-server tested; TUI: report input fields are the report process's form: required checks, values sent with the run (unit-tested only) |
| RPT-007 |
report permissions: restricted report denied in UI and by the server |
pass |
pass |
server; TUI: a restricted report is marked (no access) and refused with the reason; the server refuses too (unit-tested only) |
| RPT-008 |
reports appear in app navigation and open their run page |
pass |
pass |
reports listed by report list and under their app in apps show; report run opens them; stub-server tested; TUI: reports appear in app navigation and run from there (unit-tested only) |
| RPT-009 |
saved report view shows its filter/columns and pivot setup |
pass |
pass |
qqq saved-report show: filter, sort, columns and pivot setup; stub-server tested; TUI: saved report record: filter, sort, columns and pivot setup drawn; saved report Pet Species Report: filter, sort, columns, pivot (live on fix branch 8bf6a5a66) |
| RPT-010 |
saved report renders through renderSavedReport and downloads the saved columns and rows |
pass |
pass |
qqq saved-report run [--format]: renderSavedReport with the record, the file downloaded; stub-server tested; TUI: the record actions list the table processes (renderSavedReport) and run them on the record; the DOWNLOAD_FORM file is saved (process downloads unit-tested only) |
| RPT-011 |
streaming report route for reports without a process |
pass |
pass |
report run on a report without a process (or --route) streams from GET /reports/{name}; stub-server tested; TUI: a report without a process streams from GET /reports/{name}?format= into the save dialog (unit-tested only) |
| RPT-012 |
scheduled report: create a schedule for a saved report and view its cron schedule |
pass |
pass |
qqq saved-report schedule --cron --time-zone --to [--format]; saved-report schedules lists them with the server's cron description; stub-server tested; TUI: scheduled report: created on its form; the record shows the cron schedule (cronUI) (unit-tested only) |
| RPT-013 |
sharing: the owner shares a saved report with a user (Read-Only) |
pass |
pass |
qqq share add savedReport user: --scope read-only (insertSharedRecord); stub-server tested; TUI: share a saved report with a user Read-Only (Z, :share); shared Pet Species Report Read-Only (live on fix branch 8bf6a5a66) |
| RPT-014 |
sharing: change a share's scope to Read and Edit |
pass |
pass |
qqq share scope savedReport read-write (editSharedRecord); stub-server tested; TUI: change a share to Read and Edit; changed to Read and Edit (live on fix branch 8bf6a5a66) |
| RPT-015 |
sharing: remove a share |
pass |
pass |
qqq share remove savedReport (asks; --yes); stub-server tested; TUI: remove a share after a confirm; removed the share (live on fix branch 8bf6a5a66) |
| RPT-016 |
sharing record security: another user cannot see an unshared report until it is shared |
pass |
pass |
server-enforced record security: saved-report list shows only what the server returns (yours, shared with you); stub-server tested; TUI: unshared reports are the server's to hide; the TUI lists what it returns and shows a refused link's message (unit-tested only) |
| RPT-017 |
sharing: only the owner may share |
pass |
pass |
only the owner may share: the server's refusal shown (exit 2); stub-server tested; TUI: only the owner may share: others see Share disabled with the reason (unit-tested only) |
| RPT-018 |
sharing a saved view through the share dialog |
pass |
pass |
qqq share … savedView : the same sharing processes for saved views; stub-server tested with saved reports; TUI: saved views share through the same dialog (Saved views menu) (unit-tested only) |
| WID-064 |
cronUI schedule editor on record forms: Basic days/hours/minutes, Advanced expression, live description, valid |
n/a |
n/a |
card chrome |
| WID-065 |
record view mounts only the active layout, so each section widget mounts and loads once |
n/a |
n/a |
card chrome |
| WID-066 |
Widget metadata and widget data come from the v1 API |
pass |
pass |
TUI: widget metadata from /metaData and data from POST /qqq/v1/widget/{name} (unit-tested only) |
| WID-067 |
a widget whose payload is a single leaf block (Material block widget) renders that block |
pass |
pass |
a payload that is one leaf block renders that block; unit-tested; TUI: a payload that is one block draws that block (unit-tested only) |
| WID-068 |
table widget Material extras: typed cells (numbers with separators, html, htmlAndTooltip, image, composite), h |
pass |
pass |
table extras: hidden columns dropped, numbers with separators, html, htmlAndTooltip, image cells, composite cells, sub-rows, sticky last (totals) row, link and noRowsFoundHTML; unit-tested, sticky row verified live on SampleTableWidget; TUI: table cells typed: numbers with separators, html and htmlAndTooltip as text, images, composites (unit-tested only) |
| WID-069 |
chart widget Material extras: theme color names, legend toggles, single-series legends (horizontal bars, line |
n/a |
n/a |
theme colors |
| RPT-019 |
render report input step shows only its fields; a report without variables adds no no-fields message |
pass |
pass |
the render step shows only its fields (kernel screen model); a step without fields shows no 'no fields' message; unit-tested; TUI: a report input step shows only its fields; a step without fields continues with no message (unit-tested only) |
| RPT-020 |
Report files download from the v1 download and report routes |
pass |
pass |
report files come from GET /download (process reports) or GET /reports/{name} (route); stub-server tested; TUI: report files download from the report route and the process DOWNLOAD_FORM (unit-tested only) |
| WID-074 |
Standalone composite scalar controls and metadata editors |
n/a |
pass |
standalone composite controls are browser input editors (caret, IME, widths) whose drafts stay on the page; the CLI shows the controls and their values (WID-057), and process-hosted inputs go through the form session (PRC-037); TUI: standalone composite INPUT_FIELD blocks show their seeded values read-only by type (no standalone input target in a terminal) (unit-tested only) |
| WID-075 |
Standalone DATE_TIME blocks localize seeded instants without losing seconds |
pass |
pass |
a seeded DATE_TIME input block is shown in the local zone with its seconds (kernel displayDateTime); unit-tested; TUI: standalone DATE_TIME blocks show seeded instants in the local zone with seconds (unit-tested only) |
| HLP-001 |
App and widget help |
pass |
pass |
qqq help show app/widget/instance; unit-tested (the sample carries no help content, finding 17); TUI: F1 on an app home: app help and each widget's help (slot maps) (unit-tested only) |
| HLP-002 |
Table, field and section help |
pass |
pass |
qqq help show table [field]: table, section and field help; unit-tested (finding 17); TUI: table, field and section help by screen role in F1 (unit-tested only; the sample has none); F1 on adornmentLab: table and section help (live on fix branch 8bf6a5a66) |
| HLP-003 |
Query columns and table action help |
pass |
pass |
field help is the column help; table action help slots printed with their slot name; unit-tested (finding 17); TUI: the grid footer shows the help of the column under the cursor; table help slots in F1 (unit-tested only) |
| HLP-004 |
Process, step and record action help |
pass |
pass |
qqq help show process : process, step, HELP_TEXT and step field help; unit-tested (finding 17); TUI: F1 on a process: process, step and step field help; on a record: table, section and field help for the view role (unit-tested only) |
| HLP-005 |
Help search |
pass |
pass |
qqq help-search; TUI: type in F1 |
| HLP-006 |
Help author affordance |
n/a |
pass |
author affordance; TUI: :helpkeys (F9 Help) turns on help-authoring mode: F1 shows every slot key, with or without content (unit-tested only) |