Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

inlinedataconnection

Properties

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

Anchor
parameter
parameter

parameter

Properties

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

Anchor
row
row

row

Properties

None

Sub-tags

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

Code Block
languagexml
<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

Code Block
languagexml
<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

Code Block
languagexml
	<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>