Properties in detail

The properties object lists the fields in the document/table, with the rules for editing, displaying and processing.. There are a large number of options as shown by the list below. But few of them are mandatory.
- Key The field name. A special key of $ref is a reference, discussed here.
- Type: Number/integer/string/boolean/object/array
- Integer is treated the same as 'number', but is validated on input to be an integer.
- A type of 'object' indicates that there are sub-fields below it in the structure. For example an attribute of 'address' may have 'street','city', 'zip' below it. These are listed in a properties sub-object.
- A type of 'array' indicates an array of scalars or objects. All elements in an array must be of the same type
- Stringify: If the type is object this is a field name or a function that will be used to characterise the object.
- Friendly name: Used on forms - defaults to the attribute name which is 'humanised' - so 'updatedBy' turns into 'Updated By'.
- Description: Used as a tool-tip in the edit form.
- Permission: permission set allowed to view/update this field
- Model: This field is a foreign key and specifies the name of a linked table . The field will contain a primary key value for the linked table. Do not indicate type as the type of the database keys is assumed.
- Values: The values that this field can take. Can be an array, code/value pairs or function. If the field is a foreign key, then the linked table can be filtered and used to provide values.
- Input: Specifies how ther column is updated by the edit form.
- Type: text, date, select, etc
- Placeholder: Shown in empty fields
- Required: true/false (or use the required array in the parent level)
- Width: over-rides standard width
- Format: column or row
- Input type specific parameters: these are included in the input tag.
- Display: how the data item is to be displayed
- Type: e.g. date, date time
- Table heading: heading in table list
- Truncate for table list: for the table list only the first few characters can be shown
- Process: special processing, date created, dateupdated etc.
- Database : database-specific type. e.g. bigint. This is optional.
- Validation items based on JSON Schema standards. Minimum, Maximum, etc,
Next The test data