ASPxDashboard.EnableCustomSql Property

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

Namespace: DevExpress.DashboardWeb

Assembly: DevExpress.Dashboard.v18.2.Web.WebForms.dll

Declaration

public bool EnableCustomSql { get; set; }
Public Property EnableCustomSql As Boolean

Property Value

Type Default Description
Boolean

false

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

Remarks

Note that the ASPxDashboard.ValidateDashboardCustomSqlQuery 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.

Executing 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 may lead to inadvertent or unauthorized modifications to your data/database structure. Therefore, make sure that you follow best practices and implement the appropriate end-user read/write privileges at the database level.

See Custom SQL Queries for more information.

See Also