How to get Test Plan Test Executions from Xray with API?

Amin Mohammadi

I’m trying to retrieve the statuses of test executions using the Jira API, but I’m having trouble. Here’s the process we follow:

1. Run a JQL query to get the parent issues:

(issue in testPlanTestExecutions(TEST-1308798) or issue in testPlanTestExecutions(TEST-1259334)) and (createdDate <= "2024/05/30" and createdDate >= "2024/05/01" )

2. Open one of the parent issues to view the executions.

I’ve attempted to do this, but I can’t seem to get the statuses as shown in the image.

API: /rest/api/latest/search

Request body:

 

{

    "jql": "(issue in testPlanTestExecutions(TEST-1308798) or issue in testPlanTestExecutions(TEST-1259334)) and (createdDate <= \"2024/05/30\" and createdDate >= \"2024/05/01\"  )",

    "fields": [

        "key",

        "customfield_27209",

        "customfield_27214"

    ],

    "maxResults": 10

}

 

I want to fetch the statuses as a list, rather than one by one. Is this possible?

Manuel_u1i996

 

Hi @Amin Mohammadi

you need to get the testRuns object, and the status within it.

Something like this, adapting it to your use case:

 

 query

 {

 getTestExecutions(jql: "key=CALC-3352", limit: 1) {

 results{

 issueId

 jira(fields: ["key"])

 testRuns(limit: 100){

 results{

id

 status{

 name

 description

 }

 comment

 testType{

 name

 kind

 }

 evidence{

 filename

 downloadLink

 }

 defects

 executedById

 startedOn

 finishedOn

 assigneeId

 unstructured

 customFields {

id

 name

 values

 }

 test {

 issueId

 jira(fields: ["key"])

 projectId

 }

 }

 }

 }

 }

 }