Error List

• Display the errors, warnings, and messages produced while you write code.

• Find syntax errors noted by Instant Code Analysis.

• Find syntax errors and errors detected when applying static code analysis rules.

• Double-click any error message entry to open the file where the problem occurs, and move to the error location.

• Click the analysis rule code link to open the SQL Enlight help for the specific rule.

• Filter which entries are displayed, and which columns of information appear for each entry.

• Search for specific terms and scope the search to just the current document or all open documents.

To display the Error List, use the Error List main menu item under the SQL Enlight menu, or use the CTRL + SHIFT + Y + R keyboard shortcut.

Choose the Errors, Warnings, and Messages tabs to see different levels of information.

To sort the list, click any column header. To change the order in which columns are displayed, drag any column header to the left or right.

There are two types of filters in two dropdown boxes, one on the right side of the toolbar and one to the left of the toolbar. The dropdown list on the left side of the toolbar specifies the set of code files to use (Open Documents, Current Document).

You can restrict the scope of the search to analyze and act on groups of errors. For example, you might want to focus on the errors in the current document. The scoping options include:

• Open Documents: Show errors, warnings, and messages for the open documents.

• Current Document: Show errors, warnings, and messages for the currently selected document in the Editor.

• Current Database: Show errors, warnings, and messages for the database of the current connection.

If a filter is currently applied to the search result, the Errors, Warnings, and Messages buttons then display the number of filtered items being shown along with the total number of items; for example, the buttons show x of y Errors. If no filter is applied, the title bar says only “Error List”.

The list on the right side of the toolbar specifies whether to show errors from the build (errors resulting from a build operation) or from IntelliSense (errors detected before running a build), or from both.

Use the Search text box on the right side of the Error List toolbar to find specific errors in the error list.
You can search in the error list, and search results are always sorted based on the column that has sort priority instead of on the query or the filter applied.
If you choose the Esc key while the focus is in the Error List, you can clear the search term and filtered search results. You can also click the X on the right side of the text box to clear it.

• You can copy the error list and save it to a file. Select the errors you want to copy and right-click the selection, then on the context menu select Copy. You can then paste the errors into a file. If you paste the errors into an Excel spreadsheet, the fields appear as different columns.

• Use the Export to CSV file/Export to XML file toolbar buttons or context menu items

The context menu contains the following list of commands:

• Export to CSV file – Export the selected error list items to a comma separated file, which can be opened in Excel.

• Export to XML file – Export the selected error list items to an XML file.

• Copy – The command copies the selected list entries as tab separated values.

• Remove Results -> Remove Rule – remove all appearances of the rule of the currently selected entry

• Remove Results -> Remove Selected– remove all selected entries

• Remove Results -> Remove Source – remove all entries that have the same source as the one of the currently selected entry

• Remove Results -> Deactivate Rule – remove all appearances of the rule of the currently selected entry and deactivates the rule in the current analysis template

• Clear All – Clear all list entries.

• Properties – Show details pane.

• Index – Error List entry index.

• Analysis Rule Type – Displays icons specific to the type of the analysis rule – Context or Batch.

• Severity – Displays icons for the different types of Error List entry (Error, Message, Warning, Warning (active), Warning (inactive).

• Code – Displays the error code.

• Description – Displays the text description of the entry.

• Source – Displays the source file name or database object name for the entry.

• Line – Displays the line where the problem occurs.

• Line – Displays the line where the problem occurs.

• Column – Displays the column where the problem occurs.

In the SQL Enlight error list,

The issues that have a fix, appear in the SQL Enlight error list with a Fix icon in the second list column. The Fix can be applied using the Fix command in the list’s context menu.

When a database is analyzed and database issues are reported, the script that fixes all selected database issues is created in a new SQL document.