Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    ExportAs and multiple value columns

    Hi,
    we are using SmartClient Version: v11.0p_2016-06-03/PowerEdition Deployment (built 2016-06-03) .
    we discovered that the fields in our .ds.xml files with multiple="yes" values, for example:

    Code:
    <field name="name_item_array" multiple="true" type="text" title="Item(s)" width="150">
    </field>
    get exported in XLS, CSV ou XLSX with brackets.
    So the values exported are, for example:

    database value: 'item1, item2, item3'
    export value: '[item1, item2, item3]'

    Is there a property to hide the '[' ']' when it's exported?

    #2
    Got a workaround!
    For anyone that may bump in this problem, here it is:
    Declared another field in the datasourceFile (.ds.xml) with the same SQL column, but without the multiple="true" attribute. Then, use that field to export the data instead of the old one.
    Code:
    <field name="name_item" nativeName="name_item_array" type="text" title="Veículo(s)" width="150" canSave="false">
    </field>

    Comment


      #3
      This is fixed and will be available for download in nightly builds since Dec 20 (tomorrow). The workaround will no longer be needed.

      Comment

      Working...
      X