SSIS Components for Azure DevOps

Build 24.0.9063

TestRuns

Retrieves a list of test runs.

Table Specific Information

Select

The 本製品 uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

The rest of the filter is executed client-side in the 本製品.

  • ProjectId supports the '=' operator.
  • IsAutomated supports the '=' operator.
  • OwnerId supports the '=' operator.
  • PlanId supports the '=' operator.
  • RunId supports the '=' operator.
  • BuildUri supports the '=' operator.
  • IncludeRunDetails supports the '=' operator.
  • TmiRunId supports the '=' operator.
For example:
	SELECT * FROM TestRuns WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4'	
	SELECT * FROM TestRuns WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND Id = 6	
	SELECT * FROM TestRuns WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND IncludeRunDetails = true

Insert

The following is an example of inserting into an Earnings table:

INSERT INTO TestRuns (ProjectId, Name) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'Shubham')

Update

The following is an example of updating a TestRuns table:

UPDATE TestRuns SET Name = 'cdata2' WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '1'

Columns

Name Type ReadOnly References Description
Id [KEY] Integer True

Id of the Test Run.

BuildId String False

Builds.Id

Id of the build associated with this test run.

BuildName String False

Name of the build associated with this test run.

BuildUrl String False

Url of the build associated with this test run.

Comment String False

Comments entered by those analyzing the run.

CompletedDate Datetime False

Completed date time of the run.

Controller String False

Test Run Controller.

CreatedDate Datetime True

Test Run CreatedDate.

DropLocation String False

Drop Location for the test run.

DueDate Datetime False

Due date and time for test run.

ErrorMessage String False

Error message associated with the run.

IncompleteTests Integer True

Number of Incomplete Tests.

IsAutomated Boolean False

True if test run is automated, false otherwise.

Iteration String False

The iteration to which the run belongs.

LastUpdatedByDisplayName String True

The non-unique display name of the user who last updated this test run.

LastUpdatedById String True

The Id of the user who last updated this test run.

LastUpdatedByUrl String True

The Url of the user who last updated this test run.

LastUpdatedDate Datetime True

Last updated date and time.

Name String False

Name of the Test run.

NotApplicableTests Integer True

Number of Not Applicable Tests.

OwnerDisplayName String False

The non-unique display name of the owner.

OwnerId String False

The Id of the owner.

OwnerUrl String False

The URL of the owner.

PassedTests Integer True

Number of passed tests in the run.

Phase String True

Phase/State for the test run

PlanId String False

TestPlans.Id

Id of the test plan associated with this test run.

PlanName String False

Name of the test plan.

PlanUrl String False

URL of the test plan.

PostProcessState String True

Post Process State.

ProjectId String True

Id of the Project associated with this test run.

ProjectName String True

Name of the Project.

ProjectUrl String True

URL of the Project.

ReleaseId String True

Releases.Id

Id of the Release.

ReleaseEnvironmentUri String True

Release Environment URI for test run.

ReleaseUri String False

Release Uri for test run.

Revision Integer True

Test run Revision.

StartedDate Datetime False

Start date time of the run.

State String False

The state of the run.

SubState String True

Test run Substate.

Tags String False

Tags attached with this test run.

TestEnvironmentId String False

Id of the Test Environment associated with this test run.

TestEnvironmentName String True

Name of the Test Environment associated with this test run.

TestMessageLogId Integer True

Test Message Log Id.

TestSettingsId String False

Id of the Test Settings.

TestSettingsName String False

Name of the Test Settings.

TestSettingsUrl String False

Url of the Test Settings.

TotalTests Integer True

Total tests in the run.

UnanalyzedTests Integer True

Number of failed tests in the run.

Url String True

Url of the test run.

WebAccessUrl String True

Web Access Url for test run.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。

Name Type Description
BuildUri String

URI of the build that the runs used.

IncludeRunDetails Boolean

If true, include all the properties of the runs.

TmiRunId String

Tmi Run Id.

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