SSIS Components for Azure DevOps

Build 24.0.9063

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9063