1-Many) module displays and manages data fields for multiple records in the database. It shows data in tabular form. The One to Many (1-Many) module is based on grid and card layout design and allow users to handle large number of items and columns.
The 1-Many Module configuration provides a list of property settings with 2 icons as shown below:
- This icon is used to open "Module Configuration" property window. 1-Many Module configuration property window provides a list of settings which can be helpful in specific needs or special purposes. All 1-Many Module configuration settings along with their usage are listed in table below:
Module Item
Default value
Mandatory
Description
Module ID
N/A
Y
Module ID is the unique ID and it is generated by system automatically.
Module Name
1-Many Module
Y
The appropriate name for a module.
Table Name
N/A
Y
The table associated with that module.
Template Code
Responsive2016
Y
Default is set to same as Entity Template. No Edit Required.
Theme Code
Responsive2016
Y
Default is set to same as Entity Theme. No Edit Required.
Show List Layout
GRID
Y
Select GRID Layout or Card layout for the list for 1- Many.
Module Key
N/A
Y
This is set the field to be used as the Key to the Module.
Prefix
N/A
This is used to add to configure Prefix that will be added to the beginning of the key when automatically generated.
Postfix
N/A
Used to configure suffix that will be added to the end of the key when automatically generated.
KeyLen
N/A
Key Len is to set size of key.
Sequence
N/A
Y/N
Database Sequence to be used for key generation.
SQL Show List
N/A
This is used to set the manual SQL Command used to query data to display in Module in Tabular Format (Only used in 1- Many Modules).
SQL Work Queue
N/A
This is used to set the manual SQL Command to query data to display in Search Results. Only for 1-1 Modules
SQL Select Row
N/A
This is used to write the manual SQL Command to be used to query data in 1-1 Module. Only used in 1-1 Module.
SQL Duplicate Function
N/A
-
View Mode Flag
N
Set your module in View/Read Mode only.
Paging Flag
N
Enables paging for 1- Many Module.
Ordering Flag
N
Enabled sorting in the header of data grid.
Multiple table Flag
N
-
- This Icon is used to delete a Module from your Smart Form Layout.
