OIM KB changelog

Generated from the project task ledger. It lists public site capabilities and pipeline improvements, not private credentials or raw proprietary script bodies.

51 updatesGenerated 2026-04-28T01:46:12.697Z

Add DB metadata change report

2026-04-28

Add generate-db-change-report.mjs for safe snapshot-to-snapshot DB metadata comparisons.
Publish db/changes.html and assets/oim-db-change-report.json.
Compare safe fingerprints for tables, SQL/sys modules, config parameters, DialogObjects, DialogScripts, and foreign keys.
Avoid publishing raw DialogScript.ScriptCode, raw DialogObject.MethodScript, raw SelectScript, or encrypted config values; config value deltas are shown only as valueChanged.
Wire DB change report into refresh, DB inventory navigation, homepage, API catalog, sitemap, and health checks.
Fix refresh ordering so status.html exists before sitemap/health checks and fix DB-page navigation links to use root-relative /db/changes.html.
Verify DB change report: 11,453 current objects with previous baseline; overall health 150 pass / 0 warn / 0 fail.

Routine parameter index

2026-04-28

Add scripts/generate-routine-parameter-index.mjs from read-only sys.objects / sys.parameters metadata already collected under data/db/all-objects/sys_objects.json.
Publish db/routine-parameters.html and assets/oim-routine-parameters.json covering 1,703 routines, 4,648 parameter declarations, 783 distinct parameter names, 330 output parameters, and 26 data types.
Add routine-parameter and routine-signature entries to the main search index and search UI filters.
Link routine parameters from homepage, API catalog, sitemap, llms.txt, asset manifest, refresh pipeline, and health checks.
Repair nested DB inventory DB changes links and verify public health: 150 pass / 0 warn / 0 fail.

Add column pattern guide

2026-04-28

Add generate-column-patterns.mjs for source-backed DB column browse groups.
Publish columns/patterns.html and assets/oim-column-patterns.json.
Cover UID identity/relation columns, X* audit/system columns, Ident/display columns, date/time columns, boolean/flag columns, outgoing/incoming FK columns, service-item columns, and target-system columns.
Link patterns from the column index and homepage, and add the JSON asset to API catalog.
Wire column-pattern generation into refresh-from-export.sh and health checks.
Verify column patterns: 9 pass / 0 warn / 0 fail; overall health 143 pass / 0 warn / 0 fail.

DB column index

2026-04-28

Add scripts/generate-column-index.mjs for grouped DB column names from read-only table/FK metadata.
Publish columns/index.html and assets/oim-column-index.json with occurrence counts, data types, nullability, identity flags, table links, and FK evidence.
Add column-index entries to the main search index and search UI filter labels/ranking.
Link the column index from homepage, API catalog, sitemap, refresh pipeline, and health checks.
Repair refresh ordering so pre-health reports have changes.html, provenance, and llms.txt available before linked/checking pages run.
Verify public /columns/index.html, column JSON, homepage link, and full health: 143 pass / 0 warn / 0 fail.

Add glossary

2026-04-28

Add generate-glossary.mjs for recurring OIM terms with source-backed entry points.
Publish glossary.html and assets/oim-glossary.json.
Cover DBQueue, ChangeLimit, AccProduct, PersonWantsOrg, DialogObject, DialogScript, ConfigParm, module/table graph terms, C# evidence terms, typed edges, and family prefixes.
Wire glossary into refresh, API catalog, homepage, sitemap, and health checks.
Verify glossary: 24 pass / 0 warn / 0 fail; overall health 138 pass / 0 warn / 0 fail.

Add custom 404 page

2026-04-28

Add generate-404-page.mjs for a helpful noindex 404 page with search and major navigation links.
Publish 404.html and wire it into refresh-from-export.sh.
Configure nginx error_page 404 /404.html while preserving real 404 status.
Reload oim-knowledgebase nginx after nginx -t.
Add health checks for local 404 page and public custom 404 behavior.
Verify health 137 pass / 0 warn / 0 fail.

