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.