Configuring Datatable

How to configure datatables in InnowayIT application?

Datatables provide a way to translate data into information by interpreting data attributes through column header and information links next to them . They also provide many cool features enabled by JavaScript, such as full table search, field sorting, pagination and export.

figure 1: example of a datatable

To manage datatables navigate to Administration > Datatable. Search the datatable you want to configure in the search box. Click on relationship icon to see all the keys of the datatable.

To configure datatables select the Datatable object in the Configuration Tool sidebar. A table will open to list all the datatables. Select the datatable to be modified and click the update button. To create a new datatable click on Create New button.

Datatable configuration metadata is retrieved by front end via API

/table/metadata/:objectname

Following table contains a list of datatable attributes:

#	Attribute	Type	Purpose
1	Order By	Integer	Determines the order in which the column will appear in the datatable
2	Key	Text	Unique name of table column. This is the key in API.
3	Caption	Text	Display name of column
4	Type	Text	Possible values: flag to show Tick or Cross icon, date to format date
5	FieldType	Read only	Data type of table column. For information purposes
6	LOV	Text	LOV Type to obtain list of values from API
7	Drill Down Field	Text	The ID field to drill down to another object.
8	Drill Down Table	Text	The object where the drill down will navigate to
9	Width	Integer	Width of the field. Default is 150
10	Info	Flag	To show info icon in the column header
11	Tree View	Flag	To enable tree view enable this flag for the child field. Table ID is always the parent
12	Show	Flag	To display the column in the datatable
13	Drill Down	Flag	To enable drill down
14	Score Highlight	Flag	To format score field
15	Highlight	Flag	To highlight any field which LOV. Icon and color should be setup for the LOV Type mentioned in the LOV attribute #6 above
16	Status	Flag	Status of the field. If the field is deleted the status will be Inactive and the field will not appear in the datatable metadata API
17	Action	Icons	Edit and Delete icons. Only soft delete is allowed.