Member Junction
    Preparing search index...

    Server-side MJ: Users entity enforcing MJ's privilege-elevation invariant (issue #4260).

    WHY THIS EXISTS AT ALL. User.Type is the column every Owner check in the platform reads — SqlLoggingConfigResolver, magic-link canIssueInvites, the backup-system-user fallback in MJServer's bootstrap. Writing it is therefore equivalent to granting yourself the platform's superuser level. Nothing below this class stops that: on the baseline seed the Developer and Integration roles hold unfiltered CanCreate/CanUpdate/CanDelete on MJ: Users (verified against a live database, not just the seed), AllowUpdateAPI/AllowDeleteAPI are true on the entity, AllowUpdateAPI is also true on both the Type and Name fields, Name has no unique index, and CodeGen has already issued GRANT EXECUTE on the relevant stored procedures to those roles' DB roles.

    WHY NOT ROW-LEVEL SECURITY. MJ's only field-adjacent access control is RowLevelSecurityFilter, and an "own row only" update filter does NOT close this: scoping the update to the caller's own row still permits setting one's OWN Type to 'Owner'. There is no per-role FIELD permission in MJ, and setting EntityField.AllowUpdateAPI = 0 on Type would block Owners too, breaking every legitimate admin path. An invariant in the save/delete path is the only mechanism that expresses the actual rule.

    WHY HERE RATHER THAN IN A RESOLVER. Validate() runs inside BaseEntity.Save() and this class also overrides Save() and Delete(), so all five hold on every write path — GraphQL resolvers, Remote Operations, the Create/Update/Delete Record actions, metadata sync, one-off scripts — and for any role a deployment invents, not just the two seeded ones. A resolver-level check would cover one door in a building with several.

    The Save() override is what makes that sentence literally true rather than nearly true. Validate() alone does NOT cover every write path: BaseEntity.Save() force-passes validation without calling Validate() when EntitySaveOptions.ReplayOnly is set (baseEntity.ts:3725), and ReplayOnly does not suppress the write. Invariants 1-4 were therefore skippable by an option, while invariant 5 was not — Delete() being an override. See Save() below for the reachability analysis and why the fix refuses rather than re-validates.

    THE INVARIANTS, for a caller whose Type is not 'Owner':

    1. Creating a MJ: Users row at all is refused. This is stricter than "may not create an Owner": there are FOUR automated creators of this entity — NewUserBase.createNewUser (MJServer/src/auth/newUsers.ts), MagicLinkService's provisioning path (MJServer/src/auth/magicLink/MagicLinkService.ts), and CreateNewUserBase.createNewUser (CodeGenLib/src/Misc/createNewUser.ts:33, a CLI provisioning tool that sets Type='Owner' unconditionally at :39 — already refused for a non-Owner caller before this round, regardless of the analysis below). The first two run as ResolveConfiguredPrincipal(...), whose ladder is: rung 1 matches the configured string against User.Name, rung 2 against User.Email — NEITHER rung filters by Type (MJServer/src/auth/principals.ts:134,141) — and only rungs 3-4 (System-by-ID, then lowest-ID-among-ACTIVE-Owners) guarantee an Owner. So "no legitimate path creates a user row as a non-Owner" is NOT unconditional: it holds only while a deployment's contextUserForNewUserCreation / contextUserForProvisioning names an Owner-type user's Name or Email (the shipped default, not.set@nowhere.com, resolves by Email to the seeded Owner, so default installs are unaffected). A deployment that instead points either setting at a non-Owner user will have JWT auto-provisioning and magic-link provisioning fail CLOSED at Save() after this change — loudly, not silently — rather than continuing to create rows as that non-Owner; see the changeset for the upgrade note. Separately, Explorer's user-management UI has NO Owner gate today (no such guard exists in user-management.component.ts or its module), so a Developer-role non-Owner reaches it in practice and will now receive this same create/delete refusal there — a real consequence for such deployments, not a hypothetical one. A FOURTH creator exists and is not config-driven: SyncRolesUsersResolver.AddNewUsers (MJServer/src/resolvers/SyncRolesUsersResolver.ts:343), whose sibling UpdateExistingUsers also sets Name AND Type unconditionally on every synced row and whose DeleteSingleUser deletes. All three carry @RequireSystemUser(), and getSystemUser() resolves the seeded Type='Owner' system user, so the guard exempts them on a default install — but a deployment whose system user is NOT an Owner will see that sync path fail closed too, for the same reason as the config-driven pair above. Note also that DeleteSingleUser reads a false from Delete() as an FK-constraint condition and downgrades to a soft delete; invariant 5 gives that same false a second meaning (non-Owner caller), which that call site does not distinguish. Refusing only Type='Owner' on create is NOT enough on its own: Name has no unique index and both seeded non-Owner roles hold CanCreate, so a non-Owner could otherwise repeatedly Create rows named to match the configured principal string until one sorts below the real system user by ID — the exact principal-redirection invariant 4 (below) exists to prevent, just reached through INSERT instead of UPDATE.
    2. Type may not be changed on an EXISTING row. It is a two-value CHECK column ('User' | 'Owner'), so any change by a non-Owner is either self-promotion or demoting somebody else. (Creation is already covered by invariant 1, so this only needs to consider updates.)
    3. The row must be the caller's own, compared against the PRE-SAVE ID. ID is a primary-key field — EntityFieldInfo.ReadOnly is true for IsPrimaryKey, and EntityField.Value's setter silently ignores writes to a ReadOnly field after the record's initial hydration — so on a genuinely LOADED row this.ID is not reassignable through ordinary means. The pre-save value still matters for a narrower reason: it ties this guard to the row identity established the last time the object was actually loaded/hydrated from the database, which is what ResolverBase.UpdateRecord does first for any entity with TrackRecordChanges=1 (as MJ: Users has) — rather than trusting whatever the in-memory object merely arrived holding. If that pre-save identity cannot be established at all, the guard fails CLOSED (refuses the save) instead of silently permitting it — see validateOwnRowOnly.
    4. Name may not be changed on an existing row. Invariants 2-3 do NOT cover this — renaming yourself is editing your own row. resolvePrincipalFrom (MJServer auth/principals.ts) resolves contextUserForNewUserCreation / contextUserForProvisioning / contextUserForLookup against User.Name FIRST, breaking ties by lowest ID, so a user who can rename themselves to the configured string and who sorts below the real system user becomes the principal the server acts as. That ordering is deliberate (backward compatibility) and is only sound while Name is not writable by untrusted parties; this invariant is what makes that true. Name is the login identifier — auto-provisioning sets Name = email — while FirstName / LastName / Title are the display fields and stay freely editable. Email is the ladder's OTHER rung (principals.ts:141) with the IDENTICAL lack of a Type filter, and is deliberately left mutable here — not overlooked. Two things narrow it: (a) MJ: Users.Email carries the database's UQ_User_Email unique constraint, so redirecting the Email rung to your own row requires the configured candidate to match NO active user at all — already the misconfiguration case this file's docs (and resolvePrincipalFrom's own per-redeem logging) already surface loudly, not a quiet success path; and (b) even granting that misconfiguration, invariants 1 and 3 mean the payoff is no longer elevation: whatever row a provisioning path resolves its principal to, THIS guard still checks that resolved principal's actual Type before permitting the write it is attempting, so a non-Owner who gets themselves matched by the Email rung still cannot create or promote anything through it — the provisioning operation that would have run as them instead fails CLOSED. Freezing Email too would add friction to an already-narrow, already-loud misconfiguration path without closing any route that is still open.
    5. Deleting a MJ: Users row at all is refused (see the Delete() override below). MJ deactivates users via IsActive; it does not delete them. An unguarded delete would let a non-Owner remove ANY account — Owners included, which destroys the very accounts every exemption above depends on.

    Owner-type callers are exempt from all five — CONDITIONALLY on the deployment's own configuration keeping contextUserForNewUserCreation / contextUserForProvisioning pointed at an Owner (see invariant 1 above for why that is not automatic). Provided it is, this keeps admin user management working, and it keeps auto-provisioning working — NewUserBase.createNewUser runs as contextUserForNewUserCreation, which resolves to the seeded system user (Type='Owner') under the shipped default. A caller-less save (no ActiveUser at all — e.g. a system/CLI path running under a bound provider default) is likewise treated as exempt, though for Save() this is effectively decorative: BaseEntity.CheckPermissions already throws on a falsy ActiveUser and runs BEFORE Validate() inside Save(), so in production a caller-less Save() never reaches this guard's Validate() body at all — see the "no caller" test for the exact call ordering. Delete()'s sequencing is the OPPOSITE and the "no caller ⇒ exempt" default IS load-bearing there — see callerIsOwner()'s docstring.

    Pure: reads only this record's own field state and the caller. No RunView, no provider, no engine, no I/O — so it costs nothing per save/delete and is unit-testable without a database.

    Hierarchy (View Summary)

    Index

    Constructors

    Properties

    Accessors

    Methods

    Constructors

    Properties

    MAX_RESULT_HISTORY: 50

    Maximum number of BaseEntityResult entries retained in _resultHistory per entity instance. Set to 50 — enough for diagnostic context while bounding worst-case memory for entities that survive thousands of Save/Delete cycles.

    Accessors

    • get __mj_CreatedAt(): Date
      • Field Name: __mj_CreatedAt
      • Display Name: __mj _Created At
      • SQL Data Type: datetimeoffset
      • Default Value: getutcdate()

      Returns Date

    • get __mj_UpdatedAt(): Date
      • Field Name: __mj_UpdatedAt
      • Display Name: __mj _Updated At
      • SQL Data Type: datetimeoffset
      • Default Value: getutcdate()

      Returns Date

    • get ActiveUser(): UserInfo

      Internal helper method for the class and sub-classes - used to easily get the Active User which is either the ContextCurrentUser, if defined, or the Metadata.Provider.CurrentUser if not.

      Returns UserInfo

    • get ContextCurrentUser(): UserInfo

      Returns UserInfo

    • set ContextCurrentUser(user: UserInfo): void

      The ContextCurrentUser is a property used to manually set the "current" user for scenarios, primarily on the server side, where the user changes per request. For situations where there is no global CurrentUser in the Metadata.Provider, you MUST set this property to the user you want to use for the current operation. If you used Metadata.GetEntityObject() to get the entity object, this property will be set automatically for you as that method has a parameter that can be provided for the ContextCurrentUser.

      Parameters

      Returns void

    • get DefaultSkipAsyncValidation(): boolean
      Protected

      Default value for whether async validation should be skipped. Subclasses can override this property to enable async validation by default. When the options object is passed to Save(), and it includes a value for the SkipAsyncValidation property, that value will take precedence over this default.

      Returns boolean

      Save

    • get Dirty(): boolean

      Returns true if the object is Dirty, meaning something has changed since it was last saved to the database, and false otherwise. For new records, this will always return true.

      Returns boolean

    • get Email(): string
      • Field Name: Email
      • SQL Data Type: nvarchar(100)
      • Description: Unique email address for the user. This field must be unique across all users in the system.

      Returns string

    • set Email(value: string): void

      Parameters

      • value: string

      Returns void

    • get EmployeeEmail(): string
      • Field Name: EmployeeEmail
      • Display Name: Employee Email
      • SQL Data Type: nvarchar(100)

      Returns string

    • get EmployeeFirstLast(): string
      • Field Name: EmployeeFirstLast
      • Display Name: Employee First Last
      • SQL Data Type: nvarchar(81)

      Returns string

    • get EmployeeID(): string
      • Field Name: EmployeeID
      • Display Name: Employee
      • SQL Data Type: uniqueidentifier
      • Related Entity/Foreign Key: MJ: Employees (vwEmployees.ID)

      Returns string

    • set EmployeeID(value: string): void

      Parameters

      • value: string

      Returns void

    • get EmployeeSupervisor(): string
      • Field Name: EmployeeSupervisor
      • Display Name: Employee Supervisor
      • SQL Data Type: nvarchar(81)

      Returns string

    • get EmployeeSupervisorEmail(): string
      • Field Name: EmployeeSupervisorEmail
      • Display Name: Employee Supervisor Email
      • SQL Data Type: nvarchar(100)

      Returns string

    • get EmployeeTitle(): string
      • Field Name: EmployeeTitle
      • Display Name: Employee Title
      • SQL Data Type: nvarchar(50)

      Returns string

    • get EntityInfo(): EntityInfo

      Access to the underlying metadata for the entity object.

      Returns EntityInfo

    • get Fields(): EntityField[]

      Returns EntityField[]

    • get FirstLast(): string
      • Field Name: FirstLast
      • Display Name: First Last
      • SQL Data Type: nvarchar(101)

      Returns string

    • get FirstName(): string
      • Field Name: FirstName
      • Display Name: First Name
      • SQL Data Type: nvarchar(50)
      • Description: User's first name or given name.

      Returns string

    • set FirstName(value: string): void

      Parameters

      • value: string

      Returns void

    • get FirstPrimaryKey(): EntityField

      Helper method to return just the first Primary Key

      Returns EntityField

    • get ID(): string
      • Field Name: ID
      • SQL Data Type: uniqueidentifier
      • Default Value: newsequentialid()

      Returns string

    • set ID(value: string): void

      Parameters

      • value: string

      Returns void

    • get ISAChild(): BaseEntity<unknown>

      Returns the child entity in the IS-A composition chain, or null if this entity has no child record, hasn't been loaded yet, or is an overlapping subtype parent (use ISAChildren instead for overlapping parents).

      Example: For a MeetingEntity where a Webinar record exists with the same PK, ISAChild returns the WebinarEntity instance.

      Returns BaseEntity<unknown>

    • get ISAChildren(): { entityName: string }[]

      For overlapping subtype parents (AllowMultipleSubtypes = true), returns the list of child entity type names that have records for this PK. For disjoint parents or non-parent entities, returns null (use ISAChild instead).

      Example: For a PersonEntity with AllowMultipleSubtypes=true, might return [{entityName: 'Members'}, {entityName: 'Volunteers'}, {entityName: 'Speakers'}].

      Returns { entityName: string }[]

    • get IsActive(): boolean
      • Field Name: IsActive
      • Display Name: Is Active
      • SQL Data Type: bit
      • Default Value: 0
      • Description: Whether this user account is currently active and can log in.

      Returns boolean

    • set IsActive(value: boolean): void

      Parameters

      • value: boolean

      Returns void

    • get ISAParent(): BaseEntity<unknown>

      Returns the parent entity in the IS-A composition chain, or null if this entity is not an IS-A child type.

      Example: For a MeetingEntity that IS-A ProductEntity, ISAParent returns the ProductEntity instance.

      Named with ISA prefix to avoid collision with generated entity properties (many entities have a Parent string column in the database).

      Returns BaseEntity<unknown>

    • get ISAParentEntity(): BaseEntity<unknown>

      Returns BaseEntity<unknown>

      Use ISAParent instead. Kept for backward compatibility.

    • get IsBusy(): boolean

      Returns true if any operation (Save, Delete, or Load) is currently in progress. This is a convenience property that combines IsSaving, IsDeleting, and IsLoading. Useful for disabling UI elements when any database operation is happening.

      Returns boolean

    • get IsDeleting(): boolean

      Returns true if a Delete operation is currently in progress. This is useful for UI components to show loading indicators or disable buttons while deleting.

      Returns boolean

    • get IsLoading(): boolean

      Returns true if a Load operation is currently in progress. This is useful for UI components to show loading indicators while data is being fetched.

      Returns boolean

    • get IsSaved(): boolean

      Returns true if the record has been saved to the database, false otherwise. This is a useful property to check to determine if the record is a "New Record" or an existing one.

      Returns boolean

    • get IsSaving(): boolean

      Returns true if a Save operation is currently in progress. This is useful for UI components to show loading indicators or disable buttons while saving.

      Returns boolean

    • get LastName(): string
      • Field Name: LastName
      • Display Name: Last Name
      • SQL Data Type: nvarchar(50)
      • Description: User's last name or surname.

      Returns string

    • set LastName(value: string): void

      Parameters

      • value: string

      Returns void

    • get LatestResult(): BaseEntityResult

      Returns the most recent result from the result history. If there are no results in the history, this method will return null.

      Returns BaseEntityResult

    • get LeafEntity(): BaseEntity

      Returns the leaf (most-derived) entity in the IS-A chain, walking downward through child references. Returns this if no child exists.

      For overlapping subtype parents (AllowMultipleSubtypes = true), returns this because there is no single child chain to follow — the parent is the leaf from its own perspective.

      Returns BaseEntity

    • get LinkedEntityID(): string
      • Field Name: LinkedEntityID
      • Display Name: Linked Entity ID
      • SQL Data Type: uniqueidentifier
      • Related Entity/Foreign Key: MJ: Entities (vwEntities.ID)

      Returns string

    • set LinkedEntityID(value: string): void

      Parameters

      • value: string

      Returns void

    • get LinkedEntityRecordID(): string
      • Field Name: LinkedEntityRecordID
      • Display Name: Linked Entity Record ID
      • SQL Data Type: nvarchar(450)
      • Description: ID of the specific record this user is linked to.

      Returns string

    • set LinkedEntityRecordID(value: string): void

      Parameters

      • value: string

      Returns void

    • get LinkedRecordType(): string
      • Field Name: LinkedRecordType
      • Display Name: Linked Record Type
      • SQL Data Type: nchar(10)
      • Default Value: None
      • Description: Type of record this user is linked to (None, Employee, Contact, etc.).

      Returns string

    • set LinkedRecordType(value: string): void

      Parameters

      • value: string

      Returns void

    • get Name(): string
      • Field Name: Name
      • SQL Data Type: nvarchar(100)

      Returns string

    • set Name(value: string): void

      Parameters

      • value: string

      Returns void

    • get PrimaryKey(): CompositeKey

      Returns the primary key for the record. The CompositeKey class is a multi-valued key that can have any number of key/value pairs within it. Always traverse the full set of key/value pairs to get the full primary key for the record.

      Returns CompositeKey

    • get PrimaryKeys(): EntityField[]

      Returns an array of all primary key fields for the entity. If the entity has a composite primary key, this method will return an array of all primary key fields. If the entity has a single primary key, this method will return an array with a single field in it.

      Returns EntityField[]

    • get ProviderToUse(): IEntityDataProvider

      Returns this provider to be used for a given instance of a BaseEntity derived subclass. If the provider is not set, the BaseEntity.Provider is returned.

      Returns IEntityDataProvider

    • get ProviderTransaction(): unknown

      Gets the provider transaction handle for IS-A chain orchestration.

      Returns unknown

    • set ProviderTransaction(value: unknown): void

      Sets the provider transaction handle. Used during IS-A save/delete to share a single database transaction across the entire parent chain.

      Parameters

      • value: unknown

      Returns void

    • get RecordChanges(): Promise<RecordChange[]>

      Returns a list of changes made to this record, over time. Only works if TrackRecordChanges bit set to 1 on the entity you're working with.

      Returns Promise<RecordChange[]>

    • get RecordLoaded(): boolean

      Returns true if the record has been loaded from the database, false otherwise. This is useful to check to see if the record is in a "New Record" state or not.

      Returns boolean

    • get RestoreContext(): RestoreContext

      Returns the active restore context for the next save, if any.

      Read by the data provider when generating the RecordChange SQL: when non-null, the resulting RecordChange row is written with Source='Restore', RestoredFromID = SourceChangeID, and RestoreReason = Reason. Returns null for ordinary saves.

      Returns RestoreContext

    • get ResultHistory(): BaseEntityResult[]

      The result history shows the history of the attempted transactions (Save and Delete) for this particular entity object. This is useful for tracking the results of operations on the entity object.

      Returns BaseEntityResult[]

    • get RootEntity(): BaseEntity

      Returns the root (least-derived) entity in the IS-A chain, walking upward through parent references. Returns this if no parent exists.

      Returns BaseEntity

    • get RunQueryProviderToUse(): IRunQueryProvider

      Returns the RunQueryProvider to be used for a given instance of a BaseEntity derived subclass.

      Returns IRunQueryProvider

    • get RunReportProviderToUse(): IRunReportProvider

      Returns the RunReportProvider to be used for a given instance of a BaseEntity derived subclass.

      Returns IRunReportProvider

    • get RunViewProviderToUse(): IRunViewProvider

      Returns the RunViewProvider to be used for a given instance of a BaseEntity derived subclass.

      Returns IRunViewProvider

    • get SkipEmbeddings(): boolean

      Returns boolean

    • set SkipEmbeddings(value: boolean): void

      Parameters

      • value: boolean

      Returns void

    • get Title(): string
      • Field Name: Title
      • Display Name: Title
      • SQL Data Type: nvarchar(50)
      • Description: User's professional title or salutation.

      Returns string

    • set Title(value: string): void

      Parameters

      • value: string

      Returns void

    • get TransactionGroup(): TransactionGroupBase

      Transaction Groups are used to group multiple transactions into a single ATOMic transaction in a database. They are also useful even in situations with ATOMicity is less important but you want to submit a group of changes to the API server in a single network call.

      Returns TransactionGroupBase

    • set TransactionGroup(group: TransactionGroupBase): void

      Parameters

      Returns void

    • get Type(): "User" | "Owner"
      • Field Name: Type
      • SQL Data Type: nchar(15)
      • Value List Type: List
      • Possible Values
        • Owner
        • User
      • Description: User account type (User, Guest, System, API).

      Returns "User" | "Owner"

    • set Type(value: "User" | "Owner"): void

      Parameters

      • value: "User" | "Owner"

      Returns void

    • get UserImageIconClass(): string
      • Field Name: UserImageIconClass
      • Display Name: User Image Icon Class
      • SQL Data Type: nvarchar(100)
      • Description: Font Awesome icon class for user avatar (e.g., "fa-solid fa-user-astronaut"). Used as fallback when UserImageURL is not provided. Example classes: "fa-solid fa-user", "fa-regular fa-circle-user", "fa-solid fa-user-tie".

      Returns string

    • set UserImageIconClass(value: string): void

      Parameters

      • value: string

      Returns void

    • get UserImageURL(): string
      • Field Name: UserImageURL
      • Display Name: User Image URL
      • SQL Data Type: nvarchar(MAX)
      • Description: User avatar image. Can be a Base64 encoded data URI (e.g., "data:image/png;base64,...") or a URL to an image file. Preferred over UserImageIconClass when present. Recommended for small thumbnail images only to maintain performance.

      Returns string

    • set UserImageURL(value: string): void

      Parameters

      • value: string

      Returns void

    • get Vectors(): Map<string, number[]>

      Utility storage for vector embeddings that represent the active record. Each string in the Map can be any unique key relative to the object so you can use this to track vectors associated with

      Returns Map<string, number[]>

    • get BaseEventCode(): string

      When a BaseEntity class raises an event with MJGlobal, the eventCode property is set to this value. This is used to identify events that are raised by BaseEntity objects. Any MJGlobal event that is raised by a BaseEntity class will use a BaseEntityEvent type as the args parameter

      Returns string

    • get Provider(): IEntityDataProvider

      Static property to get/set the IEntityDataProvider that is used by all BaseEntity objects. This is a global setting that is used by all BaseEntity objects. It can be overriden for a given BaseEntity object instance by passing in a provider to the constructor of the BaseEntity object. Typically, a provider will pass itself into BaseEntity objects it creates to create a tight coupling between the provider and the BaseEntity objects it creates. This allows multiple concurrent connections to exist in the same process space without interfering with each other.

      Returns IEntityDataProvider

    • set Provider(value: IEntityDataProvider): void

      Parameters

      Returns void

    Methods

    • Called before an Action is executed by the AI Engine This is intended to be overriden by subclass as needed, these methods called at the right time by the execution context

      Parameters

      Returns Promise<boolean>

    • Cascade-deletes an IS-A child record when the parent entity has CascadeDeletes enabled. Loads the child entity, then deletes it through the normal IS-A chain. The child's delete will cascade further down if it also has children and CascadeDeletes.

      Parameters

      • childCheck: { ChildEntityName: string; HasChildren: boolean }
      • parentOptions: EntityDeleteOptions

      Returns Promise<boolean>

    • Checks if this entity has any child records in IS-A child entity tables. Used for parent delete protection — a parent record cannot be deleted while child type records referencing it still exist.

      Returns Promise<{ ChildEntityName: string; HasChildren: boolean }>

      Object with HasChildren flag and the name of the child entity found

    • Utility method that returns true if the given permission being checked is enabled for the current user, and false if not.

      Parameters

      Returns boolean

    • Clears any pending restore context. Safe to call when no context is set. Recommended after Save() returns so a subsequent ordinary save isn't accidentally tagged as a restore.

      Returns void

    • This method MUST be called right after the class is instantiated to provide an async/await pair for any asynchronous operations a given entity needs to do when it is first created/configured. When you call Metadata/Provider GetEntityObject() this is done automatically for you. In nearly all cases you should go through GetEntityObject() anyway and not ever directly instantiate a BaseEntity derived class.

      Parameters

      Returns Promise<void>

    • This method will copy the values from the other entity object into the current one. This is useful for things like cloning a record. This method will ONLY copy values for fields that exist in the current entity object. If the other object has fields that don't exist in the current object, they will be ignored.

      Parameters

      • other: BaseEntity

        the other entity object to copy values from

      • OptionalincludePrimaryKeys: boolean

        if true, the primary keys will be copied as well, if false, they will be ignored, defaults to false and generally you want to leave it that way

      • OptionalreplaceOldValues: boolean

        if true, the old values of the fields will be reset to the values provided in the other parameter, if false, they will be left alone, defaults to false and generally you want to leave it that way

      Returns boolean

    • Refuses deletion of any MJ: Users row by a non-Owner caller. See invariant 5 above for why: MJ deactivates users via IsActive rather than deleting them, and an unguarded delete would let a non-Owner remove any account, including Owner accounts this class's other exemptions depend on.

      Reports the refusal the way MJListEntityServer.Delete does for its own row-level DELETE authorization check — a BaseEntityResult on the result history so LatestResult.CompleteMessage carries the reason (Delete() returns false on a logical rejection rather than throwing; see the CLAUDE.md Save/Delete error-handling contract) — rather than MJUserRoutineEntityServer's Delete() override, which is FK-cleanup ordering, not an authorization decision, and reports nothing beyond a bare false.

      Parameters

      Returns Promise<boolean>

    • In the BaseEntity class this method is not implemented. This method shoudl be implemented only in server-side sub-classes only by calling AIEngine or other methods to generate embeddings for a given piece of text provided. Subclasses that override this method to implement embedding support should also override

      Parameters

      • textToEmbed: string

      Returns Promise<SimpleEmbeddingResult>

      SupportsEmbedTextLocal and return true

    • Enforces disjoint subtype constraint during IS-A child entity creation. A parent record can only be ONE child type at a time. Checks all sibling child types (excluding self) for records with the same PK value. Throws if a sibling child record is found.

      Only called when the parent entity has AllowMultipleSubtypes = false (default). When AllowMultipleSubtypes = true, this check is skipped entirely, allowing overlapping subtypes (e.g., a Person can be both a Member and a Volunteer).

      Only runs on Database providers — client-side (Network/GraphQL) skips this because the server-side save will perform the check authoritatively.

      Returns Promise<void>

    • Returns a promise that resolves when the current Delete operation completes. If no Delete operation is in progress, resolves immediately.

      This is useful when you need to ensure a record is deleted before performing cleanup operations or navigating away from a view.

      Returns Promise<void>

      // Ensure any in-progress delete is complete before proceeding
      await entity.EnsureDeleteComplete();
      // Now safe to navigate away or perform cleanup
      navigateToList();
    • Returns a promise that resolves when the current Load operation completes. If no Load operation is in progress, resolves immediately.

      This is useful when you need to ensure data is loaded before accessing entity properties or performing operations that depend on loaded data.

      Returns Promise<void>

      // Ensure any in-progress load is complete before proceeding
      await entity.EnsureLoadComplete();
      // Now safe to access entity data
      console.log(entity.Name);
    • Returns a promise that resolves when the current Save operation completes. If no Save operation is in progress, resolves immediately.

      This is useful when you need to ensure data is persisted before performing a dependent operation, or when coordinating between multiple components that might trigger saves.

      Returns Promise<void>

      // Ensure any in-progress save is complete before proceeding
      await entity.EnsureSaveComplete();
      // Now safe to perform operations that depend on the saved state
      await someOperationThatNeedsSavedData(entity);
    • Strongly-typed wrapper for the SetMany method.

      Type Parameters

      • K extends AnyZodObject

      Parameters

      • data: unknown
      • Optionalschema: TypeOf<K>

        the zod schema to validate the data against

      Returns boolean

      data - the data to set on the entity object

    • Generates a vector embedding for a single text field using AI engine. Only generates embeddings for new records or when the source field has changed. Stores both the vector embedding and the model ID used to generate it.

      Parameters

      • field: EntityField

        The EntityField containing the text to embed

      • vectorField: EntityField

        The EntityField to store the generated vector embedding (as JSON string)

      • modelField: EntityField

        The EntityField to store the ID of the AI model used

      Returns Promise<boolean>

      Promise that resolves to true if embedding was generated successfully, false otherwise

    • Generates a vector embedding for a single text field identified by field name. Retrieves the field objects and delegates to GenerateEmbedding method.

      Parameters

      • fieldName: string

        Name of the text field to generate embedding from

      • vectorFieldName: string

        Name of the field to store the vector embedding

      • modelFieldName: string

        Name of the field to store the model ID used for embedding

      Returns Promise<boolean>

      Promise that resolves to true if embedding was generated successfully, false otherwise

    • Generates vector embeddings for multiple text fields using EntityField objects. Processes fields in parallel for better performance.

      Parameters

      • fields: { field: EntityField; modelField: EntityField; vectorField: EntityField }[]

        Array of field configurations with EntityField objects for source, vector, and model fields

      Returns Promise<boolean>

      Promise that resolves to true if all embeddings were generated successfully, false if any failed

    • Generates vector embeddings for multiple text fields by their field names. Processes fields in parallel for better performance.

      Parameters

      • fields: { fieldName: string; modelFieldName: string; vectorFieldName: string }[]

        Array of field configurations specifying source text field, target vector field, and model ID field names

      Returns Promise<boolean>

      Promise that resolves to true if all embeddings were generated successfully, false if any failed

    • Returns the value of the field with the given name. If the field is a date, and the value is a string, it will be converted to a date object.

      For IS-A child entities, parent fields return the authoritative value from _parentEntity.Get() (recursive for N-level chains), NOT the mirrored value on the child's own Fields array.

      Parameters

      • FieldName: string

      Returns any

    • NOTE: Do not call this method directly. Use the To method instead

      Utility method to create an object and return it with properties in the newly created and returned object for each field in the entity object. This is useful for scenarios where you need to be able to persist the data in a format to send to a network call, save to a file or database, etc. This method will return an object with properties that match the field names of the entity object.

      Parameters

      • OptionaloldValues: boolean

        When set to true, the old values of the fields will be returned instead of the current values.

      • OptionalonlyDirtyFields: boolean

        When set to true, only the fields that are dirty will be returned.

      Returns any

    • Returns a partial object that contains only the fields that have changed since the last time the record was saved. This is useful for scenarios where you want to send only the changes to the server or to a client. It is also helpful for quickly finding the fields that are "dirty".

      Returns Partial<T>

    • This utility method generates a completely new object that has properties that map to the fields and values in the entity at the time it is called. It is a copy, NOT a link, so any changes made to the object after calling this method will NOT be reflected in the object that is returned. This is useful for things like sending data to a client, or for use in a view model.

      Parameters

      Returns Promise<any>

    • This utility method calls GetDataObject() internally and formats the result as a JSON string. If you want to get the data as an object instead of a string, call GetDataObject() directly.

      Parameters

      Returns Promise<string>

    • Convenience method to access a field by code name. This method is case-insensitive and will return null if the field is not found.

      Parameters

      • codeName: string

      Returns EntityField

    • Convenience method to access a field by name. This method is case-insensitive and will return null if the field is not found. You can do the same thing with more fine tune controlled by accessing the Fields property directly.

      Parameters

      • fieldName: string

      Returns EntityField

    • Utility method to return the Name of the record (the value of the column that comes back from EntityInfo.NameField) from the current object. This avoids needing a network round trip to get the record name whenever we have the object already loaded in memory.

      Returns any

    • Parameters

      Returns Promise<{ Data: any[]; TotalRowCount: number }>

    • Resets this entity to a pristine state and populates it from the provided data object.

      Unlike SetMany, which incrementally updates existing field values, Hydrate() first resets ALL internal state — fields, composite key cache, loaded/saved flags — then populates from the provided data as if loading a fresh record from the database.

      This is critical for IS-A (table-per-type) inheritance: when a child entity loads its record, parent entities in the chain must be fully reset and re-populated from the child's view data, including the shared primary key. After init(), each EntityField's _NeverSet flag is true, allowing even ReadOnly PK fields to be set exactly once via SetMany.

      After population, entities are automatically marked as saved/loaded when all PK values are present (via UpdateSavedStateFromPrimaryKeys).

      The parent chain is handled recursively: if this entity has an IS-A parent, the parent is hydrated first (deepest ancestor first) via SetMany's built-in routing.

      Parameters

      • data: Record<string, unknown>

        A plain object whose properties map to field names on this entity (and potentially parent entities in the IS-A chain).

      Returns void

    • Discovers and initializes the IS-A child entity for a loaded record.

      After a record is loaded, this method checks whether a more-derived child entity record exists with the same primary key. If found, it creates the child entity instance, shares the current instance chain (so child._parentEntity === this), and recursively discovers further children down the hierarchy.

      This ensures that Save/Delete operations always delegate to the leaf entity, running the full validation and event chain at every level.

      Must be called AFTER a record is loaded (PK must be available). Skipped for entities that are not parent types or have already been discovered.

      Returns Promise<void>

    • Initializes the IS-A parent entity composition chain. For child type entities, this creates the parent entity instance (and recursively its parent, etc.) and caches the parent field name set for routing.

      Must be called AFTER EntityInfo is available but BEFORE any Load/NewRecord/Set/Get. This is called by Metadata.GetEntityObject() after constructing the entity.

      Returns Promise<void>

      • This method loads a single record from the database. Make sure you first get the correct BaseEntity sub-class for your entity by calling Metadata.GetEntityObject() first. From there, you can call this method to load your records.
      • NOTE: You should not be calling this method directly from outside of a sub-class in most cases. You will use the auto-generated sub-classes that have overriden versions of this method that blow out the primary keys into individual parameters. This is much easier to program against.

      Parameters

      • CompositeKey: CompositeKey

        Wrapper that holds an array of objects that contain the field name and value for the primary key of the record you want to load. For example, if you have a table called "Customers" with a primary key of "ID", you would pass in an array with a single object like this: {FieldName: "ID", Value: 1234}. *If you had a composite primary key, you would pass in an array with multiple objects, one for each field in the primary key. You may ONLY pass in the primary key fields, no other fields are allowed.

      • OptionalEntityRelationshipsToLoad: string[]

        Optional, you can specify the names of the relationships to load up. This is an expensive operation as it loads up an array of the related entity objects for the main record, so use it sparingly.

      Returns Promise<boolean>

      true if success, false otherwise

    • Loads the MJ: Users record from the database

      Parameters

      • ID: string
      • OptionalEntityRelationshipsToLoad: string[]

        (optional) the relationships to load

      Returns Promise<boolean>

      • true if successful, false otherwise

      MJUserEntity

    • Loads entity data from a plain object, typically from database query results.

      This method is meant to be used only in situations where you are sure that the data you are loading is current in the database. MAKE SURE YOU ARE PASSING IN ALL FIELDS. The Dirty flags and other internal state will assume what is loading from the data parameter you pass in is equivalent to what is in the database.

      Parameters

      • data: any

        A simple object that has properties that match the field names of the entity object

      • Optional_replaceOldValues: boolean

      Returns Promise<boolean>

      Promise - Returns true if the load was successful

      Generally speaking, you should use Load() instead of this method. The main use cases where this makes sense are:

      1. On the server if you are pulling data you know is fresh from the result of another DB operation
      2. If on any tier you run a fresh RunView result that gives you data from the database
      3. When the RunView Object RunView() method is called with ResultType='entity_object'

      Important for Subclasses: As of v2.53.0, this method is now async to support subclasses that need to perform additional asynchronous loading operations (e.g., loading related data, fetching additional metadata).

      Subclasses that need to perform additional loading should override BOTH this method AND Load() to ensure consistent behavior regardless of how the entity is populated. This is because these two methods have different execution paths:

      • Load() fetches data from the network/database and then calls provider-specific loading
      • LoadFromData() is called when data is already available (e.g., from RunView results)
      // Subclass implementation
      public override async LoadFromData(data: any, replaceOldValues: boolean = false): Promise<boolean> {
      const result = await super.LoadFromData(data, replaceOldValues);
      if (result) {
      // Perform additional async loading here
      await this.LoadRelatedData();
      await this.LoadMetadata();
      }
      return result;
      }

      // Don't forget to also override Load() for consistency, unless you INTEND to have different behavior
      // for Load() vs LoadFromData()
      public override async Load(ID: string, EntityRelationshipsToLoad: string[] = null): Promise<boolean> {
      const result = await super.Load(ID, EntityRelationshipsToLoad);
      if (result) {
      // Same additional loading as in LoadFromData
      await this.LoadRelatedData();
      await this.LoadMetadata();
      }
      return result;
      }
    • This method will create a new state for the object that is equivalent to a new record including default values.

      Parameters

      • OptionalnewValues: FieldValueCollection

        optional parameter to set the values of the fields to something other than the default values. The expected parameter is an object that has properties that map to field names in this entity. This is the same as creating a NewRecord and then using SetMany(), but it is a convenience/helper approach.

      Returns boolean

    • Propagates the ProviderTransaction handle down the IS-A parent chain so all entities in the chain execute on the same database transaction.

      Returns void

    • Used for raising events within the BaseEntity and can be used by sub-classes to raise events that are specific to the entity.

      Parameters

      • type:
            | "delete"
            | "new_record"
            | "save"
            | "load_complete"
            | "transaction_ready"
            | "save_started"
            | "delete_started"
            | "load_started"
            | "remote-invalidate"
            | "other"
      • payload: any
      • OptionalsaveSubType: "create" | "update"

      Returns void

    • Raises the transaction_ready event. This is used to indicate that the entity object is ready to be submitted for transaction processing. This is used by the TransactionGroup class to know when all async preprocessing is done and it can submit the transaction. This is an internal method and shouldn't be used by sub-classes or external callers in most cases. It is primarily used by Provider classes who are handling the tier-specific processing for the entity object.

      Returns void

    • Re-fetches the current record from the database using its existing primary key, replacing all in-memory field values with the latest data from the database. This is useful when you know (or suspect) the record has been modified externally (e.g., by a trigger, another user, or a background process) and you want to bring the entity object up to date.

      Returns Promise<boolean>

      true if the record was successfully reloaded, false if the provider returned no data.

      • The entity must have been previously loaded or saved (i.e., it must have a valid PrimaryKey). Calling Refresh() on a new, unsaved entity will throw because the primary key is not yet valid.
      • After a successful refresh, all field dirty flags are reset — the entity will report Dirty === false.
      • This is equivalent to calling InnerLoad(this.PrimaryKey).
      • If you only need to discard unsaved in-memory changes (without a database round-trip), use Revert instead.

      If the entity has no provider set, the primary key is invalid, or the user lacks Read permission.

    • This method can be used to register a callback for events that will be raised by the instance of the BaseEntity object. The callback will be called with a BaseEntityEvent object that contains the type of event and any payload that is associated with the event. Subclasses of the BaseEntity can define their own event types and payloads as needed.

      Parameters

      Returns Subscription

    • Append a result to _resultHistory, trimming the oldest entries when over MAX_RESULT_HISTORY. All Save/Delete code paths route through this — both inside BaseEntity and in callers like databaseProviderBase and entity subclasses that record their own results.

      Parameters

      Returns void

    • If the entity object has a TransactionGroup associated with it, the TransactionGroup will be notified that we are doing some transaction pre-processing so that the TransactionGroup can properly wait for those pre-processing steps to complete before submitting the transaction. This method should generally NOT be called by anyone other than a provider that is handling the tier-specific processing for the entity object.

      Returns void

    • Resets the vector embeddings for this entity to an empty state.

      Returns void

    • This method will revert the internal state of the object back to what it was when it was last saved, or if never saved, from when it was intially loaded from the database. This is useful if you want to offer a user an "undo" type of feature in a UI.

      Returns boolean

    • Refuses a ReplayOnly save by a non-Owner caller.

      WHY THIS OVERRIDE EXISTS. Invariants 1-4 are enforced in Validate(), and Validate() is the one enforcement point BaseEntity.Save() can be told to skip: under EntitySaveOptions.ReplayOnly it force-passes validation WITHOUT calling Validate() at all (baseEntity.ts:3725), and ReplayOnly does NOT suppress the write — the provider only uses it to bypass the AllowUpdateAPI/AllowCreateAPI gates before building and executing the SQL (databaseProviderBase.ts:1436-1443). So a ReplayOnly save skipped all four Save-side invariants while invariant 5 stayed enforced, because Delete() is an override and an override cannot be switched off. This restores the symmetry: now neither half depends on the caller's options.

      NOT CURRENTLY REACHABLE BY AN UNTRUSTED CALLER, and this is deliberately belt-and-braces rather than a live hole. Every wire path that accepts ReplayOnly was enumerated: the GraphQL options___/DeleteOptionsInput input exists only on the DELETE mutation (create and update carry no options input, and ResolverBase.CreateRecord/UpdateRecord call Save() with none); REST's EntityCRUDHandler does accept it, but calls entity.Validate() explicitly before Save(), so the guard still runs there; and graphQLSystemUserClient requires the system API key, i.e. a caller who is already superuser. The point is that the class docstring's "holds on EVERY write path" is a promise a future wire path forwarding save options would otherwise quietly break — a guard whose protection is one option away from off is not the guard this file claims to be.

      WHY REFUSE RATHER THAN RE-RUN THE INVARIANTS. Re-running invariants 1-4 here would duplicate Validate()'s logic in a second place that must then be kept in step with it — the exact duplicated-decision this repo's design rules call out. Refusing outright is smaller and strictly safer: ReplayOnly is a replication/replay facility for trusted sync paths, and a non-Owner has no legitimate reason to replay writes onto the user table. Owners are exempt, so replication and admin paths that run as an Owner are unaffected.

      Parameters

      Returns Promise<boolean>

    • Sets the value of a given field. If the field doesn't exist, nothing happens. The field's type is used to convert the value to the appropriate type.

      For IS-A child entities, parent fields are routed to _parentEntity.Set() (recursive for N-level chains). The value is also mirrored on the child's own virtual EntityField so that code iterating entity.Fields still sees it. The authoritative state for parent fields lives on _parentEntity.

      Parameters

      • FieldName: string
      • Value: any

      Returns void

    • NOTE: Do not call this method directly. Use the From method instead

      Sets any number of values on the entity object from the object passed in. The properties of the object being passed in must either match the field name (in most cases) or the CodeName (which is only different from field name if field name has spaces in it)

      For IS-A child entities, all fields are first set on self (including parent fields as mirrors), then parent fields are extracted and forwarded to _parentEntity.SetMany() for authoritative state, including proper OldValue tracking via the replaceOldValues parameter.

      Parameters

      • object: any
      • OptionalignoreNonExistentFields: boolean

        if set to true, fields that don't exist on the entity object will be ignored, if false, an error will be thrown if a field doesn't exist

      • OptionalreplaceOldValues: boolean

        if set to true, the old values of the fields will be reset to the values provided in the object parameter, if false, they will be left alone

      • OptionalignoreActiveStatusAssertions: boolean

        if set to true, the active status assertions for the fields will be ignored, if false, an error will be thrown if a field is not active. Defaults to false.

      Returns void

    • Marks the next Save() as a restore from a historical RecordChange row.

      The provider will write a new RecordChange entry with Source='Restore', RestoredFromID pointing at sourceChangeId, and RestoreReason set to reason (or NULL). This produces an auditable lineage chain that the timeline UI can render via the RestoredFromID foreign key.

      The context is consumed exactly once per Save() and persists on the entity until either (a) overwritten by a subsequent SetRestoreContext() call or (b) explicitly cleared via ClearRestoreContext(). It is NOT auto-cleared inside Save() because TransactionGroup execution is deferred — see the comment on _restoreContext for details.

      Parameters

      • sourceChangeId: string

        The ID of the historical RecordChange row whose state is being restored. Required; throws if empty.

      • Optionalreason: string

        Optional user-entered explanation captured at restore time. Persisted to RecordChange.RestoreReason for audit purposes.

      Returns void

      record.SetRestoreContext(versionId, 'Reverting incorrect Q2 entries');
      const ok = await record.Save();
      record.ClearRestoreContext();
    • Specifies if the current object supports the

      Returns boolean

      EmbedTextLocal method or not - useful to know before calling it for conditional code that has fallbacks as needed. BaseEntity does not implement this method but server-side sub-classes often do, but it is not mandatory for any sub-class.

    • Strongly-typed wrapper for the GetAll method

      Type Parameters

      • K extends AnyZodObject

      Parameters

      • Optionalschema: K

        the zod schema to validate the data against

      Returns TypeOf<K>

    • Asynchronous validation method that can be overridden by subclasses to add custom async validation logic. This method is automatically called by Save() AFTER the synchronous Validate() passes.

      IMPORTANT:

      1. This should NEVER be called INSTEAD of the synchronous Validate() method
      2. This is meant to be overridden by subclasses that need to perform async validations
      3. The base implementation just returns success - no actual validation is performed

      Subclasses should override this to add complex validations that require database queries or other async operations that cannot be performed in the synchronous Validate() method.

      Returns Promise<ValidationResult>

      Promise A promise that resolves to the validation result

    • Resolves the leaf (most-derived) entity type for a given parent entity record. Walks down the IS-A child hierarchy to find which child type a record belongs to. Returns the child entity name, or the parent's own name if no children exist. Useful for polymorphic operations where you have a parent record and need to know its actual leaf type.

      Parameters

      • entityName: string

        The parent entity name

      • primaryKey: CompositeKey

        The primary key to look up

      • OptionalcontextUser: UserInfo

        Optional context user for server-side operations

      • Optionalprovider: IMetadataProvider

      Returns Promise<{ IsLeaf: boolean; LeafEntityName: string }>

      The leaf entity name and whether it was resolved to a child type