Skip to content

Data Table

Data table control allows listing multiple records. Besides being similar to other content controls such as Table Content Control, it offers better performance and has built-in pagination. It also allows displaying links in the content.

Rules

Required for Group Enter any name into this area to specify a validation group for the related control. After that, when you enter this same validation group name into a Validation Group area on any action button of any task, it will be checked for validation whenever the action is selected on the form.

Section Name The name of section is for controlling read only or visible state of a section. If set to a value, this section can be configured in task properties.

Dynamic Rules

The dynamic rules section allows specifying format and warning messages of any element and section. It consists of two parts, one of them is for formatting rules, and the other one is for validation rules.

  • Formatting rules allow you to change the formats (text colour, background colour, style) and visibility of control depending on a condition.
    Further information can be found here.
  • Validation rules allow you to validate the data that the end user enters.
    Further information can be found here.

Data XPath to data model to be attached. If set to empty parent data element is used.

Bound XPath XPath of the element. If set to empty, it uses the parent XPath.

Row Id XPath Give a specific Id for each row by filling this box with an XPath.

Item XPath Items of a data table content change depending on this setting. Default is " * " which sets it to regard all items as in the same structure. If you want to use different contents for different items you should dictate it by specifying an XPath.

Hierarchy XPath In a nested XML node structure, for example, if your XML looks like the excerpt below, you may specify the starting node of the recurrence. In this example, Hierarchy XPath is "Folders".

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
<Folders>
    <Folder>
        <Name>text1</Name>
    </Folder>
    <Folder>
        <Name>text2</Name>
        <Folders>
            <Folder>
                <Name>text2a</Name>
            </Folder>
            <Folder>
                <Name>text2b</Name>
            </Folder>
        </Folders>
    </Folder>
</Folders>

Filter XPath Filters rows according to this Xpath. The rows will display if their Filter XPath return true.

Export to Excel This control allows you to export your records to excel. In order to accomplish this, all you have to do is, enable AllowExport in DataExchange and define the columns in this property.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
<DataExchange AllowImport="False" AllowExport="True">
        <Columns>
            <Column Caption="Form No" Type="Text">
                <XPath><![CDATA[FormNo]]></XPath>
            </Column>
            <Column Caption="Owner" Type="Text">
                <XPath><![CDATA[Owner]]></XPath>
            </Column>
            <Column Caption="Date" Type="DateTime">
                <XPath><![CDATA[FormDate]]></XPath>
            </Column>
        </Columns>
    </DataExchange>

Sort XPath Sorts rows with respect to this XPath.

Other

Allow Moving XPath Xpath to control item movement in the list. Please use "0" to disable for always.

Allow Move Up/Down XPath Xpath to control vertical item movement in the list. Please use "0" to disable for always.

Allow New XPath Xpath to control adding new items movement to the list. Please use "0" to disable for always.

Allow Delete XPath Xpath to control deleting items movement from the list. Please use "0" to disable for always.

Allow Delete All XPath Xpath to control and clear the list. Please use "0" to disable for always.

Other properties

  • Cut is used to move data table content.
  • Copy is used to copy data table content.
  • Delete is used to delete data table content.
  • XML is used to view or add XML of the data table content.
  • Convert is used to change data table content to other content controls.
  • Add new is used to add the new columns in to table.

Example

It is also possible to format the data that you want to show. To accomplish this you should use the Template property.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
<Column Align="Left" Type="Text" XPath="">
    <Label>
        <Content><![CDATA[Deadline Date]]></Content>
    </Label>
    <Template><![CDATA[{{format(DeadlineDate,'dd/MM/yyyy')}}]]></Template>
    <Footer>
        <Content><![CDATA[]]></Content>
    </Footer>
</Column>
<Column Align="Left" Type="Text" XPath="">
    <Label>
        <Content><![CDATA[Transaction Name]]></Content>
    </Label>
    <Template><![CDATA[<a href="#/workitem/{{Transaction/TransactionWorkItemId}}" target="_blank">{{Transaction/TransactionName}}</a>]]></Template>
    <Footer>
        <Content><![CDATA[]]></Content>
    </Footer>
</Column>