Fields

Fields is the column of a database table.

Fields

1. Name : Name of the column in the table

2. Label : Label to be used in the interface

3. Type : The data type of the field

4. Widget : The widget displayed in a form

5. Option Source : Options for the field

Type

The available types are:

1. String

2. Text

3. Integer

4. Number

5. Date

6. DateTime

7. Checkbox

8. TreeNode

9. TrackerType

10. User

Option Source

Option Source is a json data structure based on the type of the field.

String

If the widget is a dropdown, then “Option Source” can be a json array of options for the dropdown.

TrackerType

When field type is TrackerType, then “Option Source” can contain:

1. module : Module of the tracker the field refers to

2. slug : Slug of the tracker the field refers to

3. name_column : The column used to display the value in the drop down of the field

4. query : Query node to be used to query listing when searching to display drop down. Usually it is used to search on the name field that is used in the name_column. The json could be something like this:

   { 'like':{'name'} }