Dynamic

The Dynamic List is an input field used to display a list of values dynamically as a dropdown. Once user drags a field of type Dynamic List onto the entity, user must click on the edit icon to open the configuration window as shown below.

The Dynamic List 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.
Default Value			The default value for this field.
Source Tag			This field is used to insert the JavaScript at the Field level e.g.: readonly, onchange = validateNum(this) etc.
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.
Column Value		Y	To define the column whose value will be used as the value of selected data.
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.
Search Criteria	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.