Excel Add-In for Azure DevOps

Build 24.0.9062

TestResults

Retrieves test results for a test run.

Table Specific Information

Select

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

  • Id supports the '=' operator.
  • TestRunId supports the '=' operator.
  • Outcome supports the '=' operator.

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

NOTE: TestRunId is required in order to query TestResults.

For example: 

	SELECT * FROM TestResults WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND TestRunId = 6

Insert

The following are examples of inserting into a TestResults table: 

INSERT INTO TestResults#TEMP (ProjectId, TestRunId, Comment, OwnerName) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 1, 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'abcd')
INSERT INTO TestResults#TEMP (ProjectId, TestRunId, Comment, OwnerName) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 2, 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'xyz')
INSERT INTO TestResults (ProjectId, TestRunId, Comment, OwnerName) SELECT ProjectId, TestRunId, Comment, OwnerName FROM TestResults#TEMP
INSERT INTO TestResults (ProjectId, TestRunId, TestCaseTitle, AutomatedTestName, Priority, Outcome) VALUES ('c831d3b4-a289-462f', 1, 'NewTestCase', 'TestProject.TestElement.TestClass.NewTestCase', 1, 'Passed')

Update

The following are examples of updating a TestResults table: 

INSERT INTO TestResults#TEMP (ProjectId, TestRunId, Id, Comment, OwnerName) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 1, '1', 'hello@1234', 'abcd')
INSERT INTO TestResults#TEMP (ProjectId, TestRunId, Id, Comment, OwnerName) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 1, '2', 'hello@123t', 'xyz')
UPDATE TestResults (ProjectId, TestRunId, Id, Comment, OwnerName) SELECT ProjectId, TestRunId, Id, Comment, OwnerName FROM TestResults#TEMP

Columns

Name Type ReadOnly References Description
Id [KEY] Integer False

Id of the Test Result.

AfnStripId Integer False

Test Attachment Id of action recording.

AreaId String False

Id of the Area Path Of Test.

AreaName String False

Name of the Area Path of Test.

AreaUrl String False

URL of the Area Path of Test.

AssociatedBugs String False

Reference to bugs linked to test result.

AutomatedTestId String False

ID representing test method in a dll.

AutomatedTestName String False

Fully qualified name of test executed.

AutomatedTestStorage String False

Container to which test belongs.

AutomatedTestType String False

Type of automated test.

AutomatedTestTypeId String False

TypeId of automated test.

BuildId String False

Builds.Id

Id of the Build associated with this test result.

BuildName String False

Name of the Build.

BuildUrl String False

URL of the Build.

Comment String False

Comment in a test result with maxSize= 1000 chars.

CompletedDate Datetime False

Time when test execution completed.

ComputerName String False

Machine name where test executed.

ConfigurationId String False

Id of the Test Configuration.

ConfigurationName String False

Name of the Test Configuration.

ConfigurationUrl String False

Url of the Test Configuration.

CreatedDate Datetime False

Timestamp when test result created.

DurationInMs Integer False

Duration of test execution in milliseconds.

ErrorMessage String False

Error message in test execution.

FailingSinceBuildSystem String False

Build System.

FailingSinceBuildDefinitionId Integer False

Build Definition Id since tests are failing.

FailingSinceBuildId Integer False

Build Id since tests are failing.

FailingSinceBuildNumber String False

Build Number.

FailingSinceDate Datetime False

Time since failing.

FailingSinceReleaseId Integer False

Release reference since failing.

FailureType String False

Failure type of test result.

LastUpdatedByDisplayName String False

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

LastUpdatedById String False

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

LastUpdatedByUrl String False

The URL of the user.

LastUpdatedDate Datetime False

Last updated datetime of test result.

Outcome String False

Test outcome of test result.

OwnerId String False

The Id of the owner of the test.

OwnerName String False

The name of the owner.

OwnerUrl String False

The URL of the Owner.

Priority Integer False

Priority of test executed.

ProjectId String True

Id of the Project.

ProjectName String False

Name of the Project.

ProjectUrl String False

URL of the Project.

ReleaseId Integer False

Id of the release associated with this result.

ReleaseName String False

Name of the release associated with this result.

ReleaseUrl String False

Url of the release associated with this result.

ResetCount Integer False

ResetCount.

ResolutionState String False

Resolution state of test result.

ResolutionStateId Integer False

ID of resolution state.

ResultGroupType String False

Hierarchy type of the result, default value of None means its leaf node.

Revision Integer False

Revision number of test resul.

RunByDisplayName String False

The non-unique display name of the user who executed the test.

RunById String False

The Id of the user who executed the test.

RunByUrl String False

The URL of the user who executed the test.

StackTrace String False

Stacktrace with maxSize= 1000 chars.

StartedDate Datetime False

Time when test execution started.

State String False

State of test result.

TestCaseId String False

TestCases.Id

Id of the Test case executed.

TestCaseName String False

Name of the Test case executed.

TestCaseUrl String False

Url of the Test case executed.

TestCaseReferenceId Integer False

Reference ID of test used by test result.

TestCaseRevision Integer False

TestCaseRevision Number.

TestCaseTitle String False

Name of test.

TestPlanId String False

TestPlans.Id

Id of The Test Plan test case work item is part of.

TestPlanName String False

Name of the Test Plan.

TestPlanUrl String False

Url of the Test Plan.

TestPointId String False

TestPoints.Id

Id of the Test Point Executed.

TestPointName String False

Name of the Test Point Executed.

TestPointUrl String False

Url of the Test Point Executed.

TestRunId String True

TestRuns.Id

Id of the Test Run.

TestRunName String False

Name of the Test Run.

TestRunUrl String False

Url of the Test Run.

TestSuiteId String False

TestSuites.Id

Id of the Test Suite test case workitem is part of.

TestSuiteName String False

Name of the Test Suite.

TestSuiteUrl String False

Url of the Test Suite.

Url String False

Url of the Test Result.

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