The Validate button has been added to the Add Database View and Edit Database View windows, which allows you to validate and see the results of the SQL code.
If the validation is successful, the grid below the button and the Time taken (secs) field are populated.
If the SQL syntax is invalid, an error message is displayed.
You cannot save the database view if the syntax is invalid.
Refer to Add or edit custom views from the module for further information.