Add family hubs

2026-04-28

Add generate-family-hubs.mjs for namespace/product-area browse hubs.
Publish families/index.html, per-family pages, and assets/oim-family-hubs.json.
Cover QBM, QER, ADS, LDAP, DPR, TSB, AER, ATT, CCC, and VI.
Wire family hubs into refresh, API catalog, homepage, sitemap, and health checks.
Verify family hubs: 10 pass / 0 warn / 0 fail; overall health 135 pass / 0 warn / 0 fail.

Add evidence coverage matrix

2026-04-28

Add generate-evidence-coverage.mjs for a public evidence coverage matrix.
Publish coverage.html and assets/oim-evidence-coverage.json.
Cover DB inventory, SQL context, C# context, reverse deps, graphs, config usage, DialogObject/DialogScript context, typed edges, search quality, publication safety, and crawl/status layers.
Wire coverage into refresh, API catalog, homepage, sitemap, and health checks.
Verify evidence coverage: 11 pass / 0 warn / 0 fail; overall health 134 pass / 0 warn / 0 fail.

Add publication safety report

2026-04-28

Add generate-publication-safety-report.mjs for public safety/audit evidence.
Publish safety.html and assets/oim-publication-safety.json.
Validate raw script field keys are absent from public JSON and raw DialogObject script snippets are not in DB/search public assets.
Validate encrypted config values are masked before publication.
Wire safety report into refresh, API catalog, homepage, sitemap, and health checks.
Verify safety report: 5 pass / 0 fail; overall health 133 pass / 0 warn / 0 fail.

Add query cookbook

2026-04-28

Add generate-query-cookbook.mjs for practical source-backed search recipes.
Publish cookbook.html and assets/oim-query-cookbook.json.
Cover DBQueue/ChangeLimit, IT Shop/AccProduct, DialogObjects, DialogScripts, config usage, C# evidence, module graphs, table graphs, and typed relation edges.
Wire cookbook into refresh, API catalog, homepage, sitemap, and health checks.
Verify cookbook recipes: 9 pass / 0 warn / 0 fail; overall health 132 pass / 0 warn / 0 fail.

Add search quality observability

2026-04-28

Add generate-search-quality-report.mjs with deterministic search fixture checks.
Publish search-quality.html and assets/oim-search-quality.json.
Cover ChangeLimit, DBQueue config, module graphs, table graphs, DialogObject, DialogScript, C# evidence, typed relation edges, and IT Shop queries.
Wire search quality into refresh, API catalog, homepage, sitemap, and health checks.
Verify search quality fixtures: 12 pass / 0 warn / 0 fail; overall health 131 pass / 0 warn / 0 fail.

Add build change reporting

2026-04-28

Add generate-build-diff.mjs for build-to-build health, asset, search, inventory, typed-edge, sitemap, and changelog deltas.
Publish changes.html and assets/oim-build-diff.json.
Wire build-diff generation into refresh-from-export.sh.
Add build diff asset to API catalog and link Changes from homepage/sitemap.
Verify second run has previous baseline and final health remains 130 pass / 0 warn / 0 fail.

Optimize JSON asset budgets

2026-04-28

Remove denormalized searchText copies from the full machine search index.
Trim full-index summaries/related lists and omit empty/default fields.
Bound relation-edge search samples to 11,000 while preserving all 13,278 edges in assets/oim-typed-edges.json.
Update topic/search health checks for the compact index profile and add typed-edge JSON coverage validation.
Verify all asset budgets now pass: health 130 pass / 0 warn / 0 fail.

Compact typed edges architecture page

2026-04-28

