v2.49.0

This release removes TypeORM from MemberJunction. Existing ExecuteSQL commands against the SQLServerDataProvider should continue to function as expected, as differences between MSSQL and TypeORM have been abstracted away.

Custom resolvers implemented outside the MJ repository may require minor refactoring. These adjustments are minimal, and the MJ repository has already been fully updated to reflect the changes.

The handling of primary key (PKEY) assignment during new record creation has also been updated. This enhancement introduces additional flexibility for explicitly setting IDs and related values, without affecting existing behavior.

New Features

  • AI Agent Framework: Introduced hierarchical prompt execution, including a new AI execution monitoring dashboard with a tabbed interface and state persistence via Config.userState.
  • Primary Key Override: Implemented optional primary key specification for record creation, including support for non-auto-increment keys and fixes for _everSaved.
  • Metadata Sync Enhancements: Added support for recursive entity relationships using recursive: true, with depth limits, circular reference protection, and backward compatibility.
  • Actions Framework: Launched a robust MemberJunction Actions system with dynamic DriverClass support and integrated demo utilities.
  • SQL Logging Enhancements: Added detailed SQL logging to SQLServerDataProvider, including support for transaction groups and per-logger filtering.
  • Verbose CodeGen Mode: Enabled a verbose/non-verbose mode in CodeGenLib with a modern spinner UI.
  • Drill-down Dashboards: Implemented detailed drill-down capability in the AI dashboard with Kendo Splitter layout.

Improvements

  • Migration Sequencing: Resolved migration field sequencing issues in CodeGen by offsetting sequence numbers to prevent conflicts.
  • Entity Base Class: Replaced typeorm usage with BaseEntity from MJ Core across packages.
  • Error Handling: Overhauled CLI error messaging and debugging outputs for push, pull, init, status, and watch commands, improving developer diagnostics.
  • Documentation Enhancements: Updated documentation on SQL output logging, metadata sync configuration, error resolution, and LLM usage best practices.
  • UI Enhancements: Refined dashboard layout and chart sizing, improving visual consistency in tabbed and time-series views.

Bug Fixes

  • Fixed incorrect ancestryID handling to allow n-level entity embedding.
  • Corrected primary key handling in spCreate when no key is provided.
  • Fixed field ordering in CodeGen to ensure consistent migration script behavior.
  • Addressed chart overlap and control visibility issues in the monitoring dashboard.
  • Improved template creation logic to explicitly use UUIDs and respect new primary key capabilities.
  • Resolved transaction group processing issues under MSSQL.