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.