The Popup is an input field used to display a list of data from a table in database as a popup window. It also has a text box for searching data based on the key. Once user drags a field of type Popup onto the entity, user must click on the edit icon to open the configuration window as shown below.
The Popup 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.
Popup Display Data
DB Column Name
DB Column
Show Name
Display name on popup window
Seq
Sequence of the fields
Alignment
Alignment of field on popup
Display
Yes
To define field as hidden field or display field.
SQL Command
Y
The SQL Command to retrieve the data to be displayed on popup.
Search Key
The field to be used for the search
Map Column
Y
The column whose value is mapped back to main field if selected
Map Column Display
Y
The column that is displayed as code on the main field
Map Description
Y
The column that is displayed as description on the main field
Source Tag
This field is used to insert the JavaScript at the Field level e.g.: readonly, onchange = validateNum(this) etc.
Text Size
Size of the Code field.
Max Length
Maximum number of characters allowed on this field
Map Entity
Show Go Button
Description Size
To define size of description field.
SearchLike in Popup
N
To define wildcard search in the popup.
UNClose Flag
N
To define if popup needs to close automatically on selection or not.
SearchIgnoreCase in Popup
N
To define if the search should ignore case.
Search Criteria Entity ID
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
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.