Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Is there a way to auto save query results to a CSV file?

Questions
Tags
Users
Badges
James Adams
(5●4●7) edited
Apr 03 '15, 11:36 a.m.
When you open a query in RTC, I know there's the button at the top right that will save the query results in a CSV, but is there a way to get the link that starts that download? I've tried viewing the HTML to get a link, but it's not listed on the a tag. 

With RTC having the limitation of not being able to query across multiple projects, I'm trying to come up with a solution to bring defects from across multiple project areas into 1 report that we can use in a daily status meeting. My plan is to download all the queries to CSVs, combine them into 1 CSV file, and then have charts built for them... If there is a more simple way to make this cross project query happen, I'm all ears.

0 votes

1 answer
6,520 views
0 votes

Accepted answer

Permanent link
sam detweiler
(12.5k●6●195●201) Apr 03 '15, 3:44 p.m.
see the answer here

https://jazz.net/forum/questions/131393/how-to-display-a-formatted-query-result-in-a-rtc-dashboard-external-content-widget
James Adams selected this answer as the correct answer

0 votes

Comments
James Adams
Apr 03 '15, 4:34 p.m.
 Thank you for the quick response Sam, I appreciate it. I don't think this will solve our problem however. My end goal in all of this is to take multiple queries from different project areas and combine them into 1 master set of results. From there, I'll need to build out reports, Total Defects based on their priority (A pie chart), Defects by project area (I can do this now with the queries), Defects created in the last x days across all projects, and defects open for more than x days across all projects. 

James Adams
Apr 03 '15, 4:39 p.m.
 Actually.. there is a tab in Excel, "Data", where you can insert data "From Web". This might actually work... :)

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,147
× 202

Question asked: Apr 03 '15, 10:36 a.m.

Question was seen: 6,520 times

Last updated: Apr 03 '15, 4:39 p.m.

Confirmation Cancel Confirm