Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,865
Community Members
 
Community Events
165
Community Groups

How to create a JQL returning the XRay tests which have been executed by a specific account?

We use XRay as our Test management plugin and it's integrated with our automation framework, which automatically updates all test results from the framework into a new XRay Test execution or an existing test case execution.

For this purpose we use a generic Jira account, which doesn't expire and has a set of very specific entitlements. 

For reporting reasons and to get a better understanding of the adoption of the framework I would like to start reporting on the amount of tests executed by this generic user account - which should give us quite a good understanding whether test cases are actually adopted or still ran manually despite these being automated already.

Is there a possibility to search for Test cases, through JQL, with a parameter "Executed by". I assume this is linked to the TestRunStatus and as such I'm OK with multiple solutions as they give me some insights already.

- Amount of Test runs, linked to this generic test account
- #tests with latest test run executed by this account 

Or any proposal how to measure this would be appreciated a lot.

1 answer

Hi @sgoffin 

We would like to share with you our document: https://docs.getxray.app/display/XRAY/Enhanced+querying+with+JQL
In this document, you'll found below topics:

testExecutionTests - Returns a List of Test issues associated with the input Test Execution issues from P1 optionally filtered by the current test run status for each Test issue.

testExecWithTestRunsAssignedToUser - Returns a list of test executions where a user has at least one test run assigned to him. You can optionally specify a user with P1, or if the user is omitted the current user will be used. Note that if you are not logged in to JIRA, a user must be specified.

Hope this helps! 

Best Regards,

Sérgio

________

Solution Architect and Testing Advocate @Xray

Personal blog on testing, Agile, and software development: https://sergiofreire.com

Follow me on Twitter: https://twitter.com/darktelecom

Hi Sergio,

I need a help on gadgets and reporting that x-ray has. 

We created a gadget name overall test results, can I use that filter which I used inside the gadgets in test execution report under x-ray - reports feature to get the report and it should match the count with overall test results gadgets count, I mean each distributed status count should match with my report count(report contains different status that is Total tests, Pass, Todo, Fail, Executing and Aborted. I tried but it is showing no record found. But when I execute the filter in jql search box it is showing list of tests(Test cases). Let me know the way i approach is correct to get the report.

 

Thanks,
Vikas

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

Marketplace Partner Spotlight: AppLiger

This month the spotlight is on AppLiger. We caught up with Pavel Pavlovsky, CEO and Product Manager, to learn how the company started and what fuels the team's creativity.    Atlassian:...

336 views 0 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you