The following table lists the views which are available for reporting purposes. Your system administrator can help you to connect your reporting solution to those views. You can either use native SQL connections or, if your reporting tools do not support this, you can use an ODBC connection. For more information, see ODBC Data Source Administrator Help - Windows Data Access Components.
以下の読み取り専用のビューは、ODBC を使用する、特別なユーザー ロールによってアクセスできます。
| Column Name | Data Type | Description |
|---|
| ID | GUID | Automatically generated ID for the project. |
| Prefix | string | The prefix of the project, as added when it was first created. |
| Project Name | string | The name of the project, as added when it was first created. |
| Column Name | Data Type | Description |
|---|
| Name | string | The name of the test execution. |
| Project ID | GUID | The ID of the project this Test Execution was assigned to. |
| Execution Start | date/time | The start of the execution. Please note that pending Test Executions have a NULL value. |
| Execution Finished | date/time | The time when the execution finished. Please note that pending Test Executions have a NULL value. |
| Column Name | Data Type | Description |
|---|
| ID | GUID | Automatically generated ID for the test case. |
| Name | string | The name of the test case as added when it was created. |
| Type | set | Can have one of the following values:
automated - indicates an automated test case.
manual - indicates a manual test case. |
| Column Name | Data Type | Description |
|---|
| Test Case ID | GUID | Automatically generated ID. |
| Test Execution ID | GUID | Automatically generated ID for the test execution. |
| Test Case Version | string | The version added when a test case is created, if added. |
| Result | ENUM | Can have one of the following values:
passed
failed
noresult |
| Execution Start | date/time | The start time of the test case execution. |
| Execution End | date/time | The end time of the test case execution. |
| Executed By | string | There are two possible values:
user - tests that were manually executed.
robot - tests that were automatically executed. |
| Column Name | Data Type | Description |
|---|
| ID | GUID | Automatically generated identifier. |
| Object Key | string | Automatically generated identifier which contains the project key and an automatically incremented number. |
| Name | string | The name of the requirement as added when it was created. |
| Description | string | The description of the requirement as added when it was created. Accepts markdown. |
| Project ID | GUID | Automatically generated ID for the project. |
約 1 か月前に更新