DashboardExtensionSettings.EnableCustomSql Property

Enables a user to specify a custom SQL string in the Data Source wizard.

Namespace: DevExpress.DashboardWeb.Mvc

Assembly: DevExpress.Dashboard.v24.1.Web.Mvc5.dll

NuGet Package: DevExpress.Web.Mvc5.Dashboard

Declaration

C#

public bool EnableCustomSql { get; set; }

VB.NET

Public Property EnableCustomSql As Boolean

Property Value

Type	Description
Boolean	true, to allow a user to specify a custom SQL string in the Data Source wizard; otherwise, false.

Remarks

Note that the DashboardConfigurator.ValidateCustomSqlQuery event is raised each time an end-user creates a new SQL data source/custom SQL query in the Data Source wizard or edits the existing data source/SQL Query.

Execution of custom SQL queries is forbidden by default. Use the AllowExecutingCustomSql property to allow the Web Dashboard to execute SQL queries on the server side.

Warning

The use of custom SQL queries can lead to inadvertent or unauthorized modifications to your data/database structure. Ensure that you follow best practices and implement the appropriate user read/write privileges at database level.

See Custom SQL Queries for more information.