DashboardExtensionSettings.EnableCustomSql Property

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

Namespace: DevExpress.DashboardWeb.Mvc

Assembly: DevExpress.Dashboard.v20.2.Web.Mvc5.dll

Declaration

public bool EnableCustomSql { get; set; }

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 the database level.

See Custom SQL Queries for more information.

See Also