Table Creation

Field Descriptions

Field Name	Constraint	Description
Linked Project ID	Read Only	The project to which the table belongs
Table Name	Alphanumeric, lower case, underscore	The name of the table
Servlet Name	Alphanumeric, lower case, underscore	The name of the servlet serving data from this table
Servlet Alias	Alphanumeric, lower case, underscore	The servlet alias
Description	Alphanumeric, lower case, underscore	Freeform description for table
Type	Constrained drop list	Can be Data, Dual or Maintenance. Maintenance is a table that is a dedicated source for selectable list values. For example, the table tbl_static_lists is defined as Maintenance, as all the drop lists in the Generator App use it as the list source. Dual is a transaction table that serves as the source for a selectable list value. If a list is based on a table and the table is not set to type Dual or Maintenance, the dependent lists are not refreshed when the underlying table data changes.
Sub Type	Alphanumeric, lower case, underscore	An optional parameter which is usefull for special handling by customisations.
Has Form	Constrained list	If the table has a user interface. A table can be created without an associated servlet or user interface forms.
Row Seal Active	Constrained drop list	Generate the forms to provide the row lock feature, which will present a lock icon on a record display or show form. Clicking the lock icon will prevent further edits to the row data, and is permanent. This feature is similar to the Field property "Lock On Edit", except that all the row fields are locked, and the user will determine when the record is to be locked.
Is Audited	Constrained drop list	If TRUE, a mirror or audit table is generated, where audited field changes are recorded to
Permit Attachments	Constrained drop list	Permit the user to attach any file to the record.
Has Insert Form	Constrained drop list	Generate a form for the servlet to present row capture on the table
Permit Row Copy	Constrained drop list	Provide a COPY icon on the relevant SHOW form for each data row. This will copy all fields into a new row capture form, for editing before commit. The purpose of this feature is to speed up data capture on forms where most fields are the same, and only a few are different between records.
Has Update Form	Constrained drop list	Generate a form for the servlet to present a row update form based on the underlying data table
Has Search Form	Constrained drop list	Generate a form for the servlet to present a search form based on the underlying data table
Row Delete Permitted	Constrained drop list	Permit the user to delete the data row from the underlying table. Do not enable this for any table defined as TYPE=MAINTENANCE or TYPE=DUAL as it will break referrential integrity.
Has Public Access	Constrained drop list	Has this servlet deployed as Public, with no Tomcat login required to access it
Is Sub Form	Constrained drop list	Define as a child of a parent table
Search Limit	numeric	The maximum number of table rows returned to the user interface as a search result.
Parent Name	Alphanumeric, lower case, underscore	The name of the table of which this table is the child. Setting this parameter defines this table as a child table
Enable Edit on List	Constrained drop list	Make the search results editable. This is a productivity feature for editing multiple rows, while the data is on one screen.
Created By	Read Only	User name of row creator
Last Updated By	Read Only	User name that last modified the row
Creation Date	Read Only	Timestamp of table row creation
Modified Date	Read Only	Timestamp of last table row data edit

Sample Table Definition

User Guide

Getting Started

Self Registration

Password Reset

UI Elements

Projects List

Project Creation

Table Creation

Field Creation

Child Forms

Field Validations

Index Definition

Install Guide