ValidateDashboardCustomSqlQueryEventArgs.Valid Property
Gets or sets whether the current custom SQL query is valid.
Namespace: DevExpress.DashboardCommon
Assembly: DevExpress.Dashboard.v24.2.Core.dll
NuGet Package: DevExpress.Dashboard.Core
#Declaration
#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 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.