DataSourceField.exportTitle not working for DataSource.exportClientData

[claudiobosticco]

SmartClient Version: v11.1p_2018-05-02/Enterprise Development Only (built 2018-05-02)

Hello, please try this test case:

isc.ListGrid.create({
    ID: "countryList",
    width:800, height:250, top:75, left: 10,
    alternateRecordStyles:true,
    dataSource: worldDSExport,
    autoFetchData: true,
    fields:[
        {name:"countryName", title:"Country"},
        {name:"capital", title:"Capital"},
        {name:"continent", title:"Continent"},
        {name:"independence", type: "date", title:"Nationhood", format:"ddd MMMM dd yyyy", width:150},
        {name:"population", type: "number", title:"Population", format:",0"},
        {name:"gdp", title:"GDP", type: "float", format: ",0.00"}    ],
    showFilterEditor: true
});



isc.Button.create({
   ID: "exportButton",
   title: "Export",
   left: 320, top: 10,
   click: function () {
           worldDSExport.exportClientData([countryList.getOriginalData().get(0)], { exportAs: 'xls'})
   }
});

In the countryName field of the dataSource I've added an exportTitle attribute:

<DataSource
    ID="worldDSExport"
    tableName="worldDS"
    serverType="sql"
    recordName="country"
    testFileName="/examples/shared/ds/test_data/world.data.xml"
>
    <fields>
        <field name="pk"            type="integer"    hidden="true"            primaryKey="true" />
        <field name="countryCode"   type="text"       title="Code"             required="true"   />
        <field name="countryName"   type="text"       title="Country"  exportTitle="foo"        required="true"   />
        <field name="capital"       type="text"       title="Capital"          />
        <field name="government"    type="text"       title="Government"       length="500"      />
        <field name="continent"     type="text"       title="Continent"        >
            <valueMap>
                <value>Europe</value>
                <value>Asia</value>
                <value>North America</value>
                <value>Australia/Oceania</value>
                <value>South America</value>
                <value>Africa</value>
            </valueMap>
        </field>
        <field name="independence"  type="date"       title="Nationhood"          />
        <field name="area"          type="float"      title="Area (sq km)" />
        <field name="population"    type="integer"    title="Population"          />
        <field name="gdp"           type="float"      title="GDP ($M)"            />
        <field name="member_g8"     type="boolean"    title="G8"                  />
    </fields>

    <operationBindings>
        <operationBinding operationType="fetch" operationId="customJSONExport">
            <exportResults>true</exportResults>
            <exportAs>json</exportAs>
            <exportFilename>Results.txt</exportFilename>
            <lineBreakStyle>dos</lineBreakStyle>
        </operationBinding>
    </operationBindings>

</DataSource>

You'll see that the exportTitle is not used in the excel file.

[Blama]

Hi all,

this might be related to this one.

Best regards
Blama

[claudiobosticco]

thanks Blama, actually it's fixed using latest build:
SmartClient Version: v11.1p_2018-06-12/Enterprise Development Only (built 2018-06-12)

[claudiobosticco]

SNAPSHOT_v12.1d_2020-01-27/Enterprise Development Only

Hello Isomorphic , it seems that the problem of post #1 is still present if I use ds.exportData instead of ds.exportClientData

[Isomorphic]

Apologies for the delay. This is fixed now and will be available for download in nightly builds since Feb 26 (today).