Inline Data Connection

inlinedataconnection

Properties

Name

Type

Required

Description

Name

Type

Required

Description

distinct

boolean

no

Should duplicate rows be removed.
Default is true, so if you require duplicate rows to me maintained set this to false.

Sub-tags

Content

None

parameter

Properties

Name

Type

Required

Description

Name

Type

Required

Description

name

string

yes

A unique identifier for the parameter

type

'string', 'numeric', 'date' or 'url'

yes

An indicator of how the data should be displayed on the client

label

string

yes

A user displayable label for the column

Sub-tags

None

Content

None

Notes

row

Properties

None

Sub-tags

Name

Type

Cardinality

Content

None

Notes

  • The number of cells should match the number of parameters.

cell

Properties

None

Sub-tags

None

Content

The value to be used for this cell, or null if null should be returned as this cells value. Note that you can also use xsi:nil="true" if you have the xsi namespace setup as described in configuration.

Examples

A simple inline data definition

<data:datadefinition id="connectionType"> <inlinedataconnection> <parameter type="string" name="key" label="Key" /> <parameter type="string" name="label" label="Label" /> <row> <cell>U</cell> <cell>Unverfied</cell> </row> <row> <cell>V</cell> <cell>Verified</cell> </row> </inlinedataconnection> </data:datadefinition>

A simple inline data definition using null

<data:datadefinition id="customerType"> <inlinedataconnection> <parameter type="string" name="label" label="Label" /> <parameter type="string" name="key" label="Key" /> <row> <cell>Domestic</cell> <cell>D</cell> </row> <row> <cell>Commercial</cell> <cell>C</cell> </row> <row> <cell>Unknown</cell> <cell>null</cell> </row> </inlinedataconnection> </data:datadefinition>

A data definition with duplicate rows maintained

<data:datadefinition id="duplicate.list"> <inlinedataconnection distinct="false"> <parameter type="integer" name="value" label="Value"/> <parameter type="string" name="label" label="Label"/> <row> <cell>11000</cell> <cell>Unique</cell> </row> <row> <cell>11001</cell> <cell>Duplicate</cell> </row> <row> <cell>11001</cell> <cell>Duplicate</cell> </row> </inlinedataconnection> </data:datadefinition>