ICEfaces
  1. ICEfaces
  2. ICE-4289

Selectively Include DataTable columns in DataExporter

    Details

    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.8.1
    • Fix Version/s: 1.8.2-RC1, 1.8.2
    • Component/s: ICE-Components
    • Labels:
      None
    • Environment:
      Exclude DataTable columns + DataExporter

      Description

      There should be a way to exclude DataTable columns in DataExporter

        Activity

        Hide
        Adnan Durrani added a comment -

        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

        Show
        Adnan Durrani added a comment - 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
        Hide
        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
        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.
        Hide
        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

        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

          People

          • Assignee:
            Adnan Durrani
            Reporter:
            Adnan Durrani
          • Votes:
            4 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: