v6.2.0: Upgrading from 6.1: field-level security, typed decisions and MJ Query
The cumulative upgrade note for moving from the 6.1 LTS line to the 6.2 LTS line, covering the Edge builds v6.2.0-edge.0 through edge.8 and the 6.2.1 respin. 6.2 adds Rubrics, record cloning, typed decisions, the Durable Work Queue, form contributions, conversation forks, telephony and meetings, the Chief of Staff agent, Alternate Base Views, the content pipeline, the MJ Query language, Video Studio, the Excel add-in, Diagnostic Bundles and anchored record comments, plus field-level security, SQL screening and realtime fixes.
Upgrade Notes apply: 74 to 77 SQL Server migrations depending on your 6.1 patch, several requests 6.1 accepted are now refused, saved queries need mj query refresh, local and duplicate-detection vectors need re-embedding, Entity.Configuration is replaced on core entities, and server and clients must move to 6.2.1 together.
6.2.0 was the candidate cut on 2026-11-04 from v6.2.0-edge.8 and was never installed. 6.2.1 is the current candidate; install 6.2.1, not 6.2.0. Fixes that already shipped to 6.1 users in 6.1.1 to 6.1.6 are listed once, at the end, and are left out of the sections above it.
MemberJunction 6.x is released under the Business Source License 1.1; 5.x and earlier stay ISC. What the licence grants, and what needs certification, is in the licence section of the v6 upgrade guide.
Upgrade Notes
Section titled “Upgrade Notes”Upgrade steps
Section titled “Upgrade steps”- Before upgrading, record any
Entity.Configurationyou set on core entities. The release metadata replaces the whole field on the 63 entities inmetadata/entities/.clone-configurations.jsonand the 15 inmetadata/entities/.save-return-datestamps-only-entities.json. Re-apply your settings afterwards, merged with the newCloneandSaveReturnModekeys. (#4585, #5846) - Before upgrading, check for blockers. A database with bizapps-common 5.47 installed cannot upgrade yet (#4939, still open); do not delete common’s prompt model to get past it. Find active credentials whose
ExpiresAtis in the past, since they now throw (see below). If you take inbound phone calls, settelephony.inboundRunAsUserEmail. - If you are on 6.1.5 or earlier, also do the 6.1.6 preparation: link actions to
MJ: Action Authorizationsfor non-Owner users, and configure the read-only database login (dbReadOnlyUsername/dbReadOnlyPassword). See Already required on the 6.1 line. - Upgrade every
@memberjunction/*package to 6.2.1 together, server and client. Several fixes have a client half and a server half that must match, and some 6.2 clients fail against an older server (search streams,GetRecordDependencies, the WebSocket idle window). - Run
mj migratewith the 6.2.1 CLI, in the same deploy as the 6.2.1 server. The release’s metadata-sync migrations must not land before the server code that guards them, and the recording-ledger migration and its metadata sync must land together. The 6.2.1 CLI turns onoutOfOrderfor that run when a 6.1 line database has backported migrations ahead of older 6.2 files; if your config setsoutOfOrder: false, remove it for the upgrade. (#6151) - If you regenerate code for your own entities, run
mj codegenand review the output. The CodeGen prompts moved to new models, so AI-written validators, descriptions and form layouts can differ. On SQL Server, numeric or single-valueIN (...)CHECK constraints now generate literal union types instead ofnumber. (#4920, #4003) - Refresh saved queries. Run
mj query refresh --all --dry-run, fix what it lists asErrorandWarning, then runmj query refresh --all. It never changes a query’s SQL. (#6124) - Re-embed local vectors. Run
mj ai actions run -n "Re-embed Local Vectors" --param "Force=true", then restart MJ server processes. (#5214) - Rebuild vectors and caches that held restricted data. Once every server runs 6.2.1, flush RunView keys in any shared cache (Redis). Re-vectorize Entity Documents on field-secured entities (rebuilding external stores such as Pinecone), re-run entity autotagging, review tags produced from restricted text, and re-sync the vectors behind any duplicate detection. (#5968, #6033)
- Reload clients. Reload open browser tabs, move pinned consumers of
@memberjunction/graphql-dataproviderto 6.2.1, and replace any self-hostedmj-widget.js. If a proxy or gateway pinsAccess-Control-Allow-Headers, addx-mj-timezone.
There is no Node.js or Angular change: the distribution still requires Node 24 or later and Angular stays on 21.2.22. The new Video Studio render worker needs Node 22 or later and ffmpeg on PATH.
Database migrations
Section titled “Database migrations”- SQL Server: 77 migrations were added between v6.1.0 and v6.2.0; a 6.1 database applies the ones it does not already have. Three of them shipped on the 6.1 line under their 6.2 file names and are skipped if already applied:
V202609161850__v6.2.x__Metadata_Sync(6.1.2),V202609191819__v6.2.x__TaskGraph_Guarded_Write_Sprocs(6.1.3) andV202609291627__v6.2.x__MagicLink_Consume_Invite_Sproc(6.1.5). A database on 6.1.5 or 6.1.6 applies 74; one on 6.1.0 or 6.1.1 applies 77. 6.2.1 adds none. - 6.1.5 and 6.1.6 databases also applied the line-only
V202610061630__v6.2.x__Line_Metadata_Sync_Native_Tool_Calling. It has no file in 6.2 and needs none:mj migratehands Skyway only the migrations the database has not applied. - Schema changes, by area. AI and agents:
AIPromptRun.UserID,decimal(19,8)cost precision andvwAIUsageFacts;AIVendor.Configuration; Decision step types for agents, tasks and entity-document reasoning; theHandoffstep type and agent consults;AIAgentRunSteppayload source-step pointers andAIPrompt.TemplateDataCapture;MJ: AI Agent User Policiesand theAgentWakeroutine type;ActionParam.ValueSchema;AIAgentSessionclose reasons and the recording shard ledger; cascade deletes for AI agent configurations. Data platform: Record Change clone context andMJ: Record Clone Logs; the Rubrics schema and views;MJ: Entity Form Contributions; binary vector columns; the work queue schema and its guarded-write procedures;MJ: Entity Alternate Base Views; bound data access and query approvals; the content pipeline; query extraction metadata and detection methods;Entity.AutoUpdateDisplayName;SaveReturnModedatestamps-only procedures; the per-connection integration catalog; composite performance indexes and the RecordChange recycle-bin index; CodeGenEntityFielddrift repairs; the Semantic Graph entities. Collaboration and UI:Project.OwnerUserIDwith its row-level-security filter and a legacy backfill, then the three-tier folder permission backfill;MJ: Conversation Branches; anchored conversation and record comment columns;User.IsTemplate;MJ: Scoped Notification Configs; the login screen on themes; Calendar Event Links; Brand Kits and Video Archetypes;MJ: Diagnostic*entities. Operations: Feature Pipelines and their types, keys and versions;Archive.StorageMode;spSetScheduledJobNextRunAt; telephony phone numbers, number pools and interactions; communication-provider delegated OAuth gates; web search providers; the hardenedspDeleteEntityWithCoreDependencies, which now also clears graph edges. - Data changes. Ten
Metadata_Syncmigrations carry the release metadata (the first of them is the one 6.1.2 already applied), including theEntity.Configurationreplacements above. One migration deletes 25 obsolete computer-use Test records; one repoints the duplicateSTTmodel type ontoSpeech to Text; one backfillsMJ: Duplicate Runs.EntityDocumentIDand deletes runs whose entity has no Entity Document. - Metadata_Sync migrations now update only the fields MJ changed (#5177). Migrations published before this release still contain full-row updates, so if you tune MJ-owned rows (for example
TrustServerCacheCompletely), re-apply those settings after migrating. - PostgreSQL has counterparts for these migrations, with two known gaps.
vwEntitiesandvwEntityFieldsstill lack theEnableFieldLevelSecurity,RelatedEntityFilterandRelatedEntityOrderBycolumns, so that field metadata is removed on PostgreSQL installs (#5649, still open). The twoEntityFormContributionunique indexes include nullable columns, so PostgreSQL accepts two Active Role or Global contributions with the same key where SQL Server refuses the second. 6.2.1 does not change this.
Breaking changes and required actions
Section titled “Breaking changes and required actions”Security and access control
- Field-level security refuses more (
@memberjunction/core,@memberjunction/server,@memberjunction/generic-database-provider,@memberjunction/templates,@memberjunction/a2aserver, and others): client input naming a field the caller cannot read is rejected instead of dropped. Ad-hoc SQL from any user except the system user may read only entity base views the caller reads with no row filter and no denied field, and ad-hoc SQL with no user is refused. For a user with any field denial, a saved query without a role-list grant is refused when it reads anything other than an entity base view or table; grant such queries throughMJ: Query Permissionsafter reviewing their SQL. RESTrunView/runViewsalways returnsimplerows. An entity communication skips recipients whose address field the sender cannot read. Withouta2aServerSettings.userEmailthe A2A agent card lists no entities or agents. (#5968) - Template renders need their user (
@memberjunction/templates): templates render as the user of each render; pass that user asContextUser. A render without one still runs, but an{% AIPrompt %}tag fails it, and an{% AIPrompt %}tag whose model fails now fails the render, so a communication that used to send with an error in its body does not send. (#5968) - Expired credentials are refused (
@memberjunction/credentials,@memberjunction/ai-prompts): a credential past itsExpiresAtthrowsCredentialExpiredErrorwhere it used to resolve.CredentialEngine.Instance.ExpirationConfigacceptspolicy: 'warn'or agraceMsfor a staged rollout. (#4058) - Scoped searches are bounded by their configuration (
@memberjunction/search-engine): a scope with no enabled provider rows, or no lanes of a kind, returns nothing instead of searching everything, and an inactive, expired or missing scope refuses the search. Custom search providers that read entity or storage lanes must overrideConsumesLaneKinds. Arequiredscope dimension that resolves to nothing refuses withScopeDimensionError, and a storage laneFolderPaththat renders empty or contains..refuses the search. A laneExtraFilternow applies to every provider’s hits. To keep a scope’s old reach, add one enabledMJ: Search Scope Providersrow per provider it should run. Streamed per-provider events carry only aResultCount, so upgrade MJAPI before clients. (#5175) - Agent runs check scope permissions (
@memberjunction/ai-agents,@memberjunction/server): pre-execution RAG searches an agent’s assigned scopes only for users with aSearchorManagegrant on the scope (or an agent set toAll).PrimaryScope*,SecondaryScopesand__agentTypePromptParamsin a run’sdataare dropped unless the caller is the system user or an API key holding the newagent:trustedscope. - Workflow actions refuse inside agent runs (
@memberjunction/core-actions): Loop, Parallel Execute, Conditional and Retry refuse inside any agent run, since the actions they run cannot carry the run’s scope. Agents configured to call them need another path. - Storage routes check account permissions (
@memberjunction/server): the GraphQL storage routes need Read or Write on the storage account and refuse files the caller cannot read. Accounts with noMJ: File Storage Account Permissionsrows stay open. - More client SQL is refused (
@memberjunction/generic-database-provider,@memberjunction/server): beyond the 6.1.6 screening, a backslash inside a quoted string or identifier in a clientExtraFilter,OrderByorOverrideExcludeFilteris refused, so a filter such asAccount = 'DOMAIN\user'now fails; stored view clauses are not checked for backslashes. - Server-only fields and rows (
@memberjunction/core-entities,@memberjunction/core-entities-server,@memberjunction/server): people post conversation messages only as themselves, and a message whoseID, conversation or rating comes from a TransactionGroup variable is refused, so creating a conversation and its first message in one transaction group no longer works; save the conversation first (#5299). The sevenRecording*ledger fields onMJ: AI Agent Sessionslose their setters and GraphQL inputs (RecordingStartedAtstays) (#6020), and only the server’s own close paths can setTimeLimit,Idle,JanitororShutdown. Record Changes can be annotated, but an update may change onlyCommentsand requiresRecord Changes: Annotate. - Inbound phone calls need a run-as user (
@memberjunction/telephony-adapters): inbound calls run astelephony.inboundRunAsUserEmailinstead of the System or Owner user, and are rejected when it is missing. (#5023) - Shared forms need
Manage Form Defaults(@memberjunction/core-entities-server): changing or deleting an existing Role or Global custom form requires that authorization, and anmj sync pushof Global rows needs a sync user who holds it or is an Owner. (#4311) - Web widget and anonymous sessions (
@memberjunction/server,@memberjunction/realtime-widget,@memberjunction/ng-realtime-widget,@memberjunction/livekit-room-server): a guest token refresh needs a proof signed by a key the widget registers, so a widget bundle older than this release gets 403 at its first refresh. The widget needs its host page on HTTPS (orlocalhost). A widget whose guest role is the stockUIrole is refused withguest_role_not_isolated; useWidget Guestor a role listed inmagicLink.grantableRoleNames. Guest sessions end 12 hours after their first mint, and anonymous sessions started before the deploy must start again. (#5997, #6065) SetupRESTEndpointsdefaults to disabled (@memberjunction/server): code that calls it directly withoutenabledno longer mounts the REST API; passenabled: true. A standard MJAPI deployment is unchanged. WithrequireAuthon, the component registry server refuses requests until a subclass overridescheckAPIKey. (#6034)
Queries, views and data access
- Composed queries receive only the arguments in their reference, and results change silently (
@memberjunction/sql-parser,@memberjunction/core-entities-server): a query that relied on a same-named parameter flowing into a composed query now runs without error and returns the inner query’s unfiltered rows. Themj query refreshdry run lists these asWarning(MJQ_COMPOSITION_IMPLICIT_ARGUMENT). Fix each by naming the argument, as in{{query:"Path/Name(Since=Since)"}}. (#6124) - Queries with a template tag inside quotes stop running (
@memberjunction/sql-parser,@memberjunction/core-entities-server): a value tag inside a SQL string (WHERE Region = '{{ Region }}') or a quoted identifier is refused on every run. Template syntax outside the MJ Query language (macros, includes, function calls, unknown filters,Context.*tokens) and queries that write or run more than one statement are also refused. A query naming a field the user may not read is refused with the “does not exist or you do not have permission” message, so code matching the old “Denied entities” text must change. (#6124) RunViewTotalRowCountis optional (@memberjunction/core,@memberjunction/generic-database-provider,@memberjunction/graphql-dataprovider):RunViewResult.TotalRowCountisundefinedwheneverSkipTotalRowCount: trueis passed; strict TypeScript consumers that read the field get a compile error. Callers that read onlyResultsshould passSkipTotalRowCount: true.MaxRows: 1behaves as it did in 6.1. (#6226)RunViewomits binary fields by default (@memberjunction/core): passIncludeBinaryFields: true, or name the field inFields, to get them.Load()still includes them. (#4978)- GraphQL saves return only what changed (
@memberjunction/graphql-dataprovider,@memberjunction/server): an Update sends and receives the fields it changed plus computed and virtual ones, so a client’s copy no longer picks up another user’s concurrent edits to fields it did not change. Conflicting concurrent edits to the same field fail withCONCURRENT_MODIFICATION_CONFLICT. (#5807, #5865, #6183) GetRecordDependenciesneeds a 6.2 server (@memberjunction/server,@memberjunction/graphql-dataprovider): the client readsPrimaryKey, which older servers do not return.CompositeKeystays as a deprecated alias.- Mixed-version clients drop renamed metadata fields: metadata fields such as
EntityInfo.spCreateserialize under PascalCase names, which a client older than its server drops. Public APIs across most packages gain PascalCase names; the old names remain as@deprecatedforwarding stubs. - Duplicate detection needs its document and fresh vectors (
@memberjunction/core-entities,@memberjunction/ai-vector-dupe,@memberjunction/ai-vector-sync,@memberjunction/ai-vectors-memory):MJ: Duplicate Runs.EntityDocumentIDis required. Entity Documents no longer cascade deletes, so a document with runs or synced vectors cannot be deleted; set it Inactive. Vectors synced before this release carry noEntityDocumentID, so a run against them fails until they are re-synced. The in-memory vector store now scores standard cosine similarity; re-tune thresholds set against it to2 × old − 1. (#6033) - Local embedding vectors change (
@memberjunction/ai-local-embeddings,@memberjunction/aiengine): the move to@huggingface/transformers4.3.1 changes all-mpnet-base-v2’s vectors under the same model ID, and long texts are truncated at the model’sMaxInputTokens. Re-embed as in the upgrade steps. (#5214)
AI and agents
- Agent replies are created by the server (
@memberjunction/server,@memberjunction/graphql-dataprovider,@memberjunction/ai-agent-client,@memberjunction/conversations-runtime,@memberjunction/ai-agents,@memberjunction/task-graph):RunAIAgentFromConversationDetailtakesuserMessageIdinstead ofconversationDetailId, and the server creates the reply row. Client code that creates or editsAI/Errorrows inMJ: Conversation Detailsis refused, andRunAIAgent/RunAIAgentSystemUserno longer write into a caller-suppliedconversationDetailId.AgentClientSession.RunAgentFromConversationDetailtakesUserMessageId, andTaskContinuationParams.SubmittedByUserIDis required. (#6001) - Prompt model selection enforces the LLM type (
@memberjunction/ai-prompts): a prompt whoseAIModelTypeIDnames a non-LLM type, or an explicit override naming a model of another type, fails with an error naming both types. Prompt model bindings pointing at another type are skipped and logged. No shipped prompt is affected. - Prompt and agent runs store less (
@memberjunction/ai-prompts,@memberjunction/ai-agents):AIPromptRun.Messagesholds nodataortemplateDataby default; setTemplateDataCapturetoReferencedorFullwhere you need them. Agent runs no longer writeAIAgentRun.Result(useFinalPayload), and readers ofAIAgentRunStep.PayloadAtStart/PayloadAtEndmust followPayloadAtStartSourceStepID/PayloadAtEndSourceStepIDwhen set. (#5526, #5653) BeforeAgentTurnfires on every route, once per turn before any reply row exists, carrying the resolved agent and route; a cancel leaves nothing behind. (#4788)- Removed or changed AI APIs:
AIPromptRunner’s protectedbuildFailoverCandidatesandcreateCandidatesFromModelsare removed.PayloadFeedbackManager.QueryAgenttakes aPayloadFeedbackContext(#4848). Conversation-routing builders andIsAgentAllowedmove from@memberjunction/ng-conversationsto@memberjunction/ai-core-plus(#4860).IRealtimeSession.SendInputtakes oneRealtimeInputFrame({ Data, Kind, MimeType?, TimestampMs? }) instead of(chunk, kind?)(#5090).IRealtimeSessionRecorderreturns Opus packets (TakeEncodedPackets(),Stop(): Promise<number>), andBrowserRecordingUnloadGuardis removed; hosts that wire their own page-lifecycle events callSendRecordingTerminal(#5536). Web Searchis a provider-neutral router (@memberjunction/web-search-engine,@memberjunction/core-actions): direct agent bindings toGoogle Custom SearchandPerplexity Searchare removed by the metadata migration in favour of the routingWeb Searchaction. (#4488)- CodeGen prompts and rank-based model choice move to new models (
@memberjunction/codegen-lib,@memberjunction/aiengine): prompts and agents that choose models by rank may pick a different model. (#4920)
Angular and UI
- Conversation thread-panel API removed (
@memberjunction/ng-conversations,@memberjunction/ng-explorer-core): forks replace the ParentID-based thread panel.ThreadPanelComponent, the chat area’sThreadIdinput andThreadOpened/ThreadClosedoutputs, the workspace’sOpenThread/CloseThread/SelectedThreadId, andMessageListComponent’sReplyInThread/ViewThreadoutputs are removed with their camelCase aliases. (#5179) UserInfoEngine.UserRecordLogsremoved (@memberjunction/core-entities): useawait UserInfoEngine.LoadRecentRecordLogs(n).GetRecentRecordsForEntity()is removed. (#5141)- Legacy
mj-btn-*classes removed (@memberjunction/ng-explorer-app):.mj-btn-primary,-secondary,-ghost,-icon-only,-sm,-lg, the unused.mj-modal-*,.mj-icon-card*,.skip-icon*and.k-*rules and_md3-shared.cssare gone; usemjButtonormj-btn--<variant>. (#5082) - Chief of Staff pages and exports removed (
@memberjunction/ng-dashboards,@memberjunction/ng-base-application): priorities, objectives, milestones, assignments and to-dos move to an extension in the BizApps Tasks app.@memberjunction/ng-dashboardsdropsChiefOfStaffDashboardComponent,LoadChiefOfStaffDashboard, the task scope, priority, to-do and health helpers, theBIZAPPS_*entity names and the tab helpers, and renamesBuildCockpitScopeFilters,COCKPIT_LIVE_ENTITIESandIsCockpitEntityChangeto theirChiefOfStaffforms. - Conversation folders default to Private (
@memberjunction/core-entities,@memberjunction/ng-conversations,@memberjunction/server): a conversation in a Shared or Public folder is visible only to its owner unlessinheritFolderAccess: trueis set in itsAdditionalData. (#6187)
Integrations, packages and tooling
- New integration objects and columns arrive disabled (
@memberjunction/server):autoEnableNewObjectsandautoEnableNewColumnsdefault tofalse; passtrueto adopt them automatically. (#4141) - Integration field-map API removed (
@memberjunction/integration-engine-base,@memberjunction/integration-engine):IntegrationEngineBaseloses theFieldMapsgetter,GetFieldMapsForEntityMapand theFieldMapsoption ofSeedForTesting. UseLoadFieldMapsForEntityMap(entityMapID, contextUser?), which throws when the read fails. (#6208) - Open App manifests and Node-only packages (
@memberjunction/open-app-engine,@memberjunction/dynamic-packages): arole: "actions"package undersharedno longer reaches the browser build, and one underclientis rejected. Add"platform": "node"to other Node-onlysharedpackages or move them toserver.mj app installandupgradecheck that app packages exist on npm before changing anything, so runnpm loginif private-package lookup fails. (#4521, #6109) @memberjunction/servertypes point atdist: itstypesentry and export condition aredist/index.d.ts. (#6153)- Failover attempt limit and Anthropic
max_tokens(@memberjunction/ai-prompts,@memberjunction/ai-anthropic):FailoverMaxAttemptsnow caps the requests a failover sends, where it was ignored (#4463). Anthropic streaming requests withoutmax_tokensdefault to 32000, so Claude 3 models need an explicit value (#6046).
Already required on the 6.1 line
Section titled “Already required on the 6.1 line”These changes shipped in 6.1.4, 6.1.5 or 6.1.6 with their own upgrade notes. If you are on 6.1.6 you have already handled them; from an earlier 6.1 patch, read v6.1.4, v6.1.5 and v6.1.6.
- Cache-invalidation events carry row data only for entities in
cacheSettings.recordDataBroadcastEntities(6.1.4, #4595). - Durable tasks queued with the old array payload fail loudly; re-trigger them or use Edit input & retry (6.1.5, #4796).
RunActionauthorizes each action throughMJ: Action Authorizations, template rendering is sandboxed and template runs are authorized, RunView aggregate expressions are restricted, the realtime relay ignores a session’s editableConfig, SQL data context items and dataset reads apply the caller’s permissions, client filters are screened, and record names follow field- and row-level security (6.1.6, #5264 to #5273).- Ad-hoc SQL, the Run Ad-hoc Query action and SQL data context items need the read-only database login (6.1.6).
- Gemini and Vertex prompts that set an effort level now think at that level (6.1.6, #5590).
- The realtime WebRTC broker endpoint is on by default; set
MJ_REALTIME_ENABLED=falseto turn it off (6.1.2, #4512).
New Features
Section titled “New Features”AI, agents and decisions
- Typed decisions (
@memberjunction/ai,@memberjunction/ai-prompts,@memberjunction/ai-agents,@memberjunction/task-graph,@memberjunction/ng-flow-editor,@memberjunction/server): aDecisionmodel type andAIDecisionRunneranswer Likelihood, Choice and Score questions with a probability per answer, model selection, failover and prompt-run telemetry, exposed through theRun Decisionaction andRunDecisionmutation. Flow agents and task graphs gain Decision steps; Loop agents can use decisions behind a master switch,decisionsEnabled, off by default; duplicate detection gainsDecisionandDecisionThenPromptmodes. Decision drivers ship for Cloudflare, System One, Perplexity, OpenAI’s Decisions API, Subquadratic and Inception Labs. (#4814, #4874, #4855, #4983, #4999, #5537, #5611) - Rubrics (
@memberjunction/rubrics-base,@memberjunction/rubrics,@memberjunction/ng-rubrics,@memberjunction/testing-engine): score any record against versioned, weighted criteria with LLM, agent, deterministic, Decision or human evaluators and consensus views. Published versions are frozen. Explorer gains a Rubrics application, tests can select a rubric throughRubricID, and seven shipped agent rubrics bind to their agents.MJ: Test Rubricsis deprecated. (#4937, #4984) - Chief of Staff agent and per-user agent policies (
@memberjunction/ai-agents,@memberjunction/scheduling-engine,@memberjunction/ng-dashboards): a personal Chief of Staff agent with an Explorer cockpit for approvals and wakes.MJ: AI Agent User Policiesnarrows what an agent may do for one user below that user’s own permissions, andAgentWakeroutines let an agent schedule its next wake. (#5842, #6041) - Agent runs bounded by their audience, bound action parameters and host-assigned scopes (
@memberjunction/ai-agents,@memberjunction/ai-core-plus): server code can name everyone who will see a run’s output (ExecuteAgentParams.Audience), fix action inputs the model cannot see or change (boundActionParams), and limit a run to given search scopes (SearchScopeIDs). (#5175, #6234) - Sub-agent consults and Sage handoffs (
@memberjunction/ai-agents,@memberjunction/ng-conversations): a sub-agent can consult its caller and escalate toMJ: AI Agent Requests; Sage can hand a conversation to a specialist agent and take it back on an@Sagemention. - Native tool calling for the Loop agent and JSON Schema for action parameters (
@memberjunction/ai-agents,@memberjunction/ai-prompts,@memberjunction/ai-anthropic,@memberjunction/ai-gemini,@memberjunction/ai-openai): the Loop agent can run as a provider-native tool loop, andActionParam.ValueSchemadeclares a parameter’s shape for the tool declaration and argument coercion. (#5965, #5848) - Runners for embeddings, images, reranking, speech and video (
@memberjunction/ai-prompts,@memberjunction/ai-reranker): each selects a model from a prompt’s bindings, resolves its credential, fails over and records an AI Prompt Run, as chat prompts already did. (#4842, #4843, #4844, #4909) - AI usage analytics on a cost basis you can check (
@memberjunction/ai-prompts,@memberjunction/ng-dashboards,@memberjunction/server): prompt runs recordUserID,vwAIUsageFactsgives one row per prompt run, eight saved queries group cost by currency beside priced and unpriced counts, and parallel runs record every arm. (#4402) - Agent trust tracking and structured error recovery (
@memberjunction/ai-agents,@memberjunction/actions-base,@memberjunction/messaging-adapters): actions that declareoutputTrustLevel: "Untrusted"have their output wrapped and tracked across sub-agents, with memory notes from tainted runs held for approval; action results carryActionErrorRecoverysuggestions. (#6268) - New providers and models: the Betty LLM provider (
@memberjunction/ai-betty), DeepInfra and SiliconFlow drivers, Cohere Rerank 5 (#6062), local EmbeddingGemma 2 (#5214), the Black Forest Labs FLUX 3 video driver, ElevenLabs realtime models, and catalog updates through Claude Opus 5.5, Sonnet 5.5 and Haiku 5.5, GPT-6.1 Sol and Terra, Grok 4.7, Kimi K3.1 Pro and MiniMax-M3.1-Flash.
Realtime, telephony and meetings
- Gemini 3.8 Live media plane and Gemini Live on Vertex AI (
@memberjunction/ai-gemini,@memberjunction/ai-vertex,@memberjunction/server): Gemini Live runs on Gemini Enterprise through an MJAPI relay that keeps Google credentials off the browser, and sessions continue past Google’s ~10-minute connection limit. (#5079) - Camera, screen share, live avatars and agents that watch meetings (
@memberjunction/realtime-runtime,@memberjunction/ng-realtime-media,@memberjunction/ai-bridge-livekit): calls can share the camera, screen or one panel; a voiced agent whose persona has a face can appear as a live Gemini avatar; withrealtime.video.watchMeetingsan agent sees a LiveKit meeting’s cameras and screens, with per-person consent. (#5079) - Telephony in LiveKit rooms (
@memberjunction/livekit-room-server,@memberjunction/telephony-adapters,@memberjunction/ai-bridge-twilio,@memberjunction/ai-bridge-vonage,@memberjunction/ai-bridge-ringcentral): SIP calls into rooms, hand-off to people, numbers or agents,MJ: Interactionscall records, number pools, hold music, multi-party meetings and a telephony operations dashboard. (#5023, #5042, #5046, #5148, #6272) - Realtime Channels v2 and the embeddable widget (
@memberjunction/realtime-runtime,@memberjunction/ng-realtime-channels,@memberjunction/ng-realtime-widget): a self-describing channel contract with scoping and verb-level exposure,<mj-realtime-widget>, and anIdentityVerificationchannel. (#4995) - Server-assembled recordings and session deadlines (
@memberjunction/realtime-runtime,@memberjunction/server): browser recordings upload 5-second Opus shards that MJAPI assembles intorecording.wav; sessions warn before a deadline and recordTimeLimitorIdleclose reasons. (#5536, #6199) - Remote Browser in text conversations (
@memberjunction/ng-conversations,@memberjunction/remote-browser-server): withrealtime.conversationBrowser.enabled, off by default, a conversation can open a browser its agents drive. (#6052)
Conversations and collaboration
- Conversation forks (
@memberjunction/ng-conversations,@memberjunction/ai-agents): Fork from here, Edit and Regenerate start a fork without losing the original, controlled by theConversations: Forkauthorization and a per-person setting. (#5179) - Stop for in-progress agent runs (
@memberjunction/ng-conversations,@memberjunction/ai-agents,@memberjunction/server): Stop works on whichever MJAPI replica owns the run, and the next turn continues from where it stopped. (#5047) - Personal and permission-tiered folders, multi-select and chat-wide search (
@memberjunction/ng-conversations,@memberjunction/core-entities): folders can belong to one user, and Private, Shared and Public tiers control who sees them. The sidebar gains multi-select, bulk actions and sorting, and a “Search all of Chat” row reaches cross-entity search. (#4711, #3747, #6187) - Host rules for multi-person chats and draft emails (
@memberjunction/ng-conversations,@memberjunction/ai-core-plus): opt-in chat-area inputs let a host run a chat among several people, and acompose:emailcommand opens a pre-filled draft in the user’s mail client. (#4788, #4568) - Anchored record comments (
@memberjunction/ng-base-forms,@memberjunction/core-entities-server,@memberjunction/server): field-, section- and group-level comments with record-bound “Ask AI” conversations, field- and row-level-security-aware@mentionnotifications and a per-entity enable switch. (#6281) - Task graphs in chat (
@memberjunction/ai-agents,@memberjunction/task-graph,@memberjunction/ng-tasks): single-step delegations complete in the same turn, workflows show live progress inline, the Tasks Command Center is redesigned, andForEach/Whilerun several steps per iteration. (#5878, #6224)
Data platform
- Field-level security close-out (
@memberjunction/core,@memberjunction/server, and 39 other packages): a denied field value no longer reaches API callers, an LLM’s context, message recipients, or stored artifacts such as embeddings, tags and logs, and work done on a user’s behalf runs as that user. See Upgrade Notes. (#5968) - SQL pipeline redesign and the MJ Query language (
@memberjunction/sql-parser,@memberjunction/sql-dialect,@memberjunction/core-entities-server,@memberjunction/cli): stored queries are written in a specified language (guides/MJ_QUERY_LANGUAGE.md), checked on save and before every render, with fields and parameters taken from the database server’s description of the query. (#6124) - Alternate Base Views and server-set query parameters (
@memberjunction/core,@memberjunction/codegen-lib,@memberjunction/query-processor): an entity can register governed views with full column parity that return a curated row subset; query parameters can be server-set, andRequireApprovedruns only queries whose approved fingerprint still matches. (#6022, #4789) - Record cloning (
@memberjunction/record-cloning,@memberjunction/ng-record-clone,@memberjunction/core-actions): copy a record and the related records its clone configuration names in one transaction, from a clone wizard or theClone Record/Clone Recordsactions, with lineage in Record Changes andMJ: Record Clone Logs. Template users build on it: a user flaggedIsTemplatecan be copied whole, at first sign-in or withmj user clone. (#4585, #5518) - Durable Work Queue and Messaging Framework (
@memberjunction/work-queue-core,@memberjunction/work-queue-engine,@memberjunction/work-queue-server,@memberjunction/work-queue-aws): topics, subscriptions, leases, retries, dead letters and ordered partitions over a database transport or SNS/SQS FIFO, with a dashboard andmj queue. Durable entity actions enlist in the save’s transaction when a durable submitter is registered. (#6198) - Binary fields and faster vector search (
@memberjunction/core,@memberjunction/ai-vectors-memory): binary columns are base64 strings above the database, embeddings gain a binary float32 copy that loads about 14 times faster than JSON, and server-side search runs on a worker-thread pool. (#4978) - Live JSONType accessors with opt-in validation (
@memberjunction/core,@memberjunction/codegen-lib): in-place edits to a JSONType accessor persist, and@mjValidategenerates a Zod schema and aValidate()check. (#4830) - Content ingestion pipeline and Semantic Graph (
@memberjunction/content-pipeline,@memberjunction/content-pipeline-base,@memberjunction/record-set-processor): Discover, Extract, Tag, Segment, Embed and Delete stages over content sources, an upload source for application files, and graph entities that Knowledge Hub visualizes. (#4986, #6230) - Feature Pipelines (
@memberjunction/feature-pipelines,@memberjunction/feature-pipelines-engine,@memberjunction/ng-record-process-studio): declarative pipelines with pipeline types, keyed and versioned feature values that do not overwrite a person’s entries, gated versions, and a Feature Values panel on every record form. (#4636, #4841) - Calendar events and the Calendar view type (
@memberjunction/communication-engine,@memberjunction/communication-ms-graph,@memberjunction/communication-gmail,@memberjunction/ng-entity-viewer): providers create, update, cancel and sync calendar events linked to any record, and entity views can show records on a day, week or month layout. The realtime bridge’sGraphCalendarClientandGoogleCalendarClientare removed in favour of the providers. (#4789) - Per-connection integration catalog (
@memberjunction/integration-engine,@memberjunction/integration-engine-base): each connection gets its own copy of its connector’s objects and fields. (#4412, #4413, #4415) - Archive Purge mode (
@memberjunction/archiving-engine):StorageMode = Purgestrips fields or hard-deletes without writing a copy, and refuses entities that cannot be purged safely. (#5794)
Explorer and UI
- Form contributions (
@memberjunction/ng-base-forms,@memberjunction/ng-core-entity-forms): panels mounted on an entity’s form from metadata at User, Role or Global scope, placed and managed from the form itself. (#4311) - Login Studio (
@memberjunction/theme-engine,@memberjunction/ng-explorer-app,@memberjunction/server): design and publish Explorer’s sign-in page;GET /auth/login-screenserves the sanitized published design. (#5527) - Dashboards as an application, record links and version history, phone-optimized forms (
@memberjunction/ng-dashboards,@memberjunction/ng-base-forms,@memberjunction/ng-record-changes): dashboards get their own application with an AI assistant, properties and wires; forms show links in both directions, a record-changes drawer with version previews and a toolbar registry; forms adapt to screens 768px wide or less. (#4982, #5999, #6008, #6267) - Simpler record toolbar (
@memberjunction/ng-base-forms): each user pins up to three actions; the rest move to a More panel, and layout controls to a View panel. (#4779) - Video Studio and the Excel add-in (
@memberjunction/video-studio,@memberjunction/excel-addin,@memberjunction/excel-addin-server): code-rendered video production with Brand Kits, and an Open in Excel export that downloads a workbook filled with what the person opening it can see. (#5055, #6214) - Interactive diagrams, math and inline Office previews (
@memberjunction/ai-diagrams,@memberjunction/ng-markdown,@memberjunction/ng-artifacts):mj-diagramfences render interactive SVG architecture diagrams, TeX and MathML render in chat and markdown, and.docx,.xlsxand.xlspreview in the Files form. (#6222, #5525, #4959) - Predictive Studio, mobile app v6 and UI building blocks: Predictive Studio is redesigned around an AG Grid and Graph View with reproducible training and out-of-sample metrics; the mobile app moves to the shared conversations runtime; new bar, donut and area chart widgets and an
mj-menu. (#4616, #5978, #4459, #5368)
Operations and tooling
- Diagnostic Bundles (
@memberjunction/diagnostics,@memberjunction/diagnostics-server,@memberjunction/ng-diagnostics,@memberjunction/cli): encrypted, signed.mjdiagexports of server logs, SQL, client network activity and telemetry, withmj diag. (#6263) - MJAPI under a path prefix and in split roles (
@memberjunction/server):MJAPI_BASE_PATHmounts every route under a prefix and Explorer’sMJAPI_URIpoints at it; replicas can split into API and worker roles with pluggable broadcast providers;SIGHUPreloads metadata without a restart. (#5677, #5944, #4804) - Installer sets up the database, on SQL Server or PostgreSQL (
@memberjunction/installer,@memberjunction/cli):mj installcreates the database and logins when given an administrator login, which is never saved.mj agent initscaffolds a citizen agent builder workspace. (#5506, #5511, #4620) - Local development sign-in (
@memberjunction/auth-providers,@memberjunction/server):AuthProvider: "local"issues local tokens for development; the server refuses to start with it in production. - Scoped notification configs, provider-neutral web search, DBAutoDoc plugins and People Data Labs: notification channels per application, role, user or origin; one
Web Searchaction routing across Brave, Perplexity, Tavily, Google and DuckDuckGo; a DBAutoDoc Index Advisor; and People Data Labs enrichment actions. (#4961, #4488, #5258, #5557)
Improvements
Section titled “Improvements”- Prompt caching and cost on Loop agents (
@memberjunction/ai-agents,@memberjunction/ai-prompts): per-iteration state moves out of the system prompt into a trailing<mj-runtime-state>message, so provider prefix caches stay warm; measured cached input rose to 66–96% and prompt cost per million tokens fell 37–80%. (#5800) - Agents stop retrying tools that cannot succeed (
@memberjunction/ai-agents): a run-scoped circuit breaker disables an action after a fatal configuration error, two identical failing calls or five consecutive failures. - Faster saves and reads (
@memberjunction/sqlserver-dataprovider,@memberjunction/generic-database-provider,@memberjunction/core): SQL Server saves use typed parameters so one plan is reused per entity and field set;SkipTotalRowCountskips the count query; RunView batches its queries and reads only the columns asked for; IS-A subtypes and parents resolve from caches; cross-replica invalidation sends row deltas; and an idle MJAPI stops polling its database. (#5777, #4025, #4450, #4787, #6271, #6186) - Transactions stay with the caller that opened them (
@memberjunction/generic-database-provider,@memberjunction/core): a transaction opened on a shared provider belongs to its async scope, so concurrent requests no longer run inside someone else’s transaction. (#4798) - Caches hold large datasets and stay consistent (
@memberjunction/core,@memberjunction/server): the per-entry ceiling is derived from the budget (75% by default, was a fixed 25%), cached RunQuery results are tied to the query definition, and 22 log, run and audit entities stop taking part in caching. (#4445, #5703, #5141) - Search ranks multi-source results by Reciprocal Rank Fusion (
@memberjunction/search-engine,@memberjunction/ng-search). (#4993) - Integration sync accuracy and memory (
@memberjunction/integration-engine): reported counts match what a sync did, discovery stops at a memory budget, large syncs release response pages (over 2 GB saved), and deactivating a connection pauses its schedules. (#4455, #4617, #6266) - SQL dialect follows the database (
@memberjunction/sql-dialect,@memberjunction/ai-agents): agents on PostgreSQL get PostgreSQL syntax. (#4431) mj synckeeps@env:references and pushes portable SQL (@memberjunction/metadata-sync): pull no longer writes resolved secrets into files,@lookupvalues become natural-key subqueries, and deletes run in dependency order. (#5884, #6069)- Explorer: preview tabs are kept once edited, streamed replies render in place, deleting a record closes its tab, and a record in a custom form can open in the standard form. (#5070, #4998, #5879, #4766)
- Accessibility: form controls gain
AriaLabel,AriaLabelledBy,AriaDescribedByandInputId, and hover-only row actions also appear on keyboard focus.
Bug Fixes
Section titled “Bug Fixes”- A durable action’s submission log row survives the save that queued it (
@memberjunction/core,@memberjunction/generic-database-provider,@memberjunction/actions,@memberjunction/sqlserver-dataprovider): fixed in 6.2.1. With a durable submitter registered, ActionEngine’s log row was queued inside the save’s transaction and rejected after commit, so the run left no Action Execution Log row (#6251).BaseEntitySaveQueuegains an opt-indetachFromTransactionoption that only ActionEngine’s log queue uses. (#6351) - Records saved in a rolled-back transaction no longer stay cached (
@memberjunction/core): engine cache changes raised inside a transaction apply on commit and are dropped on rollback, using pre-delete primary keys. - A failed IS-A chain save or delete leaves every level as it was (
@memberjunction/core). (#4916) - Agent replies survive a WebSocket that dies without closing (
@memberjunction/graphql-dataprovider,@memberjunction/ng-conversations,@memberjunction/server,@memberjunction/redis-provider): the client detects a silent socket within about 14 seconds, reconciles over HTTP, and status reaches the browser across replicas through Redis. (#4540) - Anonymous visitors isolated from each other (
@memberjunction/server,@memberjunction/livekit-room-server): every anonymous guest shared one Anonymous user, so a visitor who learned another’s session ID could relay into, close or restore it. Sessions, runs and rooms now check a per-visitor identity. (#5997, #6065) - Second user records on sign-in, and Microsoft sign-in switching accounts (
@memberjunction/server,@memberjunction/ng-auth-services): a user added outside the sign-in flow no longer gets a duplicateUseron first login, and MSAL resumes only the account it signed in with. (#4549, #6103) - Security hardening (
@memberjunction/global,@memberjunction/server,@memberjunction/component-registry-server,@memberjunction/ng-whiteboard, and others): field transforms run in an AST interpreter instead ofnew Function, the expression evaluator allows only listed identifiers, request-built filters validate UUIDs and escape strings, token lookups are constant-time, client code accepts onlyhttp:andhttps:URLs, and exported whiteboards cannot inject markup. (#6034, #5583, #5569) - Client-side search returned nothing without a read-only login (
@memberjunction/server):SearchEntitiesnow falls back to the read-write provider. - Integration incremental syncs skipped rows (
@memberjunction/integration-engine): the incremental filter stays at the run’s starting boundary, and a moved incremental cursor resets that object’s watermark. (#4423) - CodeGen metadata drift (
@memberjunction/codegen-lib):EntityFieldrows stay in step with regenerated views and procedures, orphaned fields are pruned, config-declared virtual entities finish in one run, and a failed step fails the run. (#6067, #6077, #4828) - Vector and duplicate-detection fixes (
@memberjunction/ai-vector-sync,@memberjunction/ai-vector-dupe,@memberjunction/search-engine): vector indexes are addressed by their provider-side name, Simple Vector Service searches work, and vector queries are scoped to the run’s Entity Document. (#4962, #4925, #6033) - Deleting a tracked record that cascades (
@memberjunction/sqlserver-dataprovider) no longer fails with SQL error 213, and Record Change text outside the database code page is no longer stored as?. (#5778, #5619) - PostgreSQL (
@memberjunction/codegen-lib,@memberjunction/postgresql-dataprovider,@memberjunction/generic-database-provider,@memberjunction/sql-converter): enabling full-text search creates its objects, a dropped idle connection is logged instead of crashing MJAPI, filtered saved views run, and migration conversion handles BIT literals, bracket identifiers andIDENTITYseeds. (#4425, #5993, #6223, #6130) - Realtime calls (
@memberjunction/realtime-runtime,@memberjunction/ai-agents,@memberjunction/server): co-agent runs record their cost and are no longer marked Failed, recordings store for UI-role users and recover from crash shards, and the recording ledger can no longer be cleared by a stale session save. (#5058, #5245, #6020) - Record Processes and scheduled jobs: pause and cancel work again, a run detail row no longer fails its foreign key to the action log, and a job activated while the server runs gets its
NextRunAtat once. (#6027, #6045, #5575) - Smaller fixes: Templates form saves its content (#4696); a
Whileloop with an unevaluable condition fails (#4765); an empty string is no longer flagged as a missing required field (#4644); saving a default Data Explorer view with a filter works (#4704); Ctrl/Cmd+/ opens the command palette (#3762); agents with several storage accounts no longer fail (#5585); TextChunker keeps all text (#5361); provider and driver instances are cached or disposed instead of leaked (#4619);@foblex/flowis pinned to 18.0.0 to keep the flow editor working (#5998).
Already shipped on the 6.1 line
Section titled “Already shipped on the 6.1 line”These fixes appear in the 6.2 Edge notes but were backported to 6.1 and are not new to a 6.1.6 install. They are listed so an upgrader from an earlier 6.1 patch can find them; details are in the 6.1.x notes.
- 6.1.2: Gemini 3.8 Live and Extended Thinking, change-driven remote browser screencast, whiteboard edits confirmed only on success, realtime endpoint on by default (#4512, #4543).
- 6.1.3: task-graph dispatcher procedures,
mj sync pushall-or-nothing, deferred work after commit, engine derived state after a cross-server cache update (#4575, #4550, #4565, #4470). - 6.1.4: cache-invalidation row data allowlist, saved-view tab freeze, 5.51 client deletes, grid exports, foreign-key picker dismissal, test-harness data caps (#4595, #4723, #4735, #4725, #4682, #4702).
- 6.1.5:
MaxRowspaging withoutStartRow, durable entity action parameters, magic-link redemption procedure, query rendering and PostgreSQL provider fixes, double-quoted template literals, metadata snapshot memory, date-only formatting, Open App schema ownership, no CDN preload at bootstrap, Business Central connections,complete_taskand native tool-calling fixes, spoken updates keeping the persona, hidden realtime turns for magic-link users (#4703, #4796, #4762, #5040, #4971, #4967, #4760, #4943, #4904, #5052, #4688, #4797). - 6.1.6: the security series (#4782, #5264 to #5273), record names under field-level security (#5004),
RuntimeOnlycredential scope (#5063), Redis outage recovery (#4974), schema-hash eviction loops (#5703), cancelled prompts stop failover (#5647), Gemini effort levels and sampling fields (#5590, #5185), Grok Build effort level (#5591), “In-Progress” replies,complete_taskescapes (#5769), create RLS checks on NULL columns and editable role filters (#5638, #5752), colocated vector databases (#4924), duplicate detection memory, template text and record filter (#4693, #5204, #5205), Box token renewal (#5146),mj sync pullbackups and push change detection (#4461, #4976),mj app upgradeschema name (#4780), linear-time mention and error parsing (#5549, #4810), agent voice in Gemini recordings (#5155), realtime tools and durable flow data (#4963), dropped connections classified as network errors (#5489).