Defines data access rules that filter records based on user context, implementing fine-grained security at the row level.

Hierarchy (view full)

Constructors

Properties

Description: string = null

Description of the row level security filter

FilterText: string = null

SQL WHERE clause template that filters records based on user context variables

ID: string = null

Unique identifier for the row level security filter

Name: string = null

Name of the row level security filter

__mj_CreatedAt: Date = null

Timestamp when the filter was created

__mj_UpdatedAt: Date = null

Timestamp when the filter was last updated

Methods

  • Replaces user-specific tokens in the filter text with actual user values. Tokens are in the format {{UserFieldName}} where FieldName is any property of the UserInfo object.

    Parameters

    • user: UserInfo

      The user whose properties will be substituted into the filter text

    Returns string

    The filter text with all user tokens replaced with actual values

  • Copies initialization data from a plain object to the class instance. Only copies properties that already exist on the class to prevent creating new fields. Special handling for DefaultValue fields to extract actual values from SQL Server syntax.

    Parameters

    • initData: any

      The initialization data object

    Returns void