stroom icon indicating copy to clipboard operation
stroom copied to clipboard

Download from Dashboard to allow download of source Query in some form [Enhancement]

Open burnalting opened this issue 7 years ago • 3 comments

When downloading from a table in a dashboard, it would have value to allow a user to specify that the source query for the table to be also downloaded in the 'Download Options' selection pop-up. The benefit is that if such data is offered to a external party, the search criteria is also offered at the same time in the same file.

In the case of exporting to Excel file type, it's recommended one export the query in some human readable form to a second tab of the excel file.

In the case of exporting to CSV/TSV file type, it's recommended one export to the query in some human readable form to a set of lines at the start of the CSV/TSV file with each line prefixed by a '#' character inferring the query is a 'comment'.

burnalting avatar Jan 17 '18 07:01 burnalting

@burnalting in v6 you can download the Query as JSON by pressing the download icon on the Query pane. Is this enough to close this issue?

stroomdev10 avatar Aug 23 '19 08:08 stroomdev10

The preference is to have a single download process, rather than three steps which I believe you are suggesting

  • Download data
  • Download query
  • Merge two manually

That said, if the Excel/CSV/TSV export function being used does not support downloading into multiple tabs, then so be it.

burnalting avatar Aug 23 '19 08:08 burnalting

Would definitely need to be an optional thing for CSV/TSV as some consumers of the file may not cope with comment lines.

at055612 avatar Aug 22 '25 14:08 at055612