TestSessions
Retrieves a list of test sessions.
Table Specific Information
Select
The 本製品 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 本製品.
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. |