Is there a JQL that can export the test run lists?

[Tracey Wiech]

I have a large test run and I tried to export to csv but not all of the tests will export.  I tried to create a query but I could not find what I needed.

[Laurie Sciutti]

I'm confused.  @Tracey Wiech ~ I thought you weren't using the X-Ray add-on but it sounds like you are...?  If so, did you have a look here:  https://docs.getxray.app/display/XRAY/Export+Tests+using+JIRA+built-in+features ?

[Tracey Wiech]

@Laurie Sciutti Yes I am using Xray and I did look at the link you sent and that is not what I am looking for.  I don't want to export the test I was to export the test run list or the execution list.

[Laurie Sciutti]

Hi @Tracey Wiech ~ run the appropriate JQL (including issuetype = "Test Execution" ) and export to csv (include all fields or just add the columns you want). 

If you're hitting a max export (I believe 1000 is the default), you may need to export in chunks (or limit based on other criteria, like only those executions associated with a particular test): 

issuetype = "Test Execution" and issue in testTestExecutions('ABC-123')

[Tracey Wiech]

@Laurie Sciutti Let me try that.  I tried something close to that and it didn't work.  There was something about the testTestExecutions(ABC-123)  that doesn't work anymore. 

I tried this project = RSUITE30 AND issuetype = "Test Execution" and issue in testTestExecutions(RSUITE-6163)

I receive a Unable to find JQL function 'testTestExecutions(RSUITE-6163)

[Tracey Wiech]

@Laurie Sciutti I also tried this:

project = RSUITE30 AND issuetype = Test and issue in testExecutionTests(RSUITE-6164)

and received the same error.

I think the testExecutionTests not working has something to do with not working in Jira cloud

[Laurie Sciutti]

Hi @Tracey Wiech ~ if you're using the X-Ray add-on, have a look here:  https://docs.getxray.app/display/XRAY/Export+Tests+using+JIRA+built-in+features 

If not, what are you using?

[Tracey Wiech]

@Laurie Sciutti I am not using any add-ons.  I really would like a query that I can use to export the test execution results or the test run results.

[Kelly Arrey]

Hi @Tracey Wiech can you give us some more context? Jira filters return Jira tickets. Are you mapping Test Cases to Jira tickets or what? What are the attributes of these Jira tickets? Thanks,

[Tracey Wiech]

@Kelly Arrey  Hi Kelly - I have a Xray Test Execution which has a Jira # or the Xray Test Run which has a jira # and the Tests are linked to those.  I can retrieve the list of test executions by sprint but it does not show the Test which are associated.  For example I can do a query for an Epic and it shows the related items.  The test execution and test runs do not.  That I can see.  If I export either all the data does not export.

[Kelly Arrey]

Hi @Tracey Wiech Oh, I don't use Xray, sorry I can't be more help.