Issue 45388: Workflows excel export

issues
Status:closed
Assigned To:Guest
Type:Defect
Area:Sample Manager
Priority:2
Milestone:22.07
Opened:2022-05-02 12:40 by Matthew Bellew
Changed:2022-05-03 11:58 by Matthew Bellew
Resolved:2022-05-02 16:31 by ians
Resolution:Fixed
Support Ticket: 
Pull Requests:
Closed:2022-05-03 11:58 by Matthew Bellew
2022-05-02 12:40 Matthew Bellew
Title»Workflows excel export
Assigned To»ians
Type»Defect
Area»Sample Manager
Priority»2
Milestone»22.07
When I export excel from the Workflows page

a) It shows all tabs as selected by default, this is per spec. However, I kinda expected only the one to be checked since these are all the same data just filtered differently (discuss)

b) It actually only exports the "All Jobs" tab, regardless of which tab is currently selected.

2022-05-02 14:16 ians
Notify»Susan Hert;hannahb
The issue is all tabs for this grid are just filtered versions of the JobsListing table, as a result since we use the QueryName as the sheet name, the sheet just keeps getting overwritten for each "tab". Is there a better choice property to use for the sheet's name?

2022-05-02 15:19 Susan Hert
The client side certainly knows what the tabs are called, so I wonder if that could be an optional part of the export form, used in place of the query names. This grid is less useful to export in general, I think, since the most utility comes from being able to click on links, so I could also see not doing a tabbed export at all here, but that requires some explanation for why it's different, as would a change in the default selection.

2022-05-02 16:31 ians
resolve as Fixed
Statusopen»resolved
Assigned Toians»Matthew Bellew
I was able to pass a 'sheetname' parameter as part of the advancedoptions used to generate the export parameters.

2022-05-03 11:58 Matthew Bellew
close
Statusresolved»closed
Assigned ToMatthew Bellew»Guest