Forum Discussion

MisterB's avatar
MisterB
Champion Level 3
4 years ago
Solved

Export Excel Datasheet with Timestamp

Hi,

I have test cases that are being executed multiple times a day.  I can see the date and timestamp of the executions in the reports on-screen but when I export to the related dataset to Excel for further detailed analysis, the timestamp is not exported.  Is there a solution to this requirement?

Thanks, Andy 

  • Sharing the partial workaround recommended by the support team 

     

    ===================================================

     

    I am sorry to hear you are not getting enough information from the raw dataset. I will add this issue to our backlog and will get back to you as soon as we have it addressed.

     

    In the meantime, I can provide the following workaround if you are used to programming -

     

    If you usually execute tests on Test Cycles and given you know its keys, you can make a request to the following REST API endpoint and use the results according to your needs.

    • GET /testrun/{testRunKey}/testresults

     

    On our REST API, "testrun" means "Test Cycle". That means you will need to replace {testRunKey} with the Test Cycle key (for example, "YOURPROJ-C1").

     

    ===================================================

     

    As an example, the red text would be replaced the square brackets.  Below that, I've added an example of how it could look (note: the white spaces after "projectKey" are required)

     

    https://[YOUR JIRA INSTANCE]/rest/atm/1.0/testrun/[YOUR TEST CYCLE KEY]/testresults

     

    e.g. https://jira.abclimited.com/rest/atm/1.0/testrun/ABC-C100/testresults

     

     

     

1 Reply

  • MisterB's avatar
    MisterB
    Champion Level 3

    Sharing the partial workaround recommended by the support team 

     

    ===================================================

     

    I am sorry to hear you are not getting enough information from the raw dataset. I will add this issue to our backlog and will get back to you as soon as we have it addressed.

     

    In the meantime, I can provide the following workaround if you are used to programming -

     

    If you usually execute tests on Test Cycles and given you know its keys, you can make a request to the following REST API endpoint and use the results according to your needs.

    • GET /testrun/{testRunKey}/testresults

     

    On our REST API, "testrun" means "Test Cycle". That means you will need to replace {testRunKey} with the Test Cycle key (for example, "YOURPROJ-C1").

     

    ===================================================

     

    As an example, the red text would be replaced the square brackets.  Below that, I've added an example of how it could look (note: the white spaces after "projectKey" are required)

     

    https://[YOUR JIRA INSTANCE]/rest/atm/1.0/testrun/[YOUR TEST CYCLE KEY]/testresults

     

    e.g. https://jira.abclimited.com/rest/atm/1.0/testrun/ABC-C100/testresults