ValidateDashboardCustomSqlQueryWebEventArgs.Valid Property

Gets or sets whether the current custom SQL query is valid.

Namespace: DevExpress.DashboardWeb

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

NuGet Package: DevExpress.Web.Dashboard.Common

Declaration

C#

public bool Valid { get; set; }

VB.NET

Public Property Valid As Boolean

Property Value

Type	Description
Boolean	true, if the current custom SQL query is valid; otherwise, false.

Remarks

By default, a custom query used to obtain data from the SQL database should contain only SELECT statements. If the custom query contains not only SELECT statements, or the query is specified incorrectly, the Valid property is set to false. The ValidateDashboardCustomSqlQueryWebEventArgs.ExceptionMessage property returns corresponding exception message.

If necessary, you can check the validity of the custom SQL query manually and override the value of the Valid flag and corresponding ValidateDashboardCustomSqlQueryWebEventArgs.ExceptionMessage message.