spatialdataconnection
Properties
Name | Type | Required | Description |
---|---|---|---|
entity | yes | Id if the entity that this data definition should use to generate its data. |
Sub-tags
Name | Type | Cardinality |
---|---|---|
parameter | 0..n |
Content
None
parameter
Properties
Name | Type | Required | Description |
---|---|---|---|
column | string | yes | The name of the column within the table that this parameter references (can be an sql function also) |
type | 'string', 'numeric', 'date' or 'url' | no (default 'string') | An indicator of how the data should be displayed on the client |
name | string | no (default lowercase value of column) | A unique identifier for the parameter |
label | string | no (default 'pretty' value of column) | A user displayable label for the column |
text | string | no | Only when type is 'url'. Specifies text to be displayed to the user instead of the actual url contents |
textcolumn | string | no | Only when type is 'url'. Specifies the column that contains text to be displayed to the user instead of the actual url contents |
Sub-tags
None
Content
None
Notes
- If no
label
is specified then it will be generated by formatting thename
, unless noname
is supplied, then it will be generated by formatting thecolumn
- Formatting involves converting any _'s to spaces, converting the first letter and any letter after a space to upper case and converting every other letter to lower case, e.g. "BOMB_DISPOSAL_METHOD" becomes "Bomb Disposal Method"
- Only one of
text
ortextcolumn
should be specified when type is 'url'
Examples
A simple spatial data definition generating name
and label
attributes based on the column
<data:datadefinition id="graffiti"> <spatialdataconnection entity="graffiti"> <parameter column="ID"/> <!-- name will be 'id', label 'Id' --> <parameter column="DESCRIPTION"/> <!-- name will be 'description', label 'Description' --> <parameter label="Created on" column="CREATED" type="datetime"/> <!-- name will be 'created' --> <parameter label="Modified on" column="MODIFIED" type="datetime"/> <!-- name will be 'modified' --> <parameter name="user" label="User" column="USERID"/> </spatialdataconnection> </data:datadefinition>