get latest execution results

Rishi.Randhir June 7, 2018


I am new to JIRA and have created a test structure in which , i create a single test plan and multiple executions for every release , which helps to lower the number of plans created in every release and tracking executions is easy for results.

My question is : is there a JQL query that would help me get the latest results , ie. in planA if there are execution1,2 and 3, 

I want a query that will give me the tests executed planA but from the latest execution i.e from Execution3.

I want this as a JQL since will be easier for reports. (this query should work at test level)

Thanks for your answers


2 answers

1 vote
José Domingues [Xray]
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
June 28, 2018

Hi Rishi,

we advise you to create different Test Plans in order to track results for different contexts (e.g. versions, sprints) and aggregate the results of those contexts. Otherwise, Test Plans will be useless (you're not forced to use them).

You can see here some of our recommendations:,froma%22methodology%22perspective

Going back to your initial question, JQL functions always return issues (e.g. Tests, Test Executions, etc); they never return other kind of entities, such as Test Runs.

If you wish to obtain the "latest" Test Execution, then you may simply search based on the created date:

project = CALC and issuetype = 'Test Execution' and "Test Plan" = "CALC-1200" order by created desc


Best regards,

Xray Team

Rishi.Randhir July 5, 2018

thanks for the response. I will check and get back whenever possible.

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 10, 2018

How are you doing "Test structure" and storing test plans and executions in Jira?

Rishi.Randhir June 12, 2018

We are using Xray for this purpose

Rishi.Randhir June 21, 2018

any update on this ?

i am still looking to solve this

Vahini Jyoti Kapaka [X]
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 18, 2023

did you find any solution to get the latest test run?

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events