Add generate-lightweight-typed-edges.mjs to replace oversized architecture/typed-edges.html.
Publish full relation edge set as assets/oim-typed-edges.json.
Reduce typed edges HTML from ~2.69 MB to ~5 KB while preserving machine-readable edge data.
Wire lightweight typed-edge generation into refresh-from-export.sh.
Add typed edges landing size health check and typed edges JSON to API catalog.
Verify largest HTML budget now passes: health 126 pass / 3 warn / 0 fail.

Compact decompile index landing

2026-04-28

Add generate-lightweight-decompile-index.mjs to replace oversized assets/oim-decompile-index.html.
Reduce decompile index HTML from ~3.03 MB to ~5.5 KB while preserving assets/oim-decompile-index-data.json.
Wire lightweight decompile generation into refresh-from-export.sh.
Add decompile index landing size health check and verify: 124 pass / 4 warn / 0 fail.
Fix lingering refresh script syntax fragment while wiring the generator.

Compact DB inventory landing

2026-04-28

Compact db/index.html by loading assets/oim-db-inventory-index.json on demand instead of embedding all inventory entries inline.
Reduce db/index.html from ~3.07 MB to ~4.2 KB.
Preserve detailed DB object pages and machine-readable inventory JSON.
Rerun downstream DB page enhancers after rebuilding inventory.
Fix nested /db/* relative-link repair for ../db/... URLs.
Add db inventory landing size health check and verify: 123 pass / 4 warn / 0 fail.

Large C# source page compaction

2026-04-28

Add scripts/compact-large-source-pages.mjs.
Compact public C# source HTML pages over 2 MB into bounded source-derived context/excerpt pages.
Archive original oversized source HTML outside the public site under archive/large-source-pages/.
Publish assets/oim-large-source-compaction.json.
Wire compaction into refresh after C# source enhancement and add health checks for compaction/no remaining >2 MB C# source pages.
Verify public compact source page/status/compaction JSON run: 122 pass / 4 warn / 0 fail.

Lightweight wiki landing

2026-04-28

Add scripts/generate-lightweight-wiki.mjs.
Replace public 13 MB wiki.html monolith with a lightweight ~24 KB landing page.
Preserve old monolith outside public site at /srv/container-share/oim-knowledgebase/archive/wiki-monolith-2026-04-27.html.
Wire lightweight wiki generation into refresh after page generation/link repair.
Add health check requiring wiki.html to stay under 256 KB.
Verify public wiki/status/asset manifest run: 119 pass / 4 warn / 0 fail.

Slim client search index

2026-04-28

Add scripts/generate-client-search-index.mjs.
Publish compact assets/oim-kb-search-client.json for browser search while retaining full assets/oim-kb-search-index.json for machine/full metadata use.
Reduce browser search payload from ~47.8 MB to ~20.0 MB using compact array rows and trimmed display/search fields.
Patch search.html and persistent site.search.html to load and normalize the slim client index.
Add client index to API catalog, llms.txt, asset manifest budgets, refresh, public URL/gzip checks, and health checks.
Verify client search budget passes under 25 MB; full run: 118 pass / 4 warn / 0 fail.

Asset manifest and performance budgets

2026-04-28

Add scripts/generate-asset-manifest.mjs.
Publish assets/oim-asset-manifest.json with public asset sizes, groups, mtimes, SHA-256 prefixes, and budget telemetry.
Link asset manifest from API catalog, llms.txt, and status page.
Wire asset manifest generation into refresh and health checks.
Surface large-asset budget warnings for search index, largest JSON, largest HTML, and total public bytes.
Verify public asset manifest/API/status/llms run: 113 pass / 4 warn / 0 fail.

Refresh pipeline hygiene

2026-04-28

Remove duplicate provenance dashboard generation from refresh-from-export.sh.
Keep provenance generation once before sitemap creation and once in the final post-health publication phase.
Correct the postProcess ledger to match the de-duplicated refresh flow.
Add health checks for adjacent duplicate node steps and adjacent duplicate postProcess entries.
Verify refresh script syntax and full public health: 109 pass / 0 warn / 0 fail.

Graph viewer controls and exports

2026-04-28

Add search and node-type filtering to SQL module graph viewer.
Add search and node-type filtering to DB table graph viewer.
Add JSON links and CSV edge export to module, table, and object graph viewers.
Persist object graph viewer through refresh by copying scripts/object-graph-viewer.js after graph generation.
Extend health checks for graph viewer controls and public JS assets.
Verify public module/table/object graph pages and viewer assets: 107 pass / 0 warn / 0 fail.

Provenance dashboard

2026-04-28

Add scripts/generate-provenance-dashboard.mjs.
Publish /provenance.html plus assets/oim-provenance-catalog.json with source-root counts, DB snapshot row counts, query file hashes, public asset metadata, and safety notes.
Link provenance from homepage, API catalog, llms.txt, and sitemap.
Wire provenance generation into the refresh loop.
Extend health checks for provenance assets, sitemap URL coverage, and public provenance endpoints.
Verify full public run: 100 pass / 0 warn / 0 fail.

Changelog freshness repair

2026-04-28

Make scripts/generate-changelog.mjs include all dated task sections instead of only 2026-04-27.
Fix changelog section parsing so the final dated section at end-of-file is included.
Cap RSS item pubDate at generation time to avoid future-dated current-day feed items.
Extend health checks so changelog must include latest dated updates.
Verify public changelog/RSS/index run: 93 pass / 0 warn / 0 fail.

Sitemap coverage repair

2026-04-28

Detect missing sitemap coverage for generated topics, API catalog, changelog, and status pages.
Reorder refresh so generated public pages exist before sitemap generation, with final sitemap/llms regeneration.
Tune sitemap priority/changefreq for topics, API, status, and changelog pages.
Add health check for required sitemap URLs.
Regenerate and verify sitemap: 9,786 URLs; health 92 pass / 0 warn / 0 fail.

Public compression health

2026-04-27

Tune nginx gzip settings for text/JSON/XML/RSS/SVG assets.
Validate and reload the oim-knowledgebase nginx container.
Extend site health checks with public gzip assertions for large search/LLM/XML assets.
Verify gzip responses include content-encoding: gzip and vary: Accept-Encoding.
Verify full public run: 90 pass / 0 warn / 0 fail.

Topic hubs

2026-04-27

Add scripts/generate-topic-hubs.mjs.
Publish topics/index.html plus eight curated topic pages for DBQueue, IT Shop, DialogObjects, config, scripts, C#, graphs, and SQL modules.
Publish assets/oim-topic-hubs.json.
Link topic hubs from homepage, API catalog, and llms.txt; wire into refresh and health checks.
Verify full public run: 85 pass / 0 warn / 0 fail.

Search suggestions/autocomplete

2026-04-27

Add scripts/generate-search-suggestions.mjs.
Generate assets/oim-search-suggestions.json with 5,000 suggestions from the combined search index.
Patch search.html and persistent site.search.html with datalist autocomplete.
Add suggestions to API catalog and llms.txt; wire into refresh and health checks.
Verify full public run: 81 pass / 0 warn / 0 fail.

Public API catalog

2026-04-27

Add scripts/generate-api-catalog.mjs.
Publish api/index.html and api/catalog.json for public JSON assets and graph collections.
Link API catalog from homepage and llms.txt.
Wire API catalog generation into refresh and extend health checks.
Verify full public run: 78 pass / 0 warn / 0 fail.

Public changelog and RSS

2026-04-27

Add scripts/generate-changelog.mjs.
Publish changelog.html, feed.xml, and assets/oim-changelog-index.json from the project task ledger.
Link Changelog/RSS from homepage and include them in llms.txt.
Wire changelog generation into refresh and extend health checks.
Verify full public run: 73 pass / 0 warn / 0 fail.

LLM-readable site guide

2026-04-27

Add scripts/generate-llms-txt.mjs.
Publish llms.txt, llms-full.txt, and assets/oim-llms-summary.json.
Include entry points, examples, machine-readable assets, coverage counts, and safety notes.
Wire generation into refresh and extend health checks.
Verify full public run: 67 pass / 0 warn / 0 fail.

OpenSearch discovery

2026-04-27

Add scripts/generate-opensearch.mjs.
Publish opensearch.xml and favicon.svg.
Add browser search discovery links to homepage, search, status, and DB index pages.
Adjust refresh ordering so generated status/homepage exist before health and OpenSearch links are re-applied after regeneration.
Extend health check and verify full public run: 62 pass / 0 warn / 0 fail.

Coverage-aware homepage

2026-04-27

Add scripts/generate-homepage.mjs.
Regenerate homepage from current public assets/health/search coverage.
Link status, sitemap, graph searches, config/DialogObject/DialogScript examples, and C# insight search from the front page.
Persist homepage as site.index.html and wire generation into refresh after status generation.
Verify full public run: 58 pass / 0 warn / 0 fail.

Public status dashboard

2026-04-27

Add scripts/generate-status-page.mjs.
Publish status.html, assets/oim-status-summary.json, and public sanitized assets/oim-site-health.json.
Wire status generation into refresh after health check.
Extend health check for status assets and public /status.html.
Verify full public run: 58 pass / 0 warn / 0 fail.

Sitemap and robots

2026-04-27

Add scripts/generate-sitemap.mjs.
Generate public sitemap.xml, robots.txt, and assets/oim-sitemap-index.json.
Wire sitemap generation into refresh.
Extend health check for sitemap assets, URL count, and public sitemap/robots URLs.
Verify full public run: 54 pass / 0 warn / 0 fail.

DialogObject context

2026-04-27

Add scripts/enhance-dialog-object-context.mjs.
Generate assets/oim-dialog-object-context.json for 850 DialogObjects without publishing raw MethodScript/SelectScript bodies.
Patch 850 DialogObject pages with method markers, backing/related tables, events/forms/PutValue columns, config refs, and SQL/C# references.
Integrate DialogObject context into main search terms.
Wire into refresh and verify full public run: 48 pass / 0 warn / 0 fail.

SQL module parameter/dependency context

2026-04-27

Enhance SQL module context with sandbox DB metadata provenance from sys.objects, sys.parameters, and sys.sql_expression_dependencies.
Render declared parameter tables with SQL data type and input/output direction on 1,825 SQL module pages.
Add provenance badges and object modify timestamps to module context sections.
Rebuild module insights/search and verify public QBM_PDBQCS_SlotExec module page plus full health: 45 pass / 0 warn / 0 fail.

DialogScript context

2026-04-27

Add scripts/enhance-dialog-script-context.mjs.
Generate assets/oim-dialog-script-context.json for 283 DialogScripts without publishing raw ScriptCode.
Patch 283 DialogScript pages with DB-computed flags, related tables, SQL/C# references, and same-family scripts.
Integrate DialogScript context into main search terms for script entries.
Wire into refresh and verify full public run: 45 pass / 0 warn / 0 fail.

Config usage context

2026-04-27

Add scripts/enhance-config-usage.mjs.
Generate assets/oim-config-usage.json for 693 config parameters.
Patch 693 config pages with parent/child hierarchy plus SQL/C# usage sections.
Wire config usage generation into refresh before search generation.
Extend health check and verify full public run: 42 pass / 0 warn / 0 fail.

Module source excerpts

2026-04-27

Add scripts/enhance-module-source-excerpts.mjs.
Generate assets/oim-module-source-excerpts.json for 1,825 SQL modules.
Patch 1,825 SQL module pages with syntax-highlighted source excerpts and full-source links.
Wire source excerpt generation into refresh after module graph generation.
Extend health check and verify full public run: 39 pass / 0 warn / 0 fail.

Graph-aware search

2026-04-27

Add module-graph entries to main search index from assets/oim-module-graph-index.json.
Add table-graph entries to main search index from assets/oim-table-graph-index.json.
Update search UI filters with Module graphs and Table graphs.
Verify public filtered graph search URLs and full health: 37 pass / 0 warn / 0 fail.

Table relation graphs

2026-04-27

Add scripts/build-table-graphs.mjs and table graph JSON under assets/table-graphs/.
Add scripts/table-graph-viewer.js / public assets/table-graph-viewer.js.
Patch 473 DB table pages with table relation graph panels.
Wire table graph generation into refresh.
Extend health check for table graph index/files and verify full public run: 37 pass / 0 warn / 0 fail.

Search UI and ranking

2026-04-27

Add labeled result-type filters for SQL modules, DB inventory, C# insights, source pages, relation edges, config params, scripts, and DialogObjects.
Persist selected filter in type= URL parameter.
Improve exact-match ranking for titles, aliases, normalized dbo. names, config paths, related terms, and indexed terms.
Preserve customized search.html across refresh via site.search.html.
Verify public filtered search URLs and full health: 32 pass / 0 warn / 0 fail.

Module relation graphs

2026-04-27

Add scripts/build-module-graphs.mjs and module graph JSON under assets/module-graphs/.
Add scripts/module-graph-viewer.js / public assets/module-graph-viewer.js.
Patch 1,825 SQL module pages with module relation graph panels.
Wire module graph generation into refresh.
Extend health check for module graph index/files and verify full public run: 32 pass / 0 warn / 0 fail.

Site health check

2026-04-27

Add scripts/site-health-check.mjs for required assets, search fixtures, inventory/insight counts, graph count, internal links, and optional public URL checks.
Fix checker false positives from JavaScript templates and rendered source-code text.
Verify full public run: 27 pass / 0 warn / 0 fail.
Wire local --skip-public health check into refresh loop after graph injection.

Reverse dependency context

2026-04-27

Generate assets/oim-reverse-dependencies.json from SQL dependencies, FK rows, SQL source extraction, and C# extraction.
Patch 473 table pages with referenced-by / reverse relation sections.
Patch 5,364 module pages with referenced-by / reverse dependency sections.
Wire reverse dependency generation into refresh loop.
Verify public pages and zero missing internal refs.

C# source insight extraction

2026-04-27

Generate assets/oim-csharp-insights.json for 148 decompiled C# source pages.
Patch C# source pages with source-derived context sections.
Keep wording factual: pattern extraction from decompiled C# and decompile index, not semantic guessing.
Wire C# insight generation into refresh loop.
Verify public C# page and zero missing internal refs.

Module insight extraction

2026-04-27

Generate assets/oim-module-insights.json for 1,825 SQL modules.
Patch DB module pages with source-derived context sections.
Keep wording factual: pattern extraction from exported SQL definitions, not semantic guessing.
Verify public module page and zero missing internal refs.

All DB object inventory

2026-04-27

Add /srv/container-share/oim-knowledgebase/scripts/collect-all-db-objects.sh.
Collect read-only metadata for sys.objects, tables/columns/indexes/triggers, foreign keys, DialogObjects/methods, DialogScripts, and DialogConfigParm.
Add /srv/container-share/oim-knowledgebase/scripts/build-db-inventory.mjs.
Generate /db/index.html plus 7,663 DB inventory pages.
Exclude plaintext secret values: encrypted config params render as <encrypted>.

Object graph layer

2026-04-27

Generate per-object graph JSON for 11 object pages.
Add reusable assets/object-graph-viewer.js bubble-style graph viewer.
Patch object pages to load relation graphs.
Verify public object graph assets and zero missing internal refs.

Navigation repair

2026-04-27

Generate browser-friendly HTML pages from flattened markdown exports.
Repair source-relative links to generated page routes or search fallback.
Change nginx fallback from homepage rewrite to real 404 for missing files.
Verify internal HTML refs: 20,118 checked, 0 missing.