Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.
Bug 1133533 - Dashbuilder should only export (XLS/CSV) data columns which is visible or configured by user, not for the entire data source
Dashbuilder should only export (XLS/CSV) data columns which is visible or con...
Status: VERIFIED
Product: JBoss BPMS Platform 6
Classification: Retired
Component: BAM (Show other bugs)
6.0.2
All All
medium Severity high
: ER2
: 6.1.0
Assigned To: Jan
Jan Hrcek
:
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2014-08-25 07:56 EDT by Musharraf Hussain
Modified: 2014-11-20 09:34 EST (History)
3 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed:
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)
XLScontainingolddata.png (202.12 KB, image/png)
2014-08-25 07:58 EDT, Musharraf Hussain
no flags Details
PanelEdition.png (190.54 KB, image/png)
2014-08-25 08:08 EDT, Musharraf Hussain
no flags Details
DeleteColumnPanelEdition.png (194.71 KB, image/png)
2014-08-25 08:10 EDT, Musharraf Hussain
no flags Details

  None (edit)
Description Musharraf Hussain 2014-08-25 07:56:40 EDT
Description of problem:
- The export (XLS/CSV format) functionality in the Dashbuilder currently exports all of the columns defined in the data source table for a report table in the UI as opposed to exporting only the columns that are currently visible or which has been configured in that table in the UI. Ideally, Dashbuilder should only export (XLS/CSV) data columns which is visible or configured by user, not for the entire data source.

Version-Release number of selected component (if applicable):
- BPMS 6.0.2

How reproducible:
- Always

Steps to Reproduce:
1. Log in to Dashboard Builder which should land you to the "Home" Page
~~~
http://localhost:8080/dashbuilder/
~~~
2. Click on "Sample dashboards" from your left hand panel.
3. Click on "Sales opportunities" and under that you would find "Sales report" as a tabular report. Click on "Sales report" now.
4. You should find a table containing lot of columns and they are fetched from "Sales dashboard demo" data provider which pulls those many columns from a data source and pushes it to the table which we are seeing right now.
5. On the upper and extreme right side of that panel where the table is shown , contains a small but greyed out button as shown in the private snapshot. Clicking it should bring down a drop-down. Click on "Edit content" option and it should show you the "Panel Edition" window as shown in screenshot "PanelEdition.png".
6. Now on the right hand side it shows you the columns which are displayed. After each column name there is a tiny symbol (probably the second option) which reads "Delete this column" , as shown here in "DeleteColumnPanelEdition.png" . Clicking on it will enable you to reduce the number of columns being displayed on your display table. Now try to delete as many columns as you want. Close the window and now after the panel is refreshed you should see the number of columns have been reduced , just as you wanted.
7. Now, try to do Export to xls or CSV , and you would find that the exported report still contains the entire table with those columns in it as well which you removed above . Refer to the screenshot "XLScontainingolddata.png" for reference.


Actual results:
- Dashbuilder exports all of the columns defined in the data source table.

Expected results:
- Only the selected or configured table columns should be exported.

Additional info:
- NA
Comment 1 Musharraf Hussain 2014-08-25 07:58:13 EDT
Created attachment 930440 [details]
XLScontainingolddata.png

XLScontainingolddata.png
Comment 3 Musharraf Hussain 2014-08-25 08:08:05 EDT
Created attachment 930442 [details]
PanelEdition.png

PanelEdition.png
Comment 4 Musharraf Hussain 2014-08-25 08:10:29 EDT
Created attachment 930443 [details]
DeleteColumnPanelEdition.png

DeleteColumnPanelEdition.png
Comment 7 Jan Hrcek 2014-11-20 09:34:04 EST
Now the export is working based on current configuration of table columns. Verified with BPM Suite 6.1.0 ER2.

Note You need to log in before you can comment on or make changes to this bug.