Parameters
| Parameter | Description |
|---|---|
| name (required) | The string type name of the column, which must be unique across the reference table. |
| type (required) | The allowed data type for values in the column. Valid values are Text, Integer, Float, and Date.
|
| primary-key-constraint | A boolean value that specifies whether the value in the column uniquely identifies
the row in the reference table. The default value is false. A
PrimaryKey="true" column cannot have NULL value.
|
| not-null-constraint | A boolean value that specifies whether NULL is an accepted value for the column.
The default value is false, meaning that the column can be left
blank.
|
| selective-sync | A boolean that specifies whether the column contains the user names of mobile
client users. The default value is false.
|
| export-dateformat | A dtf datetime literal that specifies the format to be used for the
Date type value of the column when the reference table is exported as an Excel spreadsheet. The default format is
yyyy-MM-dd HH:mm:ss.
|
Remarks
There are certain limitations to naming columns in reference tables: they can contain ASCII characters (basic Latin letters, digits, the dollar sign, and underscore), but no “/”, “\”, or “. ”, or characters that are not permitted in file names, and cannot end with a space or have more than 64 characters.
If you set a column's PrimaryKey attribute to true, you must explicitly
set its NotNull attribute to true also.
A maximum of one reference table column can be marked with the
AgentName="true" attribute, which is used to implement selective synchronization.
The export-dateformat attribute is only valid on columns with a Date
type.
Sample
<Reftab Name="draftboard" xmlns="http://schemas.mobilengine.com/reftab/v1" Push="true" Notify="true">
<Columns>
<Column Name="id" Type="Integer" PrimaryKey="true" NotNull="true"></Column>
<Column Name="playername" Type="Text" AgentName="true" NotNull="true"></Column>
<Column Name="birthdate" Type="Date" DateFormat="dd-mm-yyyy"></Column>
<Column Name="pointaverage" Type="Float"></Column>
</Columns>
</Reftab>