TestSessions

Retrieves a list of test sessions.

Table Specific Information

Select

The driver 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 driver.

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.
LastUpdatedByImageUrl	String	False		The Image URL of the user who last updated this session.
LastUpdatedByUniqueName	String	False		The unique name 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.
OwnerImageUrl	String	False		The Image URL of the owner of the testowner of the test session.
OwnerUniqueName	String	False		The unique name of the owner of the test session.
OwnerUrl	String	False		The URL of the owner of the test session.
ProjectId	String	True	Projects.Id	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. The allowed values are 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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


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.