ValidateDashboardCustomSqlQueryEventArgs.Valid Property

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

Namespace: DevExpress.DashboardCommon

Assembly: DevExpress.Dashboard.v18.1.Core.dll

Syntax

public bool Valid { get; set; }

Returns

Type Description
Boolean

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

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 ValidateDashboardCustomSqlQueryEventArgs.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 ValidateDashboardCustomSqlQueryEventArgs.ExceptionMessage message.