Details
-
Type:
New Feature
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 1.8.1
-
Component/s: ICE-Components
-
Labels:None
-
Environment:Exclude DataTable columns + DataExporter
-
ICEsoft Forum Reference:
-
Affects:Documentation (User Guide, Ref. Guide, etc.), Sample App./Tutorial
Description
There should be a way to exclude DataTable columns in DataExporter
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Adnan Durrani [ adnan.durrani ] |
| Salesforce Case | [] | |
| Fix Version/s | 1.8.2 [ 10190 ] | |
| Affects | [Documentation (User Guide, Ref. Guide, etc.), Sample App./Tutorial] | |
| Affects Version/s | 1.8.1 [ 10170 ] |
| Repository | Revision | Date | User | Message |
| ICEsoft Public SVN Repository | #19183 | Thu Aug 20 22:23:20 MDT 2009 | adnan.durrani | Fix for New "includeColumns" attribute added, which takes comma separated column indexes. Which lets you specify the order and # of columns to be added to the generated output. |
| Files Changed | ||||
MODIFY
/icefaces/trunk/icefaces/component-metadata/src/main/resources/conf/ice_cust_properties/cust-dataExporter-props.xml
MODIFY
/icefaces/trunk/icefaces/component/src/com/icesoft/faces/component/dataexporter/DataExporter.java
|
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Resolved [ 5 ] |
| Resolution | Fixed [ 1 ] |
How to use it?
It takes comma separated column indexes. Let say if there are 6 columns in the table and you want to add only 1st, 4th and 6th column to the generated output, the code snippet would look like this:
<ice:dataExporter includeColumns="0,3,5"... >
The column order of the above example can be changed a well:
<ice:dataExporter includeColumns="5,0,3"... >
By default all columns will be included to the output in the default order.
Note: index is 0 based.
Show
Adnan Durrani
added a comment - How to use it?
It takes comma separated column indexes. Let say if there are 6 columns in the table and you want to add only 1st, 4th and 6th column to the generated output, the code snippet would look like this:
<ice:dataExporter includeColumns="0,3,5"... >
The column order of the above example can be changed a well:
<ice:dataExporter includeColumns="5,0,3"... >
By default all columns will be included to the output in the default order.
Note: index is 0 based.
Show
Joanne Bai
added a comment - Tested on ICEfaces trunk 19184 + Tomcat6.0
verified with success on FF3.5, Opera9.64
testing on IE is blocking by ICE-4223 . But if saving the exported file to the correct type (excel in the test app), file also contains correct/expected data.
Test app added to repo\qa\trunk\Regression\ ICE-4289
| Fix Version/s | 1.8.2-RC1 [ 10210 ] |
| Summary | Exclude DataTable columns in DataExporter | Selectively Include DataTable columns in DataExporter |
| Salesforce Case | [] |
| Status | Resolved [ 5 ] | Closed [ 6 ] |
new attribute added to the dataExporter component named as "includeColumns", Which lets you specify the order and # of columns to be added to the generated output.
Modified: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\dataexporter\DataExporter.java
Modified: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\ice_cust_properties\cust-dataExporter-props.xml
Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component-metadata\src\main\resources\conf\ice_cust_properties\cust-dataExporter-props.xml
Sending content: D:\work\development\head\svn\ossrepo\icefaces\trunk\icefaces\component\src\com\icesoft\faces\component\dataexporter\DataExporter.java
Completed: At revision: 19183