One to Many
Last updated
Last updated
(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 num1-1 module displays and manages data for one record in the database. It is based on row and column layout where you can simply add rows and columns as per your required design. Simply drag the 1-1 Module icon to the desired Tab to create a 1-1 Module.
The 1-1 Module configuration provides a list of property settings (1-5) as shown below:
- This icon is used to open "Module Configuration" property window. 1-1 Module configuration property window provides a list of settings which can be helpful in specific needs or special purposes. All 1-1 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-1 Module
Y
The appropriate name for a module.
Table Name
N/A
Y
The table associated with that module.
Template Code
Responsive2016
Y
Default to same as template Code used for an Entity.
Theme Code
Responsive2016
Y
Default to same as theme Code used for an Entity.
Show List Layout
GRID
Y
Show Grid Layout / Card Layout for the search result.
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 configure prefix that will be added to the beginning of the Key when automatically generated.
Postfix
N/A
This is used to configure suffix that will be added to the end of the Key when automatically generated.
KeyLen
N/A
Y
Key Len is to set size of key.
Sequence
N/A
Y
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.
SQL Select Row
N/A
This is used to write the manual SQL Command to be used to query data in 1-1 Module.
SQL Duplicate Function
N/A
-
View Mode Flag
N
Make your module in View/Read Mode only.
Paging Flag
N
Enables paging for search result.
Ordering Flag
N
Enables sorting in the headed of data grid.
Multiple table Flag
N
-
- This Icon is used to drag and drop modules to rows and columns in Multi Column Tab Form layout.
- This Icon is used to set the Column Layout which determines how many columns the module has. It has 3 options to choose from - 1 Column, 2 Column and 3 Column. User can select any options based on the layout requirement. User must click on 'Accept' button after choosing a desired option.
- This Icon is used to delete a Module from your Smart Form Layout.
- This Icon is used to add column or row inside your Module Layout. First Icon add Column in your module and second icon is used to add row. User can add multiple rows and columns inside module Layout on basis of smart form requirements.
