get latest execution results

Rishi.Randhir June 7, 2018

hi,  

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:

https://confluence.xpand-addons.com/display/XRAY/How+to+implement+QA+in+your+projects#HowtoimplementQAinyourprojects-Mainlywithmanualtesting

https://confluence.xpand-addons.com/display/XRAY/Tips+for+planning+tests#Tipsforplanningtests-Planning,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-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
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
TAGS
AUG Leaders

Atlassian Community Events