FireDAC Components for Azure DevOps

Build 21.0.7930

TestSessions

Retrieves a list of test sessions.

Table Specific Information

Select

The component will use the Azure DevOps API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.

  • 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.
For example:
	SELECT * FROM TestSessions WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4'

Columns

Name Type References Description
Id [KEY] Integer Id of the Test Session.
TeamId String

Teams.Id

Id of the Team.
AreaId String Id of the Area Path of the test session.
AreaName String Name of the Area path of the test session.
AreaUrl String Url of the Area path of the test session.
Comment String Comments in the test session.
EndDate Datetime Duration of the session.
LastUpdatedByDisplayName String The non-unique display name of the user who last updated this session.
LastUpdatedById String The Id of the user who last updated this session.
LastUpdatedByImageUrl String The Image URL of the user who last updated this session.
LastUpdatedByUniqueName String The unique name of the user who last updated this session.
LastUpdatedByUrl String The URL of the user who last updated this session.
LastUpdatedDate Datetime Last updated date.
OwnerDisplayName String The non unique display name of the owner of the test session.
OwnerId String The Id of the owner of the test session.
OwnerImageUrl String The Image URL of the owner of the testowner of the test session.
OwnerUniqueName String The unique name of the owner of the test session.
OwnerUrl String The URL of the owner of the test session.
ProjectId String

Projects.Id

Id of the Project.
ProjectName String Name of the Project.
ProjectUrl String Url of the Project.
PropertyBag String Generic store for test session data.
Revision Integer Revision of the test session.
Source String Source of the test session.

The allowed values are feedbackDesktop, feedbackWeb, sessionInsightsForAll, unknown, xtDesktop, xtDesktop2, xtWeb.

StartDate Datetime Start date of the test session.
State String State of the test session.
Title String Title of the test session.
Url String 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.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930