CodeScanningAnalyses
Lists code scanning analyses for the repository.
View-Specific Information
Select
The connector uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:
- Id supports the '=' comparison operator.
- Ref supports the '=' comparison operator.
- SarifId supports the '=' comparison operator.
- ToolName supports the '=' comparison operator.
- ToolGuid supports the '=' comparison operator.
- PullRequestNumber supports the '=' comparison operator.
For example, the following queries are processed server-side:
SELECT * FROM [CodeScanningAnalyses]
SELECT * FROM [CodeScanningAnalyses] WHERE [Id] = 123
SELECT * FROM [CodeScanningAnalyses] WHERE [Ref] = 'Val1'
SELECT * FROM [CodeScanningAnalyses] WHERE [SarifId] = 'Val1'
SELECT * FROM [CodeScanningAnalyses] WHERE [ToolName] = 'Val1'
SELECT * FROM [CodeScanningAnalyses] WHERE [ToolGuid] = 'Val1'
SELECT * FROM [CodeScanningAnalyses] WHERE [PullRequestNumber] = 123
The connector processes other filters client-side within the connector.
The connector uses the GitHub API to process ORDER BY clause conditions that are built with the following column: CreatedAt
SELECT * FROM [CodeScanningAnalyses] ORDER BY [CreatedAt]
The connector processes ordering by other columns client-side within the connector.
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | Int | Unique identifier for this analysis. | ||
| Ref | String | The Git reference (e.g., refs/heads/main, refs/pull/123/merge). | ||
| CommitSha | String | The SHA of the commit to which the analysis relates. | ||
| AnalysisKey | String | Identifies the configuration under which the analysis was executed (e.g., workflow filename and job name). | ||
| Environment | String | Identifies the variable values associated with the environment. | ||
| Category | String | Identifies the configuration under which the analysis was executed (e.g., language or code section). | ||
| Error | String | Error message if the analysis failed. | ||
| Warning | String | Warning generated when processing the analysis. | ||
| Url | String | The REST API URL of the analysis resource. | ||
| SarifId | String | An identifier for the SARIF upload. | ||
| ResultsCount | Int | The total number of results in the analysis. | ||
| RulesCount | Int | The total number of rules used in the analysis. | ||
| ToolName | String | The name of the tool used to generate the code scanning analysis. | ||
| ToolGuid | String | The GUID of the tool used to generate the code scanning analysis. | ||
| ToolVersion | String | The version of the tool used to generate the code scanning analysis. | ||
| CreatedAt | Datetime | The time that the analysis was created. | ||
| Deletable | Bool | Whether this analysis can be deleted. | ||
| PullRequestNumber | Int | The number of the pull request for the results you want to list. |