Skip to main content

QuerySafetySettings

  • Namespace: PPDS.Auth.Profiles
  • Assembly: PPDS.Auth
  • Kind: Class

Summary​

Per-environment query safety settings. Stored in environment config JSON. All settings have sensible defaults — null means "use default".

Members​

Properties​

BypassCustomPlugins​

BypassPluginMode BypassCustomPlugins { get; set; }

Bypass custom plugin execution. Default: None.

BypassPowerAutomateFlows​

bool BypassPowerAutomateFlows { get; set; }

Suppress Power Automate flow triggers on DML. Default: false.

CrossEnvironmentDmlPolicy​

CrossEnvironmentDmlPolicy CrossEnvironmentDmlPolicy { get; set; }

Cross-environment DML policy. Default: ReadOnly.

DateTimeMode​

DateTimeMode DateTimeMode { get; set; }

DateTime display mode. Default: UTC.

DmlBatchSize​

Nullable<int> DmlBatchSize { get; set; }

Records per DML batch (1-1000). Default: 100.

MaxPageRetrievals​

Nullable<int> MaxPageRetrievals { get; set; }

Maximum FetchXML pages fetched (0 = unlimited). Default: 200.

MaxParallelism​

Nullable<int> MaxParallelism { get; set; }

Worker threads for DML (0 = auto). Default: 0.

MaxResultRows​

Nullable<int> MaxResultRows { get; set; }

Maximum rows returned (0 = unlimited). Default: 0.

PreventDeleteWithoutWhere​

bool PreventDeleteWithoutWhere { get; set; }

Block DELETE without WHERE clause. Default: true.

PreventUpdateWithoutWhere​

bool PreventUpdateWithoutWhere { get; set; }

Block UPDATE without WHERE clause. Default: true.

QueryTimeoutSeconds​

Nullable<int> QueryTimeoutSeconds { get; set; }

Cancel query after N seconds (0 = no timeout). Default: 300.

ShowFetchXmlInExplain​

bool ShowFetchXmlInExplain { get; set; }

Include FetchXML in EXPLAIN output. Default: true.

UseBulkDelete​

bool UseBulkDelete { get; set; }

Route full-table DELETE to async BulkDeleteRequest. Default: false.

UseTdsEndpoint​

bool UseTdsEndpoint { get; set; }

Route SELECT queries to TDS read replica. Default: false.

WarnDeleteThreshold​

Nullable<int> WarnDeleteThreshold { get; set; }

Prompt when deleting more than N records (0 = always prompt). Default: 0.

WarnInsertThreshold​

Nullable<int> WarnInsertThreshold { get; set; }

Prompt when inserting more than N records (0 = always prompt). Default: 1.

WarnUpdateThreshold​

Nullable<int> WarnUpdateThreshold { get; set; }

Prompt when updating more than N records (0 = always prompt). Default: 0.