Suggestion

The Suggestion is an input field used to suggest data to user in a drop down based on the data keyed in. Moreover, users can use keyword search in this field. Once user drags a field of type Suggestion onto the entity, user must click on the edit icon to open the configuration window as shown below.

The Suggestion Configuration Settings are described below:

Property	Default value	Mandatory	Description
MF ID	System Generated number	Y	MF ID is unique and is generated by system automatically.
Source Tag			This field is used to insert the JavaScript at the Field level e.g.: readonly, onchange = validateNum(this) etc.
Max Length			Maximum number of characters allowed on this field
Size			Maximum size to be displayed.
Default Value			The default value for this field.
Table Name		Y	To define the table from where the data is retrieved dynamically.
Column Show		Y	To define the column whose value should be displayed in the list.
Condition			To define any condition for retrieving data.
Global ID			To define Global ID of the field.
Dependency Data
Depend Column			To define the column on which the data will depend on.
Sequence			To define the sequence of the column in the condition.
Field_ID	[FIELD_ID]		To define the database field mapped to this field on the smart form.
ShowFieldName	[SHOW_FIELD_NAME]	Y	To define the field label to be displayed on the screen. Clicking on the blue icon will auto generate the field name based on field id
Condition Tab	N		To define if this field trigger condition tab feature.
SearchCriteria	N		To define if this field is to be used as one of the search criteria in the search screen.
ShowSearch	N		To define if this field is to be one of the search results (in table)
SearchFromTo	N		To define if the field is to be searched in range in the search criteria.
SearchPreLike	N		To define if this field should allow wildcard search e.g. (%XXX)
SearchLike	N		To define if this field to allow wildcard search e.g. (XXX%)
SearchIgnoreCase	N		To define if this field is to allow search by ignoring case.
JoinSearchTable	N/A		Usually required when JOIN SQL is used to produce the search screen. Join with another table to show results
SearchFieldGroup	0		This setting is used to configure the position of the field in the search criteria screen horizontally (row).
SearchCriteriaSeq	0		To configure the position of field in the search criteria screen vertically (column).
ShowSearchSeq	0		To configure the position of the field in the search results.
Alignment	left		To set Text Alignment. It provides 3 options to choose from: right /left /center.
OnlyGuiFlag	N		To configure the field as a UI field. This field is not persisted into the database.
ViewFlag	N		Y- To view field in read/view mode in Edit screen.
KeepHistory	N		To configure the field values to have history information persisted into database.
FilterFlag	N		Used in 1-Many module to filter the records based on value of the field.
Authen	N		Enabling it, calls an ONEWEB authorization engine (IAM)
MergeFlag	N		To merge this field to the next column as well. Usually used to display a field across two columns
Validate Code	CHECK_NULL		Y - to make Validation check. CHECK_NULL- will check for null in the field before saving. CHECK_INTEGER - will check for integer value before saving. CHECK_DECIMAL - will check for decimal value before saving. CHECK_EMAIL_FORMAT - require user to input value in email format before saving.