cancel
Showing results for 
Search instead for 
Did you mean: 

Export Excel Datasheet with Timestamp

SOLVED
MisterB
Occasional Contributor

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 

1 ACCEPTED SOLUTION

Accepted Solutions
MisterB
Occasional Contributor

Re: Export Excel Datasheet with Timestamp

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

 

 

 

View solution in original post

1 REPLY 1
MisterB
Occasional Contributor

Re: Export Excel Datasheet with Timestamp

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

 

 

 

View solution in original post

New Here?
Join us and watch the welcome video:
Top Kudoed Authors