Files
james.maesandClaude Fable 5.1 1bc4ddd0be release: qqq 1.0.0 (#11)
qqq 1.0.0: the command-line client and the full-screen terminal UI (qqq ui) for QQQ applications over the UI API (/qqq/v1), with @qrun-io/qqq-cli 1.0.0, @qrun-io/qqq-core 1.0.0, @qrun-io/qqq-ui-api-client 1.8.0 and @qrun-io/qqq-ui-api-conformance 1.6.0 going final together. Squash of the release/1.0.0 branch at 79ba68e (the branch is kept with the full signed history; the tags v1.8.0 and cli-v1.0.0 point at that commit, which is what the released binaries were built from). See CHANGELOG.md [1.0.0] and docs/release-notes/1.0.0.md.

Co-Authored-By: Claude Fable 5.1 <noreply@anthropic.com>
2026-11-01 12:49:06 -06:00

94 KiB
Raw Permalink Blame History

Terminal clients parity matrix

Generated by scripts/parity-matrix.py from the Next UI acceptance matrix (qqq-frontend-next/docs/acceptance/feature-matrix.md, 401 rows). Same ids; two columns added. pass = verified against the local sample server in this repo's development; partial = works with the noted gap; todo = planned; n/a = browser-only, with the reason; blocked = needs a server change (the note cites the finding in docs/server-findings.md). "unit-tested" in a note: the sample has no fixture, so node tests (and stub-server CLI tests) verify it. The TUI column is qqq ui (M3); its notes start with "TUI:".

Summary (CLI column)

Family rows pass todo partial blocked n/a
HLP 6 5 0 0 0 1
INT 14 5 0 0 0 9
NAV 40 13 0 0 0 27
PRC 60 48 0 0 0 12
PRF 5 5 0 0 0 0
QRY 70 48 0 0 1 21
REC 65 53 0 0 1 11
REL 9 9 0 0 0 0
RPT 20 20 0 0 0 0
SEC 43 29 0 0 2 12
WID 69 55 0 0 0 14
all 401 290 0 0 4 107

Summary (TUI column)

Family rows pass todo partial blocked n/a
HLP 6 6 0 0 0 0
INT 14 10 0 0 0 4
NAV 40 20 0 0 1 19
PRC 60 55 0 0 1 4
PRF 5 5 0 0 0 0
QRY 70 61 0 0 0 9
REC 65 59 0 0 0 6
REL 9 9 0 0 0 0
RPT 20 20 0 0 0 0
SEC 43 30 0 0 1 12
WID 69 56 0 0 0 13
all 401 331 0 0 3 67

Rows

ID Feature CLI TUI Note
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)