TestSessions
Retrieves a list of test sessions.
Table Specific Information
Select
The connector uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- ProjectId supports the '=' operator.
- TeamId supports the '=' operator.
- Source supports the '=' operator.
- AllSessions supports the '=' operator.
- IncludeAllProperties supports the '=' operator.
- IncludeOnlyCompletedSessions supports the '=' operator.
- Period supports the '=' operator.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM TestSessions WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4'
Insert
The following are examples of inserting into a TestSessions table:
INSERT INTO TestSessions (ProjectId, TeamId, Title) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', '619e870e-5242-4218-bedd-c52d8c003591', 'Cdata')
INSERT INTO TestSessions (ProjectId, TeamId, Title, AreaName) VALUES ('c831d3b4-a289-462f', '7f1d8582-a070-4d2b', 'Sample TestSession', 'Sample-Test-TFVC')
Update
The following is an example of updating a TestSessions table:
UPDATE TestSessions SET Comment = 'cdata2' WHERE Id = '1' AND ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND TeamId = '619e870e-5242-4218-bedd-c52d8c003591'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
Id of the Test Session. | |
| TeamId | String | True |
Teams.Id |
Id of the Team. |
| AreaId | String | False |
Id of the Area Path of the test session. | |
| AreaName | String | False |
Name of the Area path of the test session. | |
| AreaUrl | String | False |
Url of the Area path of the test session. | |
| Comment | String | False |
Comments in the test session. | |
| EndDate | Datetime | False |
Duration of the session. | |
| LastUpdatedByDisplayName | String | False |
The non-unique display name of the user who last updated this session. | |
| LastUpdatedById | String | False |
The Id of the user who last updated this session. | |
| LastUpdatedByUrl | String | False |
The URL of the user who last updated this session. | |
| LastUpdatedDate | Datetime | False |
Last updated date. | |
| OwnerDisplayName | String | False |
The non unique display name of the owner of the test session. | |
| OwnerId | String | False |
The Id of the owner of the test session. | |
| OwnerUrl | String | False |
The URL of the owner of the test session. | |
| ProjectId | String | True |
Id of the Project. | |
| ProjectName | String | False |
Name of the Project. | |
| ProjectUrl | String | False |
Url of the Project. | |
| PropertyBag | String | False |
Generic store for test session data. | |
| Revision | Integer | False |
Revision of the test session. | |
| Source | String | False |
Source of the test session. 使用できる値は次のとおりです。feedbackDesktop, feedbackWeb, sessionInsightsForAll, unknown, xtDesktop, xtDesktop2, xtWeb | |
| StartDate | Datetime | False |
Start date of the test session. | |
| State | String | False |
State of the test session. | |
| Title | String | False |
Title of the test session. | |
| Url | String | False |
Url of Test Session Resource. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。
| Name | Type | Description |
| AllSessions | Boolean |
If false, returns test sessions for current user. Otherwise, it returns test sessions for all users. |
| IncludeAllProperties | Boolean |
If true, it returns all properties of the test sessions. |
| IncludeOnlyCompletedSessions | Boolean |
If true, it returns test sessions in completed state. |
| Period | Integer |
Period in days from now, for which test sessions are fetched. |