Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Xray : find the number of test assigned to each tester in a test execution


For the release of my product, I have a "test execution" which contains 180 test that I have assigned to 6 testers. I want to know the number of test asssigned to each tester. I tried with this jql search but it doesn't work :

issuetype = Test and issue in testExecutionTests("testexecutionkey","", "username")

Is it a bug or I misuse the jql search?


2 answers

Thanks for your answer

But it does not seem to work.

For exemple I have put the jql search : 

Issuetype = Test AND issue in testExecutionTests("CP-1959","", "yfaubert","false", "") 

It returns anaything while I have some assigned to the user : yfaubert (attached in the file)Capture d’écran 2021-04-09 120900.png

The issues itself are all assigned to user 'yfaulbert'?


We use another Process:


1 TestPlan with all Test, 3 Testexecutions (one per user) with all/partially testcases.


So we report Plan based. 


In fact in our Testexecs is just one assignee to all testrun testcases.


Is just simulated:


1 Exec, 4 Testcases. All Testcases are "mine" on Issuetype=Test. Inside the testexec 3 testexecutions are assigned to me, 1 to a colleague.




Issuetype = Test AND issue in testExecutionTests("PBT-19334","", "u48*wc","false", "")


Count 3 OK


Issuetype = Test AND issue in testExecutionTests("PBT-19334","", "u480*kg","false", "")


Count 1 OK


Thanks you for your answer 

1) But in my case, we have only one testexecution and in this testexecution we have several testcases which are assigned to different tester. In this case, how can we know the number of test assigned to each tester?


2) In your exemple above, what means "u480*kg" ?

@ 2) Thats just anonymous Usernames, theres a character instead of the * 


Which Version do you use? 

We use Jira v8.6.1

Hi @Nolwenn Paitier 


Please take note of one detail, don't know if it is the case, but this can generate some confusion.

In the JQL function, it filters by the Test Run Assignee, which is the user that actually run the Test and can be different from the Test Assignee and the Test Execution Assignee.

So, if you are aware of this and still the result is not right, it is best to please contact the Xray Support ( ) so that we can request additional information and help further.

Kind regards,
Rogério Paiva [Xray Support Team]



in my Opinion this should work. 


Issuetype = Test AND issue in testExecutionTests("JIRA-19334","", "u430112","false", "")




p3=Username (is there a way to define a couple of users?!)

p4=Defect or Not

p5=Creator/Assignee of the Issue in the Test Project, not the executioner (?) (does not work in combination: Creator, Testcase is mine, but another tester (p3) is the executioner.

Suggest an answer

Log in or Sign up to answer